Differences

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

--- mysql [2019/03/09 10:08] – [Get all attributes of a user] admin
+++ mysql [2019/03/28 13:50] (current) – [Manually create a backup] dani
@@ Line 8: / Line 8: @@
   - Get the user and password to access the MySQL database. This is usually the user ''root''!
-  - Check for the database data directory: ''mysql -e "show variables;"|grep datadir''
+  - Check for the database data directory:<code bash>mysql -e "show variables;" | grep '^datadir'</code>
-  - Check, if the binlog option is enabled: ''ls $(mysql -e "show variables;"|grep datadir|awk '{print $NF}')/|grep bin.index''. 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: ''du -sh $(mysql -e "show variables;"|grep datadir|awk '{print $NF}')''
+  - Amount of data:<code bash>du -sh $(mysql -e "show variables;" | awk '/^datadir/ {print $NF}')</code>
-  - Socket: ''mysql -e "show variables;"|grep socket''
+  - Socket:<code bash>mysql -e "show variables;"|grep '^socket'</code>
-  - Network port: ''mysql -e "show variables;"|grep '^port'''
+  - Network port:<code bash>mysql -e "show variables;"|grep '^port'</code>
 ==== Setup automysqlbackup configuration file ====
 Now, you are ready to edit the configuration file of automysqlbackup:
-  - Add user: ''CONFIG_mysql_dump_username='root'''
+  - Add user: ''CONFIG_mysql_dump_username='root' ''
-  - Add user’s password: ''CONFIG_mysql_dump_password='<password>'''
+  - Add user’s password: ''CONFIG_mysql_dump_password='<password>' ''
-  - Add the backup directory (usually a separate filesystem: ''CONFIG_backup_dir='<backup dir>'''
+  - Add the backup directory (usually a separate filesystem: ''CONFIG_backup_dir='<backup dir>' ''
-  - Add the pre backup script, if needed: ''PREBACKUP="<prebackup-script>"''
+  - Add the pre backup script, if needed: ''PREBACKUP="<prebackup-script>" ''
-  - Add the post backup script, if needed: ''POSTBACKUP="<postbackup-script>"''
+  - Add the post backup script, if needed: ''POSTBACKUP="<postbackup-script>" ''
 The configuration file is expected here: ''/etc/automysqlbackup/automysqlbackup.conf''
@@ 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''.
@@ Line 114: / Line 126: @@
 <WRAP center round tip 60%>
-If you want to get attributes for all hosts, just remove the ''host='localhost''' query in the ''WHERE'' clause!
+If you want to get attributes for all hosts, just remove the ''AND host='localhost''' query in the ''WHERE'' clause!
 </WRAP>