How do I use mysqldump on Windows 2000?

[neal007]

I have forums, some very large, that I'd like to backup and they timeout with the admin area backup.

How do I do a mysqldump in Windows 2000? I have no clue how to use this!

Using the latest mysql (3.23?) and php 4.x

Thanks!

[ManagerJosh]

I don't have Windows 2000 but I suppose you could use something like phpmyadmin to make a MySQL Dump.

http://www.phpmyadmin.net

[seanf]

Go to Start > Run, type command and hit enter

Change to your bin directory:

cd c:\path\to\mysql\bin

Run the following command, after changing USERNAME, PASSWORD and DATABASE_NAME to your username, password and the name of the database you want to dump. Also remember to change the path where you want the file to be created:

mysqldump --opt -uUSERNAME -pPASSWORD DATABASE_NAME > "C:/path/to/dump/file.sql"

Sean

[Wayne Luke]

Following on this, if your server is remote, you will still need to log in via SSH or using some remote desktop application like PCAnywhere or Citrix Terminal.

[neal007]

Go to Start > Run, type command and hit enter

Change to your bin directory:

cd c:\path\to\mysql\bin

Run the following command, after changing USERNAME, PASSWORD and DATABASE_NAME to your username, password and the name of the database you want to dump. Also remember to change the path where you want the file to be created:

mysqldump --opt -uUSERNAME -pPASSWORD DATABASE_NAME > "C:/path/to/dump/file.sql"

Sean

Thanks. I'll give this a try. How long will it take to backup a 250 meg DB?

[Freezerator]

that depends on how fast your computer is

if it isn't ready after 30mins, try again

[seanf]

Thanks. I'll give this a try. How long will it take to backup a 250 meg DB?

Should just be a few minutes

Sean