Category Archives: MySQL

Backup All of your MySQL Databases using AutoMySQLBackup

If you have a WHM account and manage several accounts/websites under it, taking a backup of ALL of the MySQL Databases get simplified with AutoMySQLBackup. Here is how to go: Download a copy of AutoMySQLBackup from http://sourceforge.net/projects/automysqlbackup/ Automatic Installation 1. … Continue reading

Posted in Linux, MySQL | Leave a comment

How to import a compressed mysql file .sql.gz using linux shell?

Login into your server using a shell program like putty. Type in the following command on the command line zcat DB_File_Name.sql.gz | mysql -u username -p Target_DB_Name where DB_File_Name.sql.gz = full path of the sql.gz file to be imported username … Continue reading

Posted in MySQL | Leave a comment