User Tools

Site Tools


backup_database_from_remote_server

This is an old revision of the document!


Backup Database from Remote Server



First you will need to install the MySQL Client Tools:

  sudo apt-get install mysql-client (this will install among other things mysqldump)


Now you can do the backup, there are a couple of considerations:

1. Your user must have the rights (normally user accounts are localhost limited) I created a user with global rights '%'

Comment these lines in /etc/mysql/my.cnf
skip-networking
bind-address = 127.0.0.1

2. You must have rights to write to the target directory (easily overlooked)
3. The backup might take a few minutes, be prepared to wait.

  Now we can execute the following command:
  
  mysqldump --host ipaddress -P port -u user -pPassword databasename > savename.sql
  
  mysqldump --host 10.0.0.1 -P 3306 -u root -pRootPassword gallery > gallery.sql



backup_database_from_remote_server.1481664529.txt.gz · Last modified: 2023/03/09 22:35 (external edit)