Shulou(Shulou.com)06/02 Report--

Today, I will talk to you about the process of database recovery based on SQL backup, which may not be well understood by many people. in order to make you understand better, the editor has summarized the following content for you. I hope you can get something according to this article.

The UPDATE statement forgot to add the WHERE condition, causing the data of the entire table to be updated.

1. Think calmly:

1.1 impact features: completely unavailable, multiple core functions are not available, a core feature is not available, non-core features are not available

1.2 affect users: all users, certain types of users, certain users, individual users

1.3 impact data side: all databases, single database, single data table

1.4 urgency: online users are immediately affected, minute level is affected, hour level, half day, one day, etc.

1.5 recovery difficulty: completely unrecoverable, partially recoverable, fully recoverable

Recovery methods: SQL backup, binlog playback, redis playback (persistence strategy AOF, RDB), and other MySQL-based redo-log playback.

Choose the appropriate recovery method according to the emergency level above. For example, if a core function is directly affected and needs to be repaired immediately, but it is not feasible to fully recover data within a short period of time, you can only recover part of the data so that the service can work, and then use scripts or other operations to recover subsequent data.

2. Restore data

2.1 extract the table structure of table t from the backup

Sed-eaccountant TABLE. / {Htinct;}'- e'x;;}'- e'x; create.

2.2 extract the contents of table t from the backup

Grep 'INSERT INTO `t`' dump.sql > b.txt

2.3 you can execute the contents of the two files respectively

After reading the above, do you have any further understanding of the database recovery process based on SQL backup? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.