To restore a MySQL backup, enter: mysql -u -p <. ![]() Since the dump file has the commands to rebuild the database, you only need to create the empty database. This creates the foundation file that mysqldump will import the data into. Make sure you’ve named it the same as the database you lost. System that hosts the database, use MySQL to create a new database. sql How to Restore MySQL with mysqldump Step 1: Create New Database To include more than one database in the backup dump file: sudo mysqldump -u -p >. To back up of an entire Database Management System: mysqldump -all-databases -single-transaction -quick -lock-tables=false > full-backup-$(date +%F).sql -u root -p
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |