Tag Archives: MySQL

How To Find Your WordPress Hostname & Server IP Address?

Not generally but many a times website owners require knowing their hostname and server IP address, it is only useful in certain situations like many security plugins and SSL certificate extensions asks you for your IP and host information to set up configuration settings and there are many more reasons.

Continue reading How To Find Your WordPress Hostname & Server IP Address?

How To Run Many WordPress Installations In One Database?

Unlike to SANGKRIT.net’s hosting accounts, there are many hosting providers who give you a limited amount of MySQL databases and resources. So in this tutorial we will be telling you how you can run multiple WordPress installations on a single MySQL database. Yes, a single database can run multiple websites including single and multisite WordPress installations or even you can also run other CMS application like Mediawiki with in that. Let us see how.

Continue reading How To Run Many WordPress Installations In One Database?

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

Check CPU Performance Of PHP & MySQL Server Right From WordPress Admin Area

With PHP/MySQL CPU performance statistics WordPress plugin you can check your CPU performance of your PHP and MySQL database time to time right from your WordPress  admin area dashboard.

Continue reading Check CPU Performance Of PHP & MySQL Server Right From WordPress Admin Area

Easiest Way To Clean Unnecessary Tables In WordPress Database

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

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 ?

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

Add Debug Bar Showing Query, Cache, And Other Helpful Information On Debugging In WordPress

WordPress developers launched WordPress.Com’s debug bar for Self Hosted WordPress Blogs . It adds a debug menu to WP admin bar that shows query, cache, and other helpful debugging information. Good for developers.

Continue reading Add Debug Bar Showing Query, Cache, And Other Helpful Information On Debugging In WordPress

Display Your Host’s PHP, MySQL & Memcached Information On WordPress Dashboard

Display your host’s PHP, MySQL & Memcached (if installed) information on your WordPress site dashboard.

Continue reading Display Your Host’s PHP, MySQL & Memcached Information On WordPress Dashboard

How To Access PhpMyAdmin Section Direct From WordPress Dashboard ?

Yes you can access PhpMyAdmin section for managing your WordPress site’s MySQL database direct from your WP admin area dashboard.

Continue reading How To Access PhpMyAdmin Section Direct From WordPress Dashboard ?

How To Deactivate All Plugins When Unable To Access WordPress 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.

Continue reading How To Deactivate All Plugins When Unable To Access WordPress Dashboard ?

How To Set WordPress To Automatically Repair Your Database ?

You can make WordPress to automatically repair your site’s database. Open wp-config.php file (present in your site’s root directory) and add the following code, just above the Happy Blogging line:

define(‘WP_ALLOW_REPAIR’, TRUE);