How To Do A MYSQL Database Backup Using SSH

If you’re using Magento, you know how big your MYSQL database can be. We have one on one website that is almost 200M, and that’s not really a big website at this time. PHPMYADMIN will not export a database that big, so you’re going to have to use SSH (Telnet).

1. Using SSH, login to your server under the primary IP address. Use you super user password. Change directory to where you want to store the backup of your MYSQL database.
2. Once there, type in: mysqldump -u DatabaseUserName -p –opt DatabaseName > backupfilenameyouwant.sql (put in your own values for the database)
3. Hit return.
4. You will be prompted for your database password, go ahead and type that in.
5. Hit return. Give it a few seconds and then you can FTP to your directory where you were and should see your Magento Database backup.