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

    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

    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 Active Member

    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