SMF Support > Install and Upgrade Help

how to split SQL backup

(1/1)

warhonowicz:
Hi,

I am trying to move my forum to a new host (and domain). I have copied all files via ftp to my PC and also make a backup of the database via phpMyadmin. Now, the problem is, the backup has given me a 32MB file but (at least on the new host) I can only import files up to 16MB. Is there a way to split the backup into several, smaller files?

Thanks,
Arnold

Suki:
As a simple hack, you can back up a single table at once.

You can clean out the log tables to reduce the size too.

Mostly the biggest tables are _members and _messages, you can export those tables individually and then export the rest of the tables.

You can also use tools like http://www.ozerov.de/bigdump/

You can also ask your host to do the move for you.

warhonowicz:
How do I backup just one table? All I have on the export tab is the option to select the database, but not individual tables?

Thanks

Suki:
Do you use phpmyadmin to access your database?

Enter phpmyadmin, select your database, click on export, on Export Method: select custom, a select field will appear, just select the single table you want to download, leave all the other values as they are and click "go", thats pretty much all.

warhonowicz:

--- Quote from: Suki on July 24, 2012, 10:53:41 AM ---..., select your database, ...

--- End quote ---

I didn't select the database first ... my mistake ... thanks

Navigation

[0] Message Index