Backup of Databases

Hi, I need to take backup of all my database in MySQL. How can i do that?

Is there any MySQL command to take the backup?

Can anyone help me !!

Hi Dhuruv,

There are a ton of ways you can do this. Here are a few URL's that will help.

extensions.joomla.org/extensions/access-a-security/backup

My personal favorite is Akeeba. There is an excellent tutorial on using Akeeba on the opensourcevarsity website, do take a look.

www.opensourcevarsity.com/joomlapackbackup

Hope this helps

Hi Dhuruv,

You can take the backup of all databases through one single command at the shell prompt.

Go to Start - >Run and then type cmd.

When the comman prompt window is display, type in the below give command.

shell> mysqldump -u<username> -p<password> --all-databases > D:/<filename>.sql

NOTE:
1. Replace <username> with the username of MySQL - Or you can pass root
2. Replace <password> with the password to your MySQL
3. Replace <filename> with the name you want to give to this file.

This command will generate an SQL script file in the location specified by you.

At the required time you can import the exported SQL script file as and when required.

Hope this helps.