1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Rep Power
    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!!!

  2. #2
  3. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Central Florida, USA
    Rep Power
    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.

Similar Threads

  1. CGI commands not working
    By stringman in forum IIS
    Replies: 3
    Last Post: February 11th, 2004, 12:56 PM
  2. not executing commands using Open3
    By othermatty in forum Perl Programming
    Replies: 5
    Last Post: September 9th, 2003, 06:52 PM
  3. Running dos commands from perl (server side script)
    By keeronmodi in forum Perl Programming
    Replies: 8
    Last Post: August 25th, 2003, 04:26 PM
  4. passing commands to perl thru a batch file...please help
    By sclark in forum Perl Programming
    Replies: 2
    Last Post: July 31st, 2002, 05:45 PM
  5. MySQL commands with require()
    By BicyclePunk in forum PHP Development
    Replies: 1
    Last Post: July 25th, 2002, 04:33 PM

IMN logo majestic logo threadwatch logo seochat tools logo