How can I migrate large database files ?

If you have large database file, which you want to import, but you are not able to do so, through the database manager, you can try the following method to import the database via the SSH command line console. You might a server timeout error while importing a large database file or any other file, this is due to certain server security settings. To avoid these errors and to import the database, you can also try the following :
Step 1 : Enable the SSH Console access for the site you wish to import the database to. You can enable and login to the SSH console as mentioned here : Enable SSH access

Step 2 : Open the ‘wp-config.php‘ file from the ‘public_html’ folder of the site. You can use any editor to open the wp-config file with. For this example we will be using the ‘nano‘ editor.

nano wp-config.php

You should see the database details in the file like this

define('DB_NAME', 'd_2APK3T');
define('DB_USER', 'u_2APK3T');
define('DB_PASSWORD', 'JfdrrzybIvCBh');
define('DB_HOST', 'localhost');
$table_prefix  = 'wp_';

Note down the ‘DB_USER‘, ‘DB_PASSWORD‘ and ‘DB_NAME‘ values.

Now exit the ‘nano’ editor using control+x key combination (Remeber this command will be different if you are using a diffrent editor)

Step 3 : Next download the large database file which you wish to import to the site’s public_html folder. You can do this via sftp manager like ‘FileZilla’ or through SSH command line using the ‘wget’ or ‘curl’ commands.
For example :

wget http://_URL_of_file

Step 4 : Next we will use the ‘mysql’ command to import the database into the site database. It is advisable before doing this, that you backup the current database.
To import the database, we will use the database details that we got from step 2.

mysql -u {DB_USER} -p{DB_PASSWORD} {DB_NAME} < name_of_the_file_to_be_imported

Please note that there is no space between '-p' and the database password.

If you an error like, the table already exists, you can try again after deleting all the database tables from the Database manager.

If you are still unable to import the database, please feel free to contact our support team, and we will be happy to do it for you.

buy dust mask venice, n95 mask is used for, charcoal face mask is blackface, osha respirator medical questionnaire, coronavirus market volatility, does n95 filter protect against smoke, dust mask safety rating, who can wear a n95 mask, wind resistant face mask, adjustable face shield, how to fit test for respirator pictures, japanese face mask armor, why does darth vader need a respirator, white cloth face mask, cpr face shield key chain, type of disposable face mask, why do some people wear face masks in the streets, 3m aura n95 1870 mask, doctor face mask name, face ski mask, when should i use a full face respirator with voc, bear face mask roblox, how often should i use lush face mask, how to make homemade face mask to sell, hairspray face shield designs, younique face mask, cute surgical masks, what is a n100 respirator, coronavirus cell to cell, air respirator mask respiratory precautions, what is an n disposable respirator, cardinal procedure mask versus surgical mask, dust mist filtering respirator, surgical mask guro, airborne precautions require the use of an n95, face masks to make, activated carbon respirator,