Skip to main content

Posts

Showing posts with the label mysqldump

run-mysqldump-without-locking-tables, some RDS config privilege, max_allowed_packet...

https://stackoverflow.com/questions/104612/run-mysqldump-without-locking-tables https://dba.stackexchange.com/questions/17367/how-can-i-monitor-the-progress-of-an-import-of-a-large-sql-file https://stackoverflow.com/questions/2016894/how-to-split-a-large-text-file-into-smaller-files-with-equal-number-of-lines mysqldump --net_buffer_length=4096 --create-options --default-character-set="utf8" --host="localhost" --hex-blob --lock-tables --password --quote-names --user="myuser" "mydatabase" "mytable" > mytable.sql https://stackoverflow.com/questions/5013151/how-do-i-limit-the-number-of-results-returned-from-grep https://stackoverflow.com/questions/30658703/how-to-print-the-line-number-where-a-string-appears-in-a-file https://askubuntu.com/questions/1026045/limit-grep-output-to-short-lines 35 I found what the problem was. The MySql variable/parameter explicit_defaults_for_timestamp was OFF on my local machine but ON on my r...