Author Topic: Can't import db  (Read 1845 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
Can't import db
« 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;

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

Offline
*
Re: Can't import db
« Reply #1 on: January 31, 2017, 09:35:12 AM »
Alternative option: SSH

You can try this:


Code: [Select]
mysql -uUSERNAME -pPASSWORD DATABASE_NAME < /home/USERNAME/public_html/BACKUP.sql

Offline
*
Re: Can't import db
« Reply #2 on: January 31, 2017, 09:57:13 AM »
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

Offline
*
Re: Can't import db
« Reply #3 on: January 31, 2017, 10:15:37 AM »
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

Offline
*
Re: Can't import db
« Reply #4 on: January 31, 2017, 02:03:46 PM »
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
AntiDDoS Protection (web + mail)
http://centos-webpanel.com/website-ddos-protection-proxy

Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp


Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor


Do you need Fast and FREE Support included for your CWP linux server?
http://centos-webpanel.com/noc-partner-list
Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services

Offline
*
Re: Can't import db
« Reply #5 on: March 06, 2017, 01:15:11 PM »
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...

Offline
*
Re: Can't import db
« Reply #6 on: March 17, 2017, 12:33:07 AM »
Can not import with phpMyAdmin. I expect to be loaded for a while. Then a white page comes up. Importing with ssh only.

Offline
*
Re: Can't import db
« Reply #7 on: March 23, 2017, 12:30:17 PM »
I have the same problem too!How I fix it?

Offline
*
Re: Can't import db
« Reply #8 on: March 23, 2017, 12:39:36 PM »
the problem is with new CWP and mysql version is not compatible. Better CWP team fix it soon.

Offline
***
Re: Can't import db
« Reply #9 on: March 26, 2017, 01:13:33 PM »
I have same problem too in centos 6, even with small sql files.
But no problem with centos 7

« Last Edit: March 26, 2017, 01:26:48 PM by Jae »

Offline
***
Re: Can't import db
« Reply #10 on: March 27, 2017, 02:16:35 AM »
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
« Last Edit: March 27, 2017, 02:33:20 AM by Jae »

Offline
*
Re: Can't import db
« Reply #11 on: March 27, 2017, 07:37:15 AM »
this update resolves the issue (cwp version 0.9.8.180+)

Code: [Select]
yum update cwpsrv
/scripts/restart_cwpsrv
AntiDDoS Protection (web + mail)
http://centos-webpanel.com/website-ddos-protection-proxy

Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp


Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor


Do you need Fast and FREE Support included for your CWP linux server?
http://centos-webpanel.com/noc-partner-list
Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services