I have a large forum (9.4 million posts) and I'm moving the database to a new server. I backed up the database using mysqldump --opt, then began to restore the .sql file using a plain old mysql db_name < db.sql command.
During the restore, the process seemed to hang (the size of the database in /var/lib/mysql wasn't increasing), and I ran SHOW...
"Repair with keycache" on xf_search_index blocking DB restore process
Continue reading...
During the restore, the process seemed to hang (the size of the database in /var/lib/mysql wasn't increasing), and I ran SHOW...
"Repair with keycache" on xf_search_index blocking DB restore process
Continue reading...