Can't import db

Hello!

I just installed and started to use CWP and like it very much already but having one problem with importing ex-database, i tried to upload both .sql and sql.zip version on phpMyAdmin after it waits a very long time like 10-15min page is failing, it says "ERR_EMPTY_RESPONSE" and my file sql file is 8,44 MB (zip 1,48MB) i tried 2-3 times but same result all the time

On MySQL status i see this;

Code: [Select]

● mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf
   Active: active (running) since Tue 2017-01-31 08:17:53 UTC; 1h 9min ago
  Process: 6025 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 5985 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
  Process: 5983 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 5997 (mysqld)
   Status: "Taking your SQL requests now..."
   CGroup: /system.slice/mariadb.service
           └─5997 /usr/sbin/mysqld

Alternative option: SSH

You can try this:

Code: [Select]

mysql -uUSERNAME -pPASSWORD DATABASE_NAME < /home/USERNAME/public_html/BACKUP.sql

Yes it worked well thank you very much but i'm still wondering why i couldn't import on phpMyAdmin

if you are using centos 7 then run this from command line

Code: [Select]

yum -y remove cwpsrv
yum -y install cwpsrv
/scripts/restart_cwpsrv

Alternative option: SSH

You can try this:

Code: [Select]

mysql -uUSERNAME -pPASSWORD DATABASE_NAME < /home/USERNAME/public_html/BACKUP.sql

Yes it worked well thank you very much but i'm still wondering why i couldn't import on phpMyAdmin

I'm happy..

For phpMyAdmin:

Code: [Select]

yum install -y nano
nano /usr/local/cwp/php71/php.ini

Code: [Select]

post_max_size = 500M

same for me.. why we cant import databases with phpmyadmin? only with ssh...

Can not import with phpMyAdmin. I expect to be loaded for a while. Then a white page comes up. Importing with ssh only.

I have the same problem too!How I fix it?

the problem is with new CWP and mysql version is not compatible. Better CWP team fix it soon.

I have same problem too in centos 6, even with small sql files.
But no problem with centos 7

replace contects of /usr/local/cwpsrv/var/services/pma with version 4.7.0-rc1 (backup config.inc.php first, and restore later) make importing .sql file working. may be this is not safe solution, but working at least.

http://forum.centos-webpanel.com/mysql/after-updating-cwp-get-this-mysql-errors/msg10918/#msg10918

this update resolves the issue (cwp version 0.9.8.180+)

Code: [Select]

yum update cwpsrv
/scripts/restart_cwpsrv