Community

I just switched operating systems (to winxp pro from winme) and I can't quite get the same setup I had in winme running MySQL files thru the server via Textpad.

The following work-around does work.

1. Create a batch file containing the following:

cd <your path>\mysql\bin
mysql <command line preferences> < %1

2. Create a tool via the preferences menu. Use Add->Program.

3. Under the parameters section put $File >> mysql.out
( if you use > after the $File the output will be sent to mysql.out after erasing the file. If you use >> after the $File the output will be appended to the file. This is helpful)

4. Make sure the first line of your .sql file contains the use <your database> command.

My question is this. I didn't have to use a batch file in WinME, and I can't duplicate the setup in WinXP. In WinME I was able to put all the command line preferences and paths within TextPad. Can't seem to make this work now. Does anyone know how???

Thanks

Check whether your environment variable PATH contains the path to mysql\bin
if not, add this path.
Then it should work again.

Or set your tool up with the full path of mysql, i.e.
c:\programs\mysql\bin\mysql instead of just mysql.