Part of the transfer or migration of a website many times involves a database. If you are on an “ix” server, SSH is a great way to backup your MySQL database.
Here’s how you do it:
Using SSH, navigate to your httpdocs or public folder on your server where the website resides.
Use the following command.
mysqldump –opt -u theusername -p thedatabasename > /path/to/backupname.sql
This creates a copy of your database.
Now, you can transfer that database backup to your new server.