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 ?

Why is MySQL dump not restoring all my tables?

Database Administrators Asked on December 28, 2021

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 ?

mysql mysql 5.5 mysqldump

Add your own answers!

Ask a Question

Get help from others!