GoFuckYourself.com - Adult Webmaster Forum - View Single Post - Hiring Are You Experienced With PHPmyadmin?

floresmedia · 06-29-2017, 10:09 AM

Would be easier to back up your databases via terminal using mysqldump. If your databases are big then you do not want to export via phpmyadmin.

Here is the terminal command: mysqldump database_name > database_name.sql

Just make sure you CD into what ever directory you want to back up to.

Then just ftp/sftp into your server and back up all files including you .sql files that have just been created by the terminal command. Then move all files to the appropriate location in your new server and then open up a terminal window and restore your databases using mysqldump again.

06-29-2017, 10:09 AM
floresmedia Confirmed User Industry Role: Join Date: May 2017 Location: California Posts: 133	Would be easier to back up your databases via terminal using mysqldump. If your databases are big then you do not want to export via phpmyadmin. Here is the terminal command: mysqldump database_name > database_name.sql Just make sure you CD into what ever directory you want to back up to. Then just ftp/sftp into your server and back up all files including you .sql files that have just been created by the terminal command. Then move all files to the appropriate location in your new server and then open up a terminal window and restore your databases using mysqldump again. __________________ Ditch traditional hosting an go cloud. I can help. Contact: [email protected]