The cms backup fails to recover data.

The cms backup fails to recover data.

Today, the linux host is poisoned. After backing up the Empire backup king, the snapshot is restored to the status of the newly created host;

Ah, I can't blame you for not taking snapshots diligently at the beginning;

After reconfiguration;

Start to use the Empire backup master;

After the data is restored, open the article and prompt "An error occurred while adding the table value"

Baidu searched for a bunch of solutions, but it could not solve my problem. I opened phpmyadmin and found that there were only 1000 dede_addonarticle tables in the database, but I collected data, there are nearly 2 million pieces of data in my background, which is a big gap.

Restore with the Empire again, and find that when the dede_addonarticle table segment is restored, it passes through and is directly restored to the next segment.

Looking for multiple sources of information, I thought it was an issue of the empire, and it would not work if I changed the Empire backup King 2010;

I have no intention of seeing an article about modifying the configuration file of the Empire backup king and splitting data to avoid 502 errors. I am inspired to open http://www.riven.cc/dedebak/bdata/www.rivencc_20180210120352Y7BYbf/config.php;

Open it

$ Tb [dede_addonarticle] = 0;

Compare config. php of the last backup

$ Tb [dede_addonarticle] = 1314;

I finally know why;

In the directory, find the number of the last table in dede_addonarticle_1.php,

Enter the number in $ tb [dede_addonarticle] = *****; // ***** is the number in your last table;

Save and restore. OK.

If you have any questions like me, please refer to them for reference.

In fact, the problem is very small, but I don't know why this value was not written to config. php during the backup process.

Conclusion:

1. The Empire backup king tries to use a 16-in-one mechanism for backup, which can avoid errors caused by different data migration environments;

2. In addition to Empire backup, we recommend that you use phpmyadmin for databases everywhere;

3. linux mysqldump-u username-p password> saved file name. SQL

Example: mysqldupm-u www. riven. cc-p riven. cc> riven. SQL // www. riven. cc is the username, riven. cc is the password, riven. SQL is the name of the saved database file;