Can't import db

[fozdamar]

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 Expand

● 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

[fozdamar]

Alternative option: SSH

You can try this:

Code Select Expand

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

[Administrator]

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

Code Select Expand

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

[problemao]

Alternative option: SSH

You can try this:

Code Select Expand

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 Expand


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

Code Select Expand

post_max_size = 500M

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

[gdoner]

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

[leon3xs]

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

[randyproxz]

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

[Jae]

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

[Jae]

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

[Administrator]

this update resolves the issue (cwp version 0.9.8.180+)

Code Select Expand

yum update cwpsrv
/scripts/restart_cwpsrv