I am exporting database in SQL file using workbench. Export is done successfully, but when I import data and compare record counts with older database, some of the records are missing. Not all records are exported in some table. I don't know what i can do so no records are missed.

  • Start by looking at the dump. Is that complete or are the records already missing there? – Mike Lischke Nov 19 '18 at 7:48
  • @MikeLischke My database size is showing 7.9 GB, but .dump file is 4 GB only. – Aakash Patel Nov 19 '18 at 8:56
  • @MikeLischke also i am migrating from mysql 5.5 to 5.7 – Aakash Patel Nov 19 '18 at 11:12
  • Hi @MikeLischke one more update: I have again exported database, this time export file's size was proper but while importing, it did not import all data. – Aakash Patel Nov 19 '18 at 12:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.