How to take backup of all the tables of the database? Is there any command or php script for taking backup of whole database?

You can go into phpMyAdmin and select the database you want to backup. Then at the bottom of the list of tables tick, "Check all" and then go to "Export" from the drop down menu at the bottom.

Then you just download the SQL file and there is your database backup

Hi,

Here are some tips of taking Backup in MYSQL

• Taking Backup of Database Objects using MYSQL Administrator Tools.
• Options available in TOAD for MYSQL if u has installed it.
• Even u can write the script in the DB Server for Regular Backups with the help of your server administrator.
• U might manually take regular Backups for the Database Objects using mysqldump command from the Command prompt.


In MYSQL Administrator Tool

1. Connect your Database with the proper Connection String.
2. Click the Backup option on the left side of the browser.
3. Click the New Project button at the right down corner.
4. Give some name for the Backup Project.
5. Select the database which you want to take the backup.
6. Specify the file name and the location of the backup file.

In TOAD for MYSQL

1. Go to the Tools in the Top Menu.
2. Click the Export Wizard.
3. Select the Export Category [tables, views and Database].
4. Proceed to take the Backup in the specified path.

Server Side Script

Just have an idea of server script for taking the regular backups, but don’t know the code for the script.

Mysqldump

mysqldump -u <user name> -p <Password> --routines <Database Name> > <Path for the output file>

Routines define the backup of Stored Procedures and u can take a single table dump by specifying the table name after the database name.

__________________
-Murali..