| |

How can I BACKUP a MySQL database from the command line?

Performing a MySQL Database Dump From your SSH command prompt type … mysqldump -u {username} -p {password} {databasename} > {databasename.sql} Replace the parameters with the appropriate values {username} – this is your database username {password} – this is the password for your database {databasename} – the name of your database {databasename.sql} – the file to…

| |

How can I RESTORE a MySQL database from the command line?

Importing a MySQLDUMP From your SSH command prompt type … mysqladmin -u {username} -p {password} create {databasename} mysql -u {username} -p {password} < {databasename.sql} Replace the parameters with the appropriate values {username} – this is your database username {password} – this is the password for your database {databasename} – the name of your database {databasename.sql}…

How to disable or customize cPanel’s Update Preferences from the Command Line

The default update settings for a cPanel installation are usually controlled from the WHM interface: WHM > Server Configuration > Update Preferences However, there are situations where a greater level of control might be required. In such cases, it is usually easier to modify the update settings right from the command line. The file that…

How do convert a dedicated IP to a shared IP on cPanel/WHM

In root SSH, copy the /etc/domainips file and then remove the IP from it: Code: cp /etc/domainips /etc/domainips.bak110726 vi /etc/domainips You’ll see a line for the IP like the following that you’d remove from that file: Code: IP#: domain.com Where IP# is the dedicated IP and domain.com is the current domain using that IP. After…