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

on database server :
root@web2:~# 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 ...

 

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

?

 

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

 

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.