This is the dump command I use:
mysqldump --verbose -u root -p my_wiki > my_wiki.sql
This is the error I get: mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `transcache` at row: 12
This is the relevant part of etc/mysql/my.cnf: # * Fine Tuning # key_buffer = 64M max_allowed_packet = 64M thread_stack = 192K thread_cache_size = 8 # This replaces the startup script and checks MyISAM tables if needed # the first time they are touched myisam-recover = BACKUP #max_connections = 100 #table_cache = 64 #thread_concurrency = 10 # # * Query Cache Configuration # query_cache_limit = 8M query_cache_size = 64M # # * Logging and Replication # # Both location gets rotated by the cronjob. # Be aware that this log type is a performance killer. # As of 5.1 you can enable the log at runtime! #general_log_file = /var/log/mysql/mysql.log #general_log = 1 # # Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf. # # Here you can see queries with especially long duration #log_slow_queries = /var/log/mysql/mysql-slow.log #long_query_time = 2 #log-queries-not-using-indexes # # The following can be used as easy to replay backup logs or for replication. # note: if you are setting up a replication slave, see README.Debian about # other settings you may need to change. #server-id = 1 #log_bin = /var/log/mysql/mysql-bin.log expire_logs_days = 10 max_binlog_size = 100M #binlog_do_db = include_database_name #binlog_ignore_db = include_database_name # # * InnoDB # # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/. # Read the manual for more InnoDB related options. There are many! # net_write_timeout = 360
On 05/15/2015 08:24 AM, Dave Humphrey wrote:
Exactly what is the error message you are getting? If it is something like "Mysql Server has gone away" it may be due to a too small "max_allowed_packet" setting. See http://stackoverflow.com/questions/19214572/can-not-import-large-sql-dump-in...