@fromrachel
Using Bigdump to restore large database
Bigdump is very simple to use, follow these steps to finish uploading your database to your web hosting.
1/ Download
the latest version Bigdump here.
2/ Unzip the file you will be bigdump.php. Upload to your host so that you can access domain.com/bigdump.php.
3/ Using cPanel or DirectAdmin, set up MySQL Database and MySQL username with your password, do not forget to make a connection to the User in the Database.
4/ To be careful: You should go to cPanel and transfer the database to utf8_general_ci default font error after upload.
5/ You upload the database to peer file bigdump.php.
6/ according to the MySQL configuration file bigdump Database, username as you did in step 3 in the following information:
Code:
$db_server = 'localhost';
$db_name = '';
$db_username = '';
$db_password = '';
Do not forget to avoid the error, you need to set other parameters as below:
Code:
$db_connection_charset = â€; -> You need to enter the parentheses is utf8
define (‘MAX_QUERY_LINES',300); -> You need to change the 300 to 900
7/ Now and select Import domain.com/bigdump.php access to the database that you have set up and click to go
In other words, you can use mysql dumper tool, it is the same Bigdump but stronger, an effective tool to restore large databases
Good luck!
