Differences

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

--- linux:databases:mysql [2017/03/03 14:29]
tkilla
+++ linux:databases:mysql [2017/11/22 01:10] (current)
tkilla
@@ Line 80: / Line 80: @@
    mysqldump --opt --host=127.0.0.1 --default-character-set=utf8 --user=root --password=${PWD} $DB > $FILE
+If you get "error 34 too many open files".. increase open_files_limit in /etc/mysql/my.cnf
+  open_files_limit = 50000
+Restart mysql and check to see current setting:
+  SHOW VARIABLES LIKE 'open%';
+interesting parameters for replication:
+--lock-tables - READ LOCK (no writes) for currently dumped database: ensures consitent dump instead of
+--single-transaction   Use this setting with extreme caution when backing non-transactional tables BUT
+will give you an exact point-in-time snapshot of the data
+--single-transaction produces a checkpoint that allows the dump to capture all data prior to the
+checkpoint while receiving incoming changes.
+Those incoming changes do not become part of the dump. That ensures the same point-in-time for all tables.
+USE IF ALL TABLES ARE INNODB
+--opt includes --lock-tables
 ----
@@ Line 88: / Line 111: @@
    mysql --host=127.0.0.1  -u root --port=$PORT --password=${DBPWD} ${DBNAME} < ${MYSQLDUMP_FILE}
 ----

fr33.info