> ('mysql','information_schema','performance_schema') AND > information_schema.tables WHERE table_schema NOT IN > SUM(data_length+index_length) TSize FROM

> (SELECT engine,SUM(data_length) DSize,SUM(index_length) ISize,

Here is that query and its output mysql> SELECT IFNULL(B.engine,'Total') 'Storage Engine', I have a query I run to show index and data usage. Indexes get rebuilt when the SQL is loaded into another server. When you run mysqldump, only data is dumped in SQL statements.

To import our saved books.sql file created earlier, we’d use many of the same flags and much the same syntax.I can explain what mysqldump does. In most cases, importing is just a matter of passing virtually identical options to the mysqlimport command. Now that you’ve learned how to export a backup of a MySQL database, we’ll explore how to reverse the process and import the backup into an existing database.Īs you might imagine, to compliment the mysqldump command used for exporting, there is a similar mysqlimport command for importing. If you need the ability to export (and later recreate) one more more databases, read up on the -databases flag in the official documentation. Instead, by default, only actual tables (and their respective data) are saved and thus will be prepared for later import using this file. sql suffix (which is completely optional but advisable) in the appropriate directory.īy default, mysqldump will not save commands which attempt to modify the existence of the actual database. $ mysqldump -u book_admin -p books > ~/backup/database/books.sqlĪfter entering our password when prompted above, this command then creates our backup file with a.

Download phpmyadmin mysqldump