mysqldump
Todd Williamsen wrote:
>i would like to know how to write batch script for dumping schema and
>data into a sql file. This script should dump the whole database and
>data
>
>
>-
>Before posting, please check:
> http:
Todd,
> i would like to know how to write batch script for dumping schema and
> data into a sql file. This script should dump the whole database and
> data
Write this in a batch file:
mysqldump [options] dbname >somename.sql
where is the name of the db. See the manual for mysqldump optio
> i would like to know how to write batch script for dumping schema and
> data into a sql file. This script should dump the whole database and
> data
Here is what I use which is pretty straightforward unless I am missing
something.
d:\mysql\bin\mysqldump -u root --password=password --opt -A >
d
i would like to know how to write batch script for dumping schema and
data into a sql file. This script should dump the whole database and
data
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
