Backup MySQL DB in command line

So you have a website on a dedicated server. You need to backup a database. You tried to backup through PhPMyadmin but it keeps timing out. Here is what you need to do. Backup the database through a terminal session. SSH into your web/MySQL server and run the following commands below.

TO BACKUP:

##Without G Zip Compresssion:
mysqldump -u USERACCOUNT -pYOURPASSWORDGOESHERE YOURDATABASENAMEHERE > latest_backup_061009.sql

##With G Zip Co...

Read More