phpmyadmin/mysql

[ejdbroker]

Ive created a database, and a user via the PSA interface. Ive gone into the phpmyadmin through PSA and see the one database ive created. Its empty. I export the database from the old server via phpmyadmin and import it on the plesk server. It goes through without an error, but the database has nothing in it. No tables at all. What am i doing wrong? Why wont it import? There were some syntax errors, but I fixed those (it doesnt error on the import). Im importing via the sql tab of the database.

 

[hardweb]

Try to import it from command line:

mysql -uadmin -p`cat /etc/psa/.psa.shadow` db_name < db.sql

 

[ejdbroker]

the command line doesnt like this:

DEFAULT CHARSET=latin1 AUTO_INCREMENT=61

not sure why