Shulou(Shulou.com)05/31 Report--

This article is to share with you about how MySQL restores psc file records to zero. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Psc files are backup files generated by the Navicat tool and can only be restored with the Navicat tool.

(1) steps for error occurrence

1. Connect MySQL with Navicat

2 create a new database with a random name, such as mydb1, and select utf-8 for character set (because utf-8 is used to back up files)

3 Select mydb1 Database-- > backup-- > restore backup-- > Select psc file to start restore

(4) after the restore, it was found that only 551 of the 673 objects were restored and 0 of the 47366 records were restored. This shows that there is something wrong with this backup file.

(2) solution

1 restore again, in "Advanced", uncheck "use transaction" by default, and check "continue in case of error"

2 after the restore, both the number of objects and the number of records were successfully restored

3 back up the mydb1 database, the number of objects obtained here is 665, while the original object is 673. Indicates that there are 8 objects in the original backup file that are problematic and cannot be recovered. There is no way to know whether these eight objects are tables, triggers or indexes.

The number of processed records is 47366, which is consistent with the original number of records, indicating that the number of records in the entire library has not been lost. This means that if the missing object is a table, it must be an empty table. )

The resulting backup file is named 160330103626.psc, which is named according to the time of the backup. The backup path is C:\ Users\ Administrator\ Documents\ Navicat\ MySQL\ servers\ jebao\ mydb1\.

4 set up a new database with a random name, such as mydb2, and the character set is still utf-8. Then use the backup file 160330103626.psc to restore the data.

Pay attention to the default selection in the "Advanced" option.

5 after the backup, it is found that the number of objects and records are fully restored, indicating that there is no problem with the new backup file.

Thank you for reading! This is the end of the article on "how MySQL recovers the number of psc records to 0". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

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.