Tag Archives: Database

WordPress

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

Leave a comment

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? →

WordPress

Best Plugins For Optimizing & Managing Database Tables In WordPress

Leave a comment

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 →

WordPress

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

Leave a comment

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 →

Technology, WordPress

Easiest Way To Clean Unnecessary Tables In WordPress Database

Leave a comment

WPDBTotalCleaner is the new WordPress plugin which provides you a very easy way to clean up unnecessary Database tables from your WordPress site. The plugin is simple, lightweight and is compatible with bot single and multisite WordPress installations.

Continue reading Easiest Way To Clean Unnecessary Tables In WordPress Database →

Technology, WordPress

How To Update All WordPress Image & Content URLs In One Click ?

Leave a comment

After you move your WordPress site to a new domain name, you will notice that all internal links to pages and references to images are not updated, images are not showing up because your images and other links and references are pointing towards your old domain name. This tutorial is about a plugin that fixes this thing up in just a click. It automatically updates old URLs and links in your website.

Continue reading How To Update All WordPress Image & Content URLs In One Click ? →

Technology, WordPress

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

1 Comment

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 ? →

Technology, WordPress

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

Leave a comment

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 →

Technology, WordPress

How To Pass Tags In WordPress Media Library Images ?

Leave a comment

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 ? →

Technology, WordPress

Easily Implement A Basic Library Collection And Circulation System In WordPress

Leave a comment

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 →

Technology, WordPress

Top 5 Plugins For Migrating Your Blog To WordPress

Leave a comment

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 →

MySQL, Technology

Listing MySQL Databases

Leave a comment

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.