Cisco Systems MCS 7835 Series Manual De Usuario

The database backup procedure supports MySQL database version 4.0.21. This section describes how to 
back up MySQL database version 4.0.21.

Open a DOS window and modify the current directory so that the default path points to the MySQL bin 
directory. 

The default MySQL installation path is: 

C:\Program Files\MySQl\mysql-4.0.21-win\bin

Run the following DOS command to dump the contents of the MySQL database to a file called mydump: 

mysqldump -u root --all-databases --add-drop-table --single-transaction > mydump

where

-u root indicates that the user account “root” is used to run this command. “Root” is the default 
administrator created during MySQL installation.

--all-databases means that all databases are to be backed up.

--add-drop-table ensures that drop table SQL statements are generated for every dumped table.

--single-transaction ensures that you do not need to stop the MySQL service when you back up the 
database.

By default, you do not need to provide a password for local “root” login. However, if you change 
the root user password, you should add the text “-p password” to the command line. For example:

mysqldump -u root -p rootpassword --all- databases --add-drop-table --single-transaction >mydump

Save the mydump file to a safe location.

This section describes how to back up the following files by copying them to a different physical 
location: