Recently I tried importing a 1.2GB SQL dump file and Navicat kept immediately timing out with: [Err] 2006 – MySQL server has gone away Eventually, I was able to the entire file (6 million records worth) to import by unchecking* the “Run multiple queries in each execution” option before starting the import process. After this, the process completed perfectly! *normally I always uncheck that box, but for some reason this time I forgot to uncheck it on my first attempt.
Tag Archives: mysql server
Recently I tried upgrading to the latest version of the WordPress Download Monitor plugin. It did not go well 🙁 Thus, I tried to revert from a backup made using Navicat. Unfortunately, the restore would fail every time while trying to import my wp_posts table (a pretty important table!) I tried exporting the backup to a SQL dump and importing that. No luck. Finally, I tried resolving the actual ‘MySQL server has gone away’ issue itself and I had success. This tip