database problem

[lenney]

i need some sort of tool to split a database in half its 400mb unziped and my server mysql dies when trying to use bigdump to import it

need it chopped so i can upload it

lenney Reviewed by lenney on 19th Feb 2009. database problem i need some sort of tool to split a database in half its 400mb unziped and my server mysql dies when trying to use bigdump to import it need it chopped so i can upload it Rating: 5

[Golden Falcon]

You can't compress it with bzip2 or gzip?

Also you can simply edit it with notepad, just make sure you cut it after a semicolon (if thats the syntax, don't remember for sql)

[GeeZus]

Notepad won't open big database SQL files.

[Golden Falcon]

You can use http://notepad-plus.sourceforge.net/uk/site.htm to open a file that large.

[Azo]

Why don't you use a console to import it?

[SplitIce]

Use mysqldump. and then import with
file.sql > mysql -uuser -ppass db

[lenney]

cheers people managed to do it with bigdump run it all night and it never cut out