Command line syntax for script

[ChrisRChamberlain]

Hi all

MySQL newbie so please be gentle

Have a script that creates and populates a table which will execute via the EMS MySQL Mnager Lite interface if you open the database 'test' and run the *.sql script.

The *.sql script is located in the 'data' folder which is the parent folder of 'test'.

Having opened the database 'test' through the command line, what is the correct syntax to run the script, please?

TIA

FAQ184-2483 - answering getting answered.​

Chris
PDFcommander^tm.net
PDFcommander^tm.com

 

[TonyGroves]

If you want to run a SQL file from the command line, you can do:
[tt]
mysql [-u username] [-ppassword] [-h host] [database] <sqlfile.sql
[/tt]

 

[ChrisRChamberlain]

TonyGroves

Thanks for your response

Code used is

mysql> test <county.sql;

which produces ERROR 1064 <42000>:...

FAQ184-2483 - answering getting answered.​

Chris
PDFcommander^tm.net
PDFcommander^tm.com

 

[TonyGroves]

You need to run the command I gave from the shell command line. I don't know of any way to run external SQL files from within mysql.

 

[ChrisRChamberlain]

TonyGroves

Thanks - had assumed it would run from within mysql.

Placed county.sql in \bin folder and it worked although it seems a messy way to go at the moment.

FAQ184-2483 - answering getting answered.​

Chris
PDFcommander^tm.net
PDFcommander^tm.com

 

[TonyGroves]

You don't have to put the file into mysql/bin. You can specify a full file path, e.g. "<d:/mydir/mycommands.sql

 

[ChrisRChamberlain]

TonyGroves

Thanks - I assume a full path is the only option?

FAQ184-2483 - answering getting answered.​

Chris
PDFcommander^tm.net
PDFcommander^tm.com

 

[nego78]

ChrisRChamberlain: yes, you need to show full path

Via-Net - web directory