Database

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)

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)