• Dear Pleskians! The Plesk Forum will be undergoing scheduled maintenance on Monday, 7th of July, at 9:00 AM UTC. The expected maintenance window is 2 hours.
    Thank you in advance for your patience and understanding on the matter.

phpmyadmin/mysql

E

ejdbroker

Guest
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.
 
Try to import it from command line:

mysql -uadmin -p`cat /etc/psa/.psa.shadow` db_name < db.sql
 
the command line doesnt like this:

DEFAULT CHARSET=latin1 AUTO_INCREMENT=61

not sure why
 
Back
Top