mySQLDUMP questions

I have a question in regards to backing a MySQL database running on
Windows 2003. What is the best approach to take to backup MySQL
database. What the correct syntax to issue with the mySQLdump command
to backup a database. What happens if you have more than one database
(i.e.db1, db2,...,dbn)

Will you have to issue the following instruction for each of the databases
i.e.

mysqldump -uUsername -p db1 < db1.sql

mysqldump -uUsername -p db2 < db2.sql
..
..
..
mysqldump -uUsername -p dbn < dbn.sql

I need more information on the correct structure and syntax for the
backup and restore of multi-database on a mysql server

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: mySQLDUMP questions

On Wednesday, March 23, 2005 22:44, Rosemond Auguste wrote:

> I have a question in regards to backing a MySQL database running on
> Windows 2003. What is the best approach to take to backup MySQL
> database. What the correct syntax to issue with the mySQLdump command
> to backup a database. What happens if you have more than one database
> (i.e.db1, db2,...,dbn)
>
> Will you have to issue the following instruction for each of the
> databases i.e.
>
> mysqldump -uUsername -p db1 < db1.sql
>
> mysqldump -uUsername -p db2 < db2.sql
> .
> .
> .
> mysqldump -uUsername -p dbn < dbn.sql
>
> I need more information on the correct structure and syntax for the
> backup and restore of multi-database on a mysql server

You'll want to check out the --databases option for multiple databases.

http://dev.mysql.com/doc/mysql/en/mysqldump.html

--
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org