How to backup SQL data?

[c3tr4]

How can I backup all my SQL databases?

[Viper007Bond]

Use phpMyAdmin export the data. You'll have to do it for each database.

[Mr. Popularity]

Whats the phpmyadmin like in cpanel these days?

Here's an easy way to do it if you have shell access:

mysqldump -uDBUSERNAME -pDBPASSWORD dbname > outputfile.sql

You can even write a BASH script to have crontab make a backup (daily, weekly, monthly) of a database and format the filename by date: such as:

2005.02.28-blah.sql

Then you just forget about it and let the wonderful world of CRONTAB do it all for you :)

[Silmaril8n]

Yes - throw that line into a Cron entry. There's tons of places on this forum that offer smiliar methods of howt o backup, compress, and then email to an offsite email account.

[HRWahid]

Whats the phpmyadmin like in cpanel these days?

Here's an easy way to do it if you have shell access:

mysqldump -uDBUSERNAME -pDBPASSWORD dbname > outputfile.sql

You can even write a BASH script to have crontab make a backup (daily, weekly, monthly) of a database and format the filename by date: such as:

2005.02.28-blah.sql

Then you just forget about it and let the wonderful world of CRONTAB do it all for you :)

I do also prefer backing up the database via SSH using the mysqlDUMP command

Once you dump it make sure you download it onto your home computer as a precaution. :)

[Grant29]

How can I backup all my SQL databases?

If you are comfortable with CRON jobs, check out: http://sourceforge.net/projects/automysqlbackup/

You can use it to automate daily, weekly, and monthly backups. Works great for my on my HR accounts.