I'll maybe say something stupid, but if you have your files with your SQL
commands, couldn't you use this command ? :
mysql -u your_user -pyour_password < /path/to/your/SQL/commands/file
?
> -----Original Message-----
> From: Aires Lima Trindade [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, May 15, 2001 3:54 PM
> To: Myql List
> Subject: Run Mysql command from a file.
>
> Hi all.
> I'm new in this list, so may be this questions has already done
> here.
> I need to update my database daily at midnight. I want some file
> from which I can connect to mysql, switch to some database and work into
> tables (basically with delete and load commands).
> How can I do this? I had a look to "Using mysql in batch mode" and "
> How to run SQL commands from a text file" but they wasn't clear for me.
> Does anybody can share with me old experience or a real example
> about this case?
> Thanks in advance.
>
> Aires Trindade.
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php