Differences

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

--- mysql [2019/03/09 10:25] – [Get environmet] admin
+++ mysql [2019/03/28 13:50] (current) – [Manually create a backup] dani
@@ Line 9: / Line 9: @@
   - Get the user and password to access the MySQL database. This is usually the user ''root''!
   - Check for the database data directory:<code bash>mysql -e "show variables;" | grep '^datadir'</code>
-  - Check, if the binlog option is enabled:<code bash>ls $(mysql -e "show variables;"|awk '/^datadir/ {print $NF}')/|grep 'bin.index'</code>If this command does not result with a filename, the ''binlog'' is not activated!
+  - Check, if the binlog option is enabled:<code bash>ls $(mysql -e "show variables;"|awk '/^datadir/ {print $NF}')/|grep 'bin.index'</code>If this command does not result with a filename, the ''binlog'' option is not activated!
-  - Amount of data:<code bash>du -sh $(mysql -e "show variables;" | awk '/datadir/ {print $NF}' | grep '^\/')</code>
+  - Amount of data:<code bash>du -sh $(mysql -e "show variables;" | awk '/^datadir/ {print $NF}')</code>
   - Socket:<code bash>mysql -e "show variables;"|grep '^socket'</code>
   - Network port:<code bash>mysql -e "show variables;"|grep '^port'</code>
@@ Line 42: / Line 42: @@
 gzip -cd daily_<dbname>_2019-03-09_05h00m_Saturday.sql.gz | mysql <dbname>
 </code>
+===== Manually create a backup =====
+In case, you have to create a backup manually (without automysqlbackup script), you can do it like this:
+  * Using ''gzip'' and backup all databases:<code bash>
+mysqldump --all-databases -q | gzip -c > mysql-20100212.sql.gz
+</code>
+  * Using ''bzip2'' and backup all databases:<code bash>
+mysqldump --all-databases -q | bzip2 -c > mysql-20100212.sql.bz2
+</code>
 ===== Update a user password =====
 In this example, the password for the MySQL user root will be updated for following hosts: ''::1'', ''127.0.0.1'' and ''localhost''.