Batch processing of commands

Hi all,

I need to know 2 things:

1) If I want to batch process commands into MySQL on my server, where do I upload (ftp) the file? Into what directory so that the command "shell> mysql < batch.file" knows where to find it?

2) I have MySQL configured on Win95. How can I load batch commands to process locally?

Thanks a lot if you can help me!!!

Bryan

The best way is to upload the files to your home directory, and then include the whole path to the file in your mysql < statement.

Generally on a Unix server it will look something like mysql -u yourname -h hostname -p < /usr/home/yourusername/batch.file

If you are not sure where your home directory is, try entering "pwd" (Present Working Directory) from the ftp or telnet command prompt after you have logged in.

On your Win95 system, of course the path will be a "c:" type directory path.