How to backup MySQL database on a remote server?

mysql database backup remote-server database-restore
john smith picture john smith · Oct 23, 2013 · Viewed 53.9k times · Source

I have a MySQL database existing on a remote server. I only have connection privilege. I don't have FTP access to the server, and I need to do a complete dump of the database. I have tried mysqldump, but the issue is that it is creating the output on the server and as I don't have FTP I can not get the output from the server.

How can I do a clean backup and get the dump in my local machine(of course, the backup should be restored in my local machine)?

Answer

Barmar picture Barmar · Oct 23, 2013

You can specify the server name as an option to mysqldump:

mysqldump --host servername dbname > dbname.sql

Related questions

mysqldump with create database line

I'm in the process of moving my files onto another computer, and one thing I would like to do is to transfer the data in my MySQL database. I want to dump the databases into .sql files, but also have …

Read More
MySQL Database backup automatically on a windows server

Is there a way to back up MySQL database automatically at certain times of the day for designated servers or send an email with an attachment.. Which ever do you think is the best and safest way to achieve this?

Read More
Simple Backup and Restore for mysql Database from Java

How to backup a mysql database from a java code such that: It's saving path is dynamically allocated. Spaces in Path do not create problems. Path is generated using the executing jar file. DBname,DBusername or DBpass are dynamically allotted. …

Read More