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

Below I'll give you a brief introduction to the mechanism for recovering data using mysql. Have you heard about similar topics before? Interested words to see this article together, I believe that after reading the use of mysql recovery data mechanism for everyone how much help bar.

In fact, if you look at the sql statement generated by mysqldump backup, you will find that the view will first be restored to a table, and then delete the table and create a new view.

As shown in the figure below, you can see that the v_t_borrow_details table is created first in line 15572, and then the v_t_borrow_details view is created in line 21322.

This is to avoid dependencies, for example, there are 2 VIEW: v_a, v_b

v_a references v_b

If v_a is created first, then v_b referenced by v_a has not been created yet, so it is unsuccessful to build, and all views are made into tables first. Tables that have no dependencies will be successfully created, and then views will be deleted and views created one by one. At this time, the referenced things exist in the form of tables or views, and there will be no problems due to dependent objects.

The reason why the view will become a table is because an error in the recovery process caused the recovery to be interrupted, and the following statements were skipped.

How do you feel about using mysql to recover data mechanisms in this article, whether there is any harvest. If you want to know more about it, you can continue to pay attention to our industry information section.

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.