mysql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
mysql [2019/03/28 13:49] – [Restore a backup] danimysql [2019/03/28 13:50] (current) – [Manually create a backup] dani
Line 46: Line 46:
 In case, you have to create a backup manually (without automysqlbackup script), you can do it like this: In case, you have to create a backup manually (without automysqlbackup script), you can do it like this:
  
-  * Using ''gzip'':<code bash>+  * Using ''gzip'' and backup all databases:<code bash>
 mysqldump --all-databases -q | gzip -c > mysql-20100212.sql.gz mysqldump --all-databases -q | gzip -c > mysql-20100212.sql.gz
 </code> </code>
-  * Using ''bzip2'':<code bash>+  * Using ''bzip2'' and backup all databases:<code bash>
 mysqldump --all-databases -q | bzip2 -c > mysql-20100212.sql.bz2 mysqldump --all-databases -q | bzip2 -c > mysql-20100212.sql.bz2
 </code> </code>
  • mysql.1553777379.txt.gz
  • Last modified: 2019/03/28 13:49
  • by dani