Archive for August, 2013

Change WordPress theme via MySQL command line

Posted: 5th August 2013 by kunwardharmesh in WordPress

You may find the list of available themes under ./wp-content/themes folder. Access MySQL Server from the shell prompt OR Open phpMyAdmin, go to your wp database. $ mysql $ use database_name; $ show tables; You will see something like this: +————+————+————+—————+—————+ | Tables_in_database | +————+————+————+—————+—————+ | wp_commentmeta           | | wp_comments              | | wp_links                 | | […]

Change the WordPress site URL using MySQL command line

Posted: 5th August 2013 by kunwardharmesh in WordPress

The following steps may be helpful for a site migration where you need to find and replace the domain name. Solution: Use the command line to make short work of the task. $ mysql $ use database_name; $ show tables; You will see something like this: +————+————+————+—————+—————+ | Tables_in_database | +————+————+————+—————+—————+ | wp_commentmeta           | | wp_comments              […]

This can happen when the /etc/hosts file includes a localhost entry for a public IP address. Here is an example: Code: root@vps [~]# cat /etc/hosts ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 127.0.0.1 localhost.localdomain localhost localhost4.localdomain4 localhost4 # Auto-generated hostname. Please do not remove this comment. 24.21.209.139 vps.server.com vps localhost localhost.localdomain Notice the “localhost” entry on the […]

Solution – cPanel Error when Adding Addon Domain

Posted: 1st August 2013 by kunwardharmesh in WHM/cPanel

Solution – cPanel Error when Adding Addon Domain When you try to add / create an addon domain in cPanel, but you get following error message Using nameservers with the following IPs: xxx.xxx.xxx.xx,xxx.xxx.xxx.xx Sorry, the domain is already pointed to an IP address that does not appear to use DNS servers associated with this server. […]