MySQL DB Splitter....

[Krank]

Guys I need your help with something, I just moved my forum, and I need an application to split my database to parts (2 MBs).

[igorw]

I just spent half an hour on this...

http://phpbbmodders.net/pastebin.php?mode=view&s=21&highlight=1

This line:

Code: Select all

@ini_set('memory_limit', '50M');

is because the sql file is pretty large and will require a lot of memory. If you get a memory limit, try putting it up to 100M and close some programs. Maybe run it on a real server if your own comp is too weak.

The function call:

Code: Select all

split_sql_file('backup.sql', './sql/', pow(1024, 2) * 2);

has "pow(1024, 2) * 2" as third argument, which you could also write as "1024 * 1024 * 2". 1024 * 1024 bytes is a megabyte, so in my example it will split the files into 2 megabyte files.

Enjoy!

[Krank]

ohhhhhhh thanks man, thanks a lot, trying it now

[MarkTheDaemon]

If you are looking to restore the database, [url=http://www.ozerov.de/bigdump.php]bigdump[/url] should work pretty well as well.


Mark