The cms backup fails to recover data.

Source: Internet
Author: User

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;

 

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.