Detailed Mysql restore PSC file record number 0 solution _mysql

The PSC file is a backup file generated with the Navicat tool and can only be recovered using the Navicat tool.

(i) Error occurrence steps

1 Connect MySQL with Navicat

2 Create a new database, name arbitrarily take, such as MYDB1, character set select Utf-8 (because the backup file is Utf-8)
3 Select MYDB1 Database--> backup--> Restore backup--> Select PSC file, start restore
4 After the end of the restore, 673 objects recovered only 551, and 47,366 Records recovered 0. This indicates that there is a problem with the backup file.

(ii) Solutions

1 re-restore, in the "Advanced", cancel the default check "Use Transactions" and check "Encounter error Continue"
2 The number of objects found and records recovered successfully after the restore ended
3 The MYDB1 database is backed up, where the object is 665, and the original object is 673. Indicates that there are 8 objects in the original backup file that are problematic and cannot be recovered. It is not known whether these 8 objects are tables or triggers or indexes.

The number of processed records is 47,366, consistent with the number of previous records, indicating that the entire library has not been lost. (This can indicate that if the missing object is a table, it must be an empty table.) ）

The resulting backup file name is 160330103626.PSC, which is named according to the time of backup. The backup path is C:\Users\Administrator\Documents\Navicat\MySQL\servers\jebao\mydb1\.
4 Create a new database, name arbitrarily take, such as MYDB2, character set is still utf-8. Then use the backup file 160330103626.PSC you just made to restore the data.
Note The default selection in the Advanced option is OK.
5 After the backup, both the number of objects and the number of records are fully recovered, indicating that there is no problem with the new backup file.

The above is the entire content of this article, I hope to help you learn, but also hope that we support the cloud habitat community.