Control Web Panel
WebPanel => MySQL => Topic started by: fozdamar on January 31, 2017, 09:28:38 AM
-
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;
● 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:
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
yum -y remove cwpsrv
yum -y install cwpsrv
/scripts/restart_cwpsrv
-
Alternative option: SSH
You can try this:
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:
yum install -y nano
nano /usr/local/cwp/php71/php.ini
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+)
yum update cwpsrv
/scripts/restart_cwpsrv