• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

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