How to import large mysql database into server/website

[Administrator]

This thread helps you to import large database backup into your new server or hosting.

1. First download your backup using PHPmyadmin>> Export Option. Choose compressed(gizp) export when you export the database. By this way you may get 25MB size file if the original mysql file is larger than 200MB. Check this video for more help,
2. Now download (https://www.ozerov.de/bigdump/) Bigdump zip file from their official website and extract the bigdump.php file.
3. Now change the configuration section with the correct database information and password to dump your new files into server.
4. Now upload this new edited bigdump.php file to your webhost or server ( which should be accessible.)
5. This usage page helps you in detail, what to do next, https://www.ozerov.de/bigdump/usage/

This method not just for cpanel users, this works for any mysql based control panel or own server, all you need a phpmyadmin.

 

[Administrator]

the dumb php file is more configurable, whenever some error occurs while dumping database into your new server, make sure you read those information follow the error. Any help just post it in here, i will try my best to help you.