![]() ![]() 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |