SQL Backup

• You can back the files or databases up on MySQL using the server.

• If you delete some data by mistake, you can restore them, but only under the condition that you have to back them up before.

• types:

1. depending on the environment of the backup

• hot backup: when executing DB on SQL
• cold backup: when stopping the execution of DB on SQL

1. depending on the way to back up

• logical backup: store data by changing into SQL Query, easy to check the errors, use when storing the data is a few amount
• physical backup: take the relatively large size of file, the fast speed of the backup and the restoration, use when storing large amount of data and backing them up as soon as possible

• hot logical backup:

1. using crontab and shell script, check the logs and times for the backup

2. with cyberduck, upload the files or databases to back up

• cold physical backup:

1. when you have the authorized access before you backing the data up

2. you have to log out the ubuntu account then access to again

3. you have to make the AWS server for the backup first

• IF you feel that using the virtual server, it is difficult to back the data up, you can back the data up on SQL program. (Export data)