How to do WordPress optimization of Shanghai Dragon five database optimizingPosted by: admin | Posted on: August 11, 2017
this is my first blog problems, then think the database should be not what problem, it has not used the database backup. The results on a day when the website database connection failed, when I was consulting to the operator, to know the database is damaged, when a data can not get back, I know, I’m more than a year into the East water post.
3, part of the data table is damaged, causing part of the page does not open, until it was found that the
this is the most difficult thing for me, because sometimes the site too much, there is no way to care. As part of the data table is damaged, can still access the page are normal, but there is no way to add and modify the new article, there is no way to upload pictures, even URL has changed. And before I often only check the normal home page, on the matter, but the search engine seems my website is not normal, and this kind of sites have to be right down, until I realized it was time to database problem, it was too late.
2, the database backup, but did not check, the site can not completely recover
before the advent of the database problem, I also like most novice, can not understand the importance of database optimization. And when I optimize dozens of websites, has continued to appear when the database problem, I was increasingly important experience of database optimization. Site database is the foundation of success, but also the value of your site.
database optimization how to do?
1, no database backup habits, causing the site without
is the first blog after the lesson, I immediately gave each blog WordPress installed database backup timing plug. But when the second site problem, when I took to restore the backup, found this site because the database is too large, has not been able to complete the backup, the backup file does not lead to full recovery of the 60%, only the data.
1, using the WP-DB-Backup database backup timing: This is a WordPress plugin, its powerful place lies in timing backup, if you have the space to support email, even every timing can be sent to your mailbox, remote backup. This ensures that your database at any time within 1 days of the backup, either:
read here, I believe we know the importance of database optimization, and we should worry about white, what should we do to prevent the database optimization, the database optimization problem? Then I will give you a set of WordPress (3 WordPress optimization is summed up, this is money to burn out the experience ah):
the following is several database problems I had before, give you a share, I hope to help beginners WordPress: