Cannot import database with phpmyadmin, nor root access to server : this is an issue for end user

Discussion in 'Installation/Configuration' started by ledufakademy, Sep 20, 2020.

  1. ledufakademy

    ledufakademy Member HowtoForge Supporter

    on database server :
    [email protected]:~# mysql -h localhost -p -u c6_etherpad c6_etherpad < etherpad_lite_db.sql
    Enter password:
    ERROR 1045 (28000): Access denied for user 'c6_etherpad'@'localhost' (using password: YES)
    [ SOLVE ] : because , need to change localhost with db2.domain.com, database is not on web server ;-)
    But see below phpmyadmin is still an issue ... can't import database ...
     
    Last edited: Sep 20, 2020
  2. ledufakademy

    ledufakademy Member HowtoForge Supporter

    With phpmyadmin ... long timeout then crash ... (in php.ini 768MB) ... the file is only 523MB ...
    upload_max_filesize
    post_max_size

    ?
     
    Last edited: Sep 20, 2020
  3. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    I usually use MariaDB from the cli for big DB files.
     
    ledufakademy likes this.
  4. Steini86

    Steini86 Active Member

    Probably a limitation of max_execution_time? For such big files, use the command line or split into several smaller files.
     
    ledufakademy likes this.
  5. nhybgtvfr

    nhybgtvfr Well-Known Member HowtoForge Supporter

    also try exporting the original database using the cli, and look at various export options single-transaction, extended-insert=false etc.
    you may need to try a few different variations, i know i had one large database i had trouble importing, would take absolutely ages and then fail, finally got one combination of options it liked, imported the db on the new server in seconds.
     

Share This Page