mySQL question

dwilson · 16th February 2003, 04:15 PM

I am feeling like a real idiot.

I enter (via SSH) the following:

mysql mydatabase_name < thefile.sql;

it gives me a syntax error. ?? (yes, I am logged into mysql at the time)

Any ideas?

UH-Simon · 16th February 2003, 04:21 PM

Please try:

mysql -u"mysqlusername" -p mydatabase_name < thefile.sql

dwilson · 16th February 2003, 04:25 PM

tried that and still get syntax error

dwilson · 16th February 2003, 04:33 PM

I just did it from the control panel although I would like to know how to do that from the SSH.

I tried: mysql -u myname -p mydbase_name < myfile.sql;

and that didn't work

UH-Simon · 16th February 2003, 04:45 PM

I don't know why you're putting a ; on the end of the command. Please try it without that

dwilson · 16th February 2003, 04:57 PM

i did and it just goes to another line and then just sits there with no message and creates no tables. so I read the manual and it said the mysql commands have to have ; at the end

dwilson · 16th February 2003, 05:05 PM

this isn't going well. I only have problems with PHPnuke. the other portal I installed just fine.

Euge · 16th February 2003, 06:17 PM

Since you brought up portals a couple of days ago, I did a little research on phpnuke, postnuke, and xoop. I decided to play around with postnuke. Its installation is much cleaner than phpnuke.

dwilson · 16th February 2003, 06:25 PM

PHPnuke install just plain sucks.