Diff for "désert/MySQL" - MoinMoin DesktopEdition

Differences between revisions 1 and 4 (spanning 3 versions)

howto-copy-mysql-database-remote-server

mysqldump -u user -p'password' db-name foo | ssh user@remote.box.com mysql -u user -p'password' db-name foo
mysqldump -u username -p'password' db-name | ssh user@remote.box.com mysql -u username -p'password db-name

http://www.cyberciti.biz/tips/howto-copy-mysql-database-remote-server.html

http://www.hackhowtofaq.com/blog/how-to-backup-mysql-db-remotely/

http://www.thegeekstuff.com/2008/09/backup-and-restore-mysql-database-using-mysqldump/

Full backup

Edit the root users mysql home environment configuration

 ~/.my.cnf

# Insert the following into the my.cnf file

[mysqldump]
user = mysqldbusername
password = mysqldbpassword

chmod 600 ~/.my.cnf

Cron

30 12  * * * mysqldump -u mysqlusernamehere -h localhost --all-databases > /home/backups/mydatabasename/$(date +"%F-%H%M")_mydatabasename_mysql_db.sql

-  ⇤ ← Revision 1 as of 2015-11-05 14:59:45 → 
  Size: 547
  Editor: localhost
  Comment:
+   ← Revision 4 as of 2018-10-26 06:44:42 → ⇥
  Size: 977
  Editor: localhost
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 15:
+== Full backup ==
=== Edit the root users mysql home environment configuration ===

{{{
 ~/.my.cnf

# Insert the following into the my.cnf file

[mysqldump]
user = mysqldbusername
password = mysqldbpassword
}}}

  * chmod 600 ~/.my.cnf

=== Cron ===
{{{
30 12  * * * mysqldump -u mysqlusernamehere -h localhost --all-databases > /home/backups/mydatabasename/$(date +"%F-%H%M")_mydatabasename_mysql_db.sql
}}}