Differences

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

--- wiki:mysqldump_tips [2020/12/11 16:00] – created antisa
+++ wiki:mysqldump_tips [2023/07/03 10:20] (current) – add important box antisa
@@ Line 1: / Line 1: @@
 {{tag>mysql cli}}
 ====== mysqldump tips ======
+<WRAP center round important 60%>
+If you are going to use some of the commands below in crontab, the '%' sign needs to be escaped e.g.
+''mysqldump -uroot -p --all-databases | bzip2 > db_dump_$(date +\%F).sql.bz2''
+</WRAP>
 ===== Dump only select tables =====
@@ Line 41: / Line 45: @@
   sed -n -e '/DROP TABLE.*`mytable`/,/UNLOCK TABLES/p' mydump.sql > tabledump.sql
+====== See also ======
+  * [[wiki:mysql_miscellaneous_commands]]
 ====== References ======