Restoring database in windows server - "mysql" not recognized command

[basa]

Hello,

I'm moving my forum to a window server and I am doing a test run, when I get to the part about restoring the database I follow these directions -

[1On the new server, if necessary, create the database which your vBulletin will be installed in. Refer to your host for specific information on how this is done.2Telnet/SSH into machine2.3Type:

mysql –uUSERNAME –p NEWDBNAME < /PATH/TO/NEW/DUMP.sql

The problem is that command line nor telnet will recognize that command. How do I restore the database on a window server?

Thank you,

Sebastian

[Steve Machol]

What happens exactly when you do this?

[basa]

What happens exactly when you do this?

It says

"'mysql' is not recognized as an internal or external command, operable program or batch file".

[Steve Machol]

This means that either 'mysql' is not installed on this server, or it is not in the default path. Try using the full path to mysql.

[basa]

This means that either 'mysql' is not installed on this server, or it is not in the default path. Try using the full path to mysql.

Installed it is, for sure.

Do you know a file that can I search for to make sure I find/have the right path?

[conqsoft]

Search for mysql.exe.

[basa]

Ok I see a mysql directory with subdiretories (Bench, Bin, data...) which one is "the" root directory?

[conqsoft]

Ok I see a mysql directory with subdiretories (Bench, Bin, data...) which one is "the" root directory?

The executable should be in the BIN directory.

[basa]

Thank you!

Let me give it a shot.

[Zachery]

Normally it would be under

C:\mysql\bin

or

c:\program files\mysql\bin

If its not in either of thoughs then you should contact your host.

[basa]

Normally it would be under

C:\mysql\bin

or

c:\program files\mysql\bin

If its not in either of thoughs then you should contact your host.

Thank you, that did the trick. It's working ok. I'm my own host (dedicated server). Scary, isn't it?

[Zachery]

If your going to be running windows and IIS make sure to run php as ISAPI instead of CGI or FastCGI

[basa]

If your going to be running windows and IIS make sure to run php as ISAPI instead of CGI or FastCGI

Thank you, that was an option that I wasn't sure how to configure.

[Zachery]

If you have questions on php and mysql on windows pop into the server configuration, I know we have a few big windows gurus who are hanging around and can probaly helpout

[basa]

If you have questions on php and mysql on windows pop into the server configuration, I know we have a few big windows gurus who are hanging around and can probaly helpout

Will do, thanks again.