Backup and Restore a Relational Database
Budget: $40 – $70 USD
Requirements
Take screen shots to show your accomplished work for each of the following sub-steps:
Back up all the tables and data in your project database into a .sql file using mysqldump.
Modify the .sql back up file to create and use a new database.
Restore the tables and data from the .sql back up file into a new database.
Prove that all the tables and data from the .sql back up file have been restored into the new database.
Deliverable
Paste the modified .sql back up file content and the screen shots you took in the steps above into a Word document.
Take screen shots to show your accomplished work for each of the following sub-steps:
Back up all the tables and data in your project database into a .sql file using mysqldump.
Modify the .sql back up file to create and use a new database.
Restore the tables and data from the .sql back up file into a new database.
Prove that all the tables and data from the .sql back up file have been restored into the new database.
Deliverable
Paste the modified .sql back up file content and the screen shots you took in the steps above into a Word document.