1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice

phpmyadmin/mysql

Discussion in 'Plesk for Linux - 8.x and Older' started by ejdbroker, Sep 5, 2005.

  1. ejdbroker

    ejdbroker Guest

    0
     
    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.
     
  2. hardweb

    hardweb Guest

    0
     
    Try to import it from command line:

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

    ejdbroker Guest

    0
     
    the command line doesnt like this:

    DEFAULT CHARSET=latin1 AUTO_INCREMENT=61

    not sure why
     
Loading...