Timeline for Restoring MySQL Database from mysqldump file produces seemingly random syntax errors
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 5, 2023 at 9:45 | comment | added | DSZ |
Hi there, thanks for this! It turns out it was in fact the net read/write timeouts. I wasn't expecting this as I was working with the file on a local machine using mysql -uusr -p targetDB < dumpfile.sql
|
|
| Oct 5, 2023 at 9:44 | vote | accept | DSZ | ||
| Oct 4, 2023 at 18:00 | comment | added | Bill Karwin | One could also transfer the dump file to the database server host, and verify it is not damaged by using a checksum. Then import the dump file to the database on that host. | |
| Oct 4, 2023 at 17:32 | history | answered | RolandoMySQLDBA | CC BY-SA 4.0 |