Backup all databases on the server at once??

I'm looking for a script or software tool that allows me to quickly backup all the databases that are on my server at once, without having to enter the database names one by one (- that would take ages).

Automated (cron) or manually - that's of less importance.

Any tips?


Greetz!
Mieke

 

You don't mention the type of database or what sort of control you have over the server.

In case of MySQL, you can backup the full database with the --all-databases switch. Like this:

mysqldump -u root -p --all-databases > [I]db_backup_file.sql[/I]

Code (markup):

 

if you don't have a shell access, use phpmyadmin ? there an option to export the whole database i think.

 

If you are interested in remote backup of the databases, we have a service to do that - PM me if interested.