Database Backup through SSH?

[Kristine Habeck]

Hello To All

I've a dedicated server and I want to take my database back up through SSH so I can later use that back up file to restore my DB information. My question is, How to take database backup on my dedicated server through SSH?

[paullopez]

Once you've logged to your dedicated server as root via SSH, type following command to create a back up of DB

mysqldump DATABASE_NAME > BACKUP.sql

Change DB_NAME with the actual name of the database you want to back up.

This will generate a backup file of your DB called backup.sql that you can later use to restore your information from.