Download a remote MySQL database
Download a remote MySQL database using
mysqldump dump. The output of the dump is compressed using gzip and the output of the zip is downloaded into the file
Copy local database to remote server
Upload a local MySQL using SSH. The remote database
dbname and the database user (
dbuser) must have permissions to the database. The remote database must also be empty.