I have a huge database in phpmyadmin. It has 1,500 tables because I use Drupal. I used the command
mysqldump -u [username] -p[password] [databasename] > [filename.sql]
To create a .sql file on the server. It took some time, but was 100% complete. Then I tried to copy the file to the local computer with Filezilla, it continued to crash and stopped, so I used the command
scp [my_username]@[my_host]:[filename.sql] /some/local/directory.sql
It took a couple of hours, but also said that it was 100% complete. After that, I opened MySQL Workbench and imported it from a file on my local computer. When the import was completed, I have 1024 tables. I thought it was less than necessary and checked phpmyadmin with this sql command
SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = <MyDatabaseName>;
This command returned a table like this
So, from this result I am missing 484 tables. Where did they go? Are they pointless tables or will this cause problems when trying to deploy?
My thoughts were that one of these commands reserves some tables created by Drupal because they consider them pointless or broken.
Any help is really appreciated.
source share