I have tried to execute them but I get an error message.
Mysql server is running on the same box as apache is installed. sample error message when either sidocre.sql or simple.sql executed
---------------------------------------
./sidocre.sql
command not found 6:
command not found 12:
./sidocre.sql: line 13: DROP: command not found
command not found 13:
./sidocre.sql: line 14: CREATE: command not found
./sidocre.sql: line 16: syntax error near unexpected token `('
'/sidocre.sql: line 16: ` id SMALLINT(4) UNSIGNED NOT NULL AUTO_INCREMENT,
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
what do I do with the .sql files.
I have tried to execute them but I get an error message.
Mysql server is running on the same box as apache is installed. sample error message when either sidocre.sql or simple.sql executed
./sidocre.sql: line 14: CREATE: command not found
./sidocre.sql: line 16: syntax error near unexpected token `('
'/sidocre.sql: line 16: ` id SMALLINT(4) UNSIGNED NOT NULL AUTO_INCREMENT,
To answer my own question and if anybody else has the same problem the answer is.
create a database named "xxxx" or whatever you like
then "mysql "xxxx" < simple.sql" from command prompt
I got the same problem. I copied the text of sidocre.sql and pasted it into simple.sql, then I added the following lines at the beginning
CREATE DATABASE xxxxx
USE xxxxx
then (in ubuntu)
mmmm@serv:/var/srdata$ sudo mysql -h serv -u your_user -p < simple.sql
Enter password: *******