I've inherited a website I didn't originally build. The database includes a users and a bookings table both of which are relatively large (innodb) tables.
I'm trying to download a copy of the database to use locally but despite the mysqldump command seemingly working when I run the dump file against my local database server I am missing the majority of rows in these large innodb tables.
The mysqldump command I've used is:
mysqldump --compress --add-drop-table --routines --events --comments --extended-insert -u root -p dbname > dbdump.sql
And I've attempted to restore this using simply:
mysql dbname -u root -p < dbdump.sql
Both the dump and import commands work without errors.
The imported bookings table contains only 4722 of the 41477 records that should be there.
I've found some suggestion it could have been a problem with the max_allowed_packet setting on the server but increasing this to 16777216 and re-running mysqldump made no difference.