windows mysql backup

[timgerr]

I was wondering what the command is to backup a mysql database on windows. I tried to do a search for this in the forms but I kept getting error 404.

Thanks,
Timgerr

 

[KarveR]

mysqldump probably.

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[timgerr]

The windows version of mysql I could not find mysqldump. Any orther commands that I could script.

Thanks.

Timgerr

 

[Bastien]

If you have installed phpmysqladmin, use it

Bastien

Cat, the other other white meat

 

[TonyGroves]

If you're using only MyISAM tables, then a good way to do a backup is to use BACKUP TABLE:
[tt]
LOCK TABLE tbl1,tbl2,tbl3;
BACKUP TABLE tbl1,tbl2,tbl3 TO 'k:\tuesday';
UNLOCK TABLES;
[/tt]
This operation simply copies each table's data and format files to the named directory, so it has to be the fastest and most compact backup system possible.


-----
ALTER world DROP injustice, ADD peace;

 

[frank049]

you could download the mysql administrator from mysql web site. This has a backup facility, using a nice GUI interface. I have used it in a test enviroment and it worked just fine. Also you can set up daily or a weekly schedules as well. I'm new to mysql and found this to be a most useful tool still learning.
Hope this has been some use to you.

 

[rrsub]

%path to mysql executable%\mysqldump --all-databases > %backup path%\mysqlbackup_1.sql

-------------------------------------------

http://www.affordable-stock-photography.com