Database

The Easiest Way To CleanUP WordPress Database- WP Sweep

The Easiest Way To CleanUP WordPress Database- WP Sweep

"Error connecting database." "My WordPress site is too slow." "Is my hosting sucks?" How may times have you faced the similar problem as above or seen WordPress users complaining about such issues? There could be multiple reasons for the above issue & one of them is the database of your WordPress blog. Even if you haven't faced the above issues, it's important for you to clean up your WordPress database on a regular interval. This could be a week or a month depending upon how regular you post or how big your WordPress blog is. Here at (15 comments)

SQL Query To Move Meta_Value From One Meta_Key To Another

SQL Query To Move Meta_Value From One Meta_Key To Another

Recently I moved my SEO settings from theme to SEO by Yoast plugin, and thanks to Data transporter plugin made the job easier. One of the underlooked feature of SEO by Yoast plugin is Social SEO feature, in which you can define the different title for Facebook, Google Plus, Twitter & more. For long, I was using WP Social SEO (Which is a paid plugin), and after switching to Yoast SEO plugin, it was no longer necessary to stick to old plugin. The issue that I faced is, I had to move all my database value from old plugin to SEO by Yoast. This (0 comments)

[Fix] WordPress Database table doesn’t support repair Error

[Fix] WordPress Database table doesn’t support repair Error

The other day I noticed that my WordPress site (ShoutMeloud) started responding slow and at times it was giving error connecting database issue. At many instance it was giving me following error "Connection lost. Saving has been disabled until you’re reconnected. We’re backing up this post in your browser, just in case." while writing a blog post. It was unusual, as my traffic was consistent and there was n change in server configuration. For the first few time I simply ignored this issue and today I ran into another issue with comment moderation. (3 comments)

How To Reduce WordPress Database Size To Improve Blog Performance

How To Reduce WordPress Database Size To Improve Blog Performance

There are two important components of a typical WordPress installation: WordPress files stored on your server WordPress database It's very essential for you to timely cleanup WordPress database and reduce the size. This is a must-have process for every WordPress user to keep the size of their database at minimum and keep their WordPress blog fast. Over the time your WordPress database have many redundant table, unused records and many entries which you can remove without affecting your website. This will help you a lot to reduce load on your (22 comments)

WP-Optimize Plugin: Optimize WordPress Database with Single Click

WP-Optimize Plugin: Optimize WordPress Database with Single Click

WordPress database optimization is one of the essential task to keep your WordPress blog healthy. WordPress uses MySQL to create tables and database to store data. With time, you end up adding many redundant table data, database overhead in your database, and you should keep removing them to keep your database healthy.   Along with this, WordPress features like post revisions, auto-draft also adds more into database size, and you should empty all such tables to keep your database size low. 30 essential WordPress plugins worth (9 comments)