• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

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