I have Mysql 5.5 server on a EC2 instance which have multiple sql users to perform operation , now i want to create a back up db server .

  • For which i have created a mysql dump using root user .
  • Installed Msql 5.5 on backup db server .
  • Restore the dump file on backup server.

The issue is in my Mysql server i have 110 tables but when i restore dump file it only create 35 tables in my backup db . I have nearly 100 Gb data on Server and my dump file size is 32 GB when i restore the dump it also create the data nearly the size of dump file .

What is the problem with dump file ?

  • please do share mysqldump command you're using and try using -f switch, there could be invalid view due to which dump might be failing Jul 24 '20 at 13:05
  • Where there any errors? Such as timeout?
    – Rick James
    Aug 31 '20 at 5:47

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.