[an error occurred while processing this directive]

SQL Backup Script

                         

The Tutorial illustrate an example from 'SQL Backup Script'. To understand and grasp example we create a command for backup of  table in specific komal database and backup of all the databases.

Command for Backup of one database:

The below given command create a backup of one database name 'komal'.

 

 

 

c:\>mysqldump  --opt -u root -h 192.168.10.126 -p komal>c:\komal.sql

Result

Backup Completely 

Command for Backup of all database:

The below command is used to create a backup of all databases.

c:\>mysqldump  --opt -u root -h 192.168.10.126 -p --all-databases>c:\komal.sql

Result

Backup Completely

                         

[an error occurred while processing this directive]