Topic: phpMyAdmin - problems

[Poul Erik Lovskov]

Hi
I have SME 5.0 server running. I can use phpMyAdmin to create databases and it works just fine. I can run sql files to create phpnuke bases.

The problem is:
I have made an SME 5.5 test-server. I make phpMyAdmin to run - I can create databases - but I can´t run sql files to create tables.

I have tried severel times an installed again and again.

What can be wrong?

Poul Erik Lovskov

[Jon Blakely]

I just tried this my 5.5 machine and had no problems running a sql file.
What happens if from root you do

# mysql db_name < something.sql.

does this create the tables.

Also check the grants for the user you are logged in as and make sure that you have permission to CREATE TABLES.

Jon

[Poul Erik Lovskov]

Thanks

I could make tabels in that way - strange - but now I know what to look for.

Poul Erik

[guck puppy]

I have experienced related problems with phpmyadmin and .sql files - but when you say you can't make the tables using sql files, do you mean phpmyadmin returns an error? If so, what?

My problems had stemmed from bad "end of line" characters, so make sure that you don't have any weird invisible characters in your sql files.

G

[Poul Erik Lovskov]

No I don't recieve an error message. Nothing happens.

pel

[Bobby Wright]

I have noticed the same problem and really did not think about it until I saw this post.  It began after updating to RC2 of the latest build.

I just open the *.sql files in an editor and cut and paste into PHPMyAdmin's text block and hit the "Go" button.  Works every time.

-BobbyWright

[Poul Erik Lovskov]

Good idea - thank you.

poul erik