Tag Archives: Database

How To Clean Unnecessary Tables From MySQL Database?

Cleaning unnecessary database tables means deleting tables that were created before by some plugin and now are not in use on your website. Removing such tables lightens up your MySQL database. In this lesson, you will learn about cleaning up a database manually and with plugins’ help.

Before making any changes, always ensure and be careful when deleting database tables, as removing the wrong ones can break your WordPress site. Always keep a full WordPress database backup.

Step-1, access your hosting’s cPanel and locate the phpMyAdmin option under the Databases section. Click on it to access the database management interface.

Step-2 In phpMyAdmin, find your WordPress database on the left-hand side panel. Click on the name of the database to view the tables it contains.

Step-3 Now identify unnecessary tables. Unnecessary tables might come from uninstalled plugins or themes. Tables that don’t seem to match the standard WordPress table names like wp_posts, wp_users, or wp_options may be safe to delete. Some tables have a prefix based on the name of a plugin (e.g., wp_woocommerce_* for WooCommerce).

Step-4 Once you identify the tables you no longer need, select them by checking the box next to each table. Then, scroll down and choose Drop from the options in the dropdown menu. Confirm the deletion.

Automatically Identify & Clean MySQL Database Tables

Alternatively, You can clean your database with a plugin. Plugins such as WP-Optimize or Advanced Database Cleaner let you automatically identify and clean up unnecessary tables without manually going into phpMyAdmin.

These WordPress plugins provide you with an easy way to clean up unnecessary database tables from your WordPress site.

How To Update Old Links After Changing The Domain Name In WordPress?

After changing your domain name, installing SSL, or changing any link on your website, the most important thing you need to do is update the links on your website.

When you move your WordPress Website to a new domain name, the most common issue that you notice is all internal links to pages and references to images are not updated, images don’t show up and internal links don’t work as they point to the old address which you have abandoned. This lesson will guide you two easy processes of updating such URLs on your WordPress site.

How To Update All Your WordPress Site URLs In One Click?

Login to your WordPress site and navigate to Plugins -> Add New page to find and install Update URLs plugin on your website. Upon activation, navigate to Tools -> Update URLs page.

Here you simply need to type the old URL and the new URL address, then use the tick box option to select where you want to update URLs such as on posts, pages, attachments, excerpts or all GUIDs and then click ‘Update URLs Now’ button. That’s it, your URLs would get updated.

How To Auto Update Website URLs After Migrating To A New Domain Name?

There’s another plugin that automatically detects the domain name change and the auto-updates all old links and WordPress tables in the database of your website. It is especially coded for the domain name change and you don’t require to selectively mention the changes.

Navigate to Plugins -> Add New page to find and install Automatic Domain Changer plugin on your WordPress site. After activation, navigate to Tools -> Change Domain and first you may backup and save your website database by clicking ‘Backup Database as SQL’.

Next, type the old domain name and new domain name in the fields and click ‘Change Domain’ button. The plugin lets you update HTTPS and the links with or without the ‘www’ prefix.

How To Reset Your WordPress Installation Back To Default In One Click?

Resetting WordPress installation simply means resetting your website’s database back to its defaults. Great features for technology bloggers and web-developers who everyday tests new plugins and themes. By resetting database from the admin area doesn’t require any editing via phpMyadmin etc. You can safely delete all customizations and content without disturbing the plugins, themes and all other WP core files which you have on your server.

Continue reading How To Reset Your WordPress Installation Back To Default In One Click?

Best Plugins For Optimizing & Managing Database Tables In WordPress

Generally there are two ways webmasters use for optimization database tables, some do it via phpMyAdmin which works from your webserver or your web hosting account and the other way is using a database optimization plugin which is more easy and user friendly way. There are hundreds of database optimization plugins available in WordPress plugin repository which confuses the new WordPress users.

Continue reading Best Plugins For Optimizing & Managing Database Tables In WordPress

Automatically Fix Up All Posts & Images After Data Import Etc In WordPress

Fix my posts! is the new WordPress plugin that lets you automatically repair all your posts and images after data-import or at the times when your database get messed up. It becomes more useful at the times when you you import posts/images from another CMS using direct SQL, it simply allows you to run an automatic wizard where it auto repairs some basic things on all of your posts one by one.

Continue reading Automatically Fix Up All Posts & Images After Data Import Etc In WordPress

How To Change WordPress Site Domain Name By Editing Its Database ?

We have already discussed about changing your website domain name or URL by editing functions.php file and by editing wp-config.php file. Now this tutorial explains you how you can update your website web address to new one (when you are migrating your website to a new domain) directly by updating your WordPress site’s MySQL database.

Continue reading How To Change WordPress Site Domain Name By Editing Its Database ?

How To Easily Delete Old Expired Transients In WordPress ?

Now you can easily delete old & expired transients from your WordPress site’s options table (wp_options), and prevent them bloating your database and slowing down your website.

Continue reading How To Easily Delete Old Expired Transients In WordPress ?

Backup Scheduler For WordPress Single & MultiSite Installations: Backup Your Entire Website Folders, Files And Database

Using Backup Scheduler plugin you can easily schedule backups of your entire website or select folders, files and database to backup. The plugin is compatible with both single and multisite installations. If you are running a multisite network then you can take backup of entire network and allow your subsite owners to take backup of their site.

Continue reading Backup Scheduler For WordPress Single & MultiSite Installations: Backup Your Entire Website Folders, Files And Database

How To Pass Tags In WordPress Media Library Images ?

Just like you pass tags in your WordPress blog posts; you can also tag images using a free WordPress plugin called WP Media Tagger. The plugin is extensively configurable and comes packed with a bunch of features enabling WordPress media tagging and search & media taxonomy etc.

Continue reading How To Pass Tags In WordPress Media Library Images ?

Easily Implement A Basic Library Collection And Circulation System In WordPress

WordPress is the only webcasting platform that gives you power to transform its default blogging feature of WordPress to different types of publishing and networking features. You can use WordPress for building a multi-author powered blogging system, a multisite network, a social networking website, a small messaging front, a video broadcasting site, a photo-blogging platform, e-commerce & shopping website and anything you like. In most cases you have a powerful plugin available that upon activation gives you more powerful features within your WordPress install. In this article we are discussing about a free WordPress plugin called WebLibrarian, it allows you implement a basic library collection and circulation system in your WordPress site.

Continue reading Easily Implement A Basic Library Collection And Circulation System In WordPress

Top 5 Plugins For Migrating Your Blog To WordPress

Thinking of migrating your blog to WordPress, here are 5 cool plugins that can help you doing that in a better and easy way possible and ofcourse I am takling about WordPress.Org self hosted blog not WordPress.Com. If you are migrating your blog from Blogger then you must read this post.

Continue reading Top 5 Plugins For Migrating Your Blog To WordPress

Listing MySQL Databases

For showing all database:

SHOW DATABASES;

In case you need to filter database by name:

SHOW DATABASES LIKE ‘pattern’;

For complex filtering of database use WHERE Clause:

SHOW DATABASES WHERE conditions;

With WHERE clause one can use regular expressions like ‘<‘ and ‘>’ operators, string functions etc. for filtering records returned by SHOW DATABASES.