L lenney Active Member 669 2008 1 0 Feb 19, 2009 #1 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
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
G Golden Falcon Active Member 867 2008 16 0 Feb 19, 2009 #2 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)
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)
S StupidGlitch Active Member 2,577 2008 538 0 Feb 19, 2009 #3 Notepad won't open big database SQL files.
G Golden Falcon Active Member 867 2008 16 0 Feb 20, 2009 #4 You can use http://notepad-plus.sourceforge.net/uk/site.htm to open a file that large.
S SplitIce Active Member 2,474 2008 240 0 Feb 20, 2009 #6 Use mysqldump. and then import with file.sql > mysql -uuser -ppass db
L lenney Active Member 669 2008 1 0 Feb 20, 2009 #7 cheers people managed to do it with bigdump run it all night and it never cut out