MySQL Basics Practice Test: MySQL Database Maintenance, Backups and Replication — Flashcards

Quiz questions on preventive MySQL Database maintenance principles, database backups, checking and repairing database tables, backups for data recovery and replication servers setting.

Here are some ways to maintain a MySQL database:
Backups: You can use MySQL Workbench to create a backup of your MySQL database.  Here's how:
Connect to your MySQL database
Click Server on the main toolbar
Select Data Export
Select the tables you want to back up
Under Export Options, select where you want your dump saved
Click Start Export

Replication: MySQL replication uses a master-slave architecture to distribute data, balance load, and protect against data loss. 
Here's how to set up MySQL replication:
Give your server an ID
Create a user with replication access
Configure the slave server's my.cnf file
Import the data and SQL schema into the replication server
Tell the MySQL slave server to use its master server log file
Run the command mysql --u root --p < ~/dump.sql on your slave MySQL server

mysqldump: This function performs logical backups of MySQL databases and dumps one or more databases into the SQL server. You can also use it to generate output in XML, CSV, or other delimited formats.
Log backup: This feature copies all the MySQL binary logs.
Incremental backups: This is more efficient than making a large backup file and waiting for it to generate. 

Other ways to maintain a MySQL database include securing the database and upgrading it.