|4-10-05, 08:53 PM||#1|
Join Date: Jun 2004
Location: Perth, Western Australia
Execute sql script from command line to create tables.
Can someone pelase tell me how to execute a sql script from the command line.
I am trying to set up phpESP and it says for me to run a script called mysql_populate.sql from the command line. As there are about 16 tables I figure it would easier (and safer) to run the script that to create the tables manually.
I am new to this so please any advice would be appreciated.
Below is an extract from the install manual.
Thanks in advance.
|4-10-05, 09:13 PM||#2|
Join Date: Jan 2005
Location: Pacifica, CA
You can do this in phpmyadmin.
1. Select your database on left.
2. Hit SQL tab at top.
3. Copy and paste the sql query you have into the box and hit go.
Also can upload SQL files to add to your DB.
It should go through flawlessly.