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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
You can easily clean your WordPress site database by removing drafts, auto drafts, revisions, trash, spams etc.
Popular WordPress plugins for famous cloud storage service Dropbox. Using Dropbox you can store all your important files and also backup your website to cloud at low price.
Yes you can access PhpMyAdmin section for managing your WordPress site’s MySQL database direct from your WP admin area dashboard.
Sometimes when you activate any wrong conflicting plugin, your WordPress admin section disappears. You can easily overcome this by three different methods discussed here.
Selected plugins for backing up your WordPress site and keeping your content safe.
Keeping a backup of your WordPress site keeps your content safe. Know how to complete backup your WP site including backup of wp-content directory, plugins, themes etc.
Continue reading Easily Backup Your Complete WordPress Site
For showing all database:
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.