Welcome Guest. Please Login or Register  


You are here: Index > Webuzo > General Support > Topic : error importing databases



Threaded Mode | Print  

 error importing databases (12 Replies, Read 16935 times)
msda2006
Group: Member
Post Group: Newbie
Posts: 18
Status:
Hello,

I´m getting this error if i import databases

ERROR 2006 (HY000) at line 13111: MySQL server has gone away

Can this get fixed in the my.ini and where do i find this script ?

Many Thanks  :xd:

mike
IP: --   

error importing databases
valley
Group: Webuzo Team
Post Group: Super Member
Posts: 1644
Status:
Hi,

Is your MySQL service even running ?

You can us the following guide to restart it:
http://webuzo.com/wiki/Restart_services

Alternately, execute the following command:
Root > service mysqld restart

my.cnf is located at /etc/my.cnf

It is recommended that you do not alter configurations unknowingly which might cause the MySQL server to crash.

-----------------------
Webuzo : Single User Control Panel
Join Webuzo :
Facebook
Twitter

IP: --   

error importing databases
allahku
Group: Member
Post Group: Newbie
Posts: 6
Status:
I have same problem error 2006 : my sql server has gone away, we also have try your instruction restart mysql, but sill get problem. I still can't import database. also I don't found my.cnf in /etc/my.cnf
IP: --   

error importing databases
valley
Group: Webuzo Team
Post Group: Super Member
Posts: 1644
Status:
Did you remove the my.cnf file ?
Are you on CentOS or some other distro ?

-----------------------
Webuzo : Single User Control Panel
Join Webuzo :
Facebook
Twitter

IP: --   

error importing databases
allahku
Group: Member
Post Group: Newbie
Posts: 6
Status:
I'm using webuzo
IP: --   

error importing databases
allahku
Group: Member
Post Group: Newbie
Posts: 6
Status:
I'm using centos 5 32bit, I'm not feel remove my.cnf file
IP: --   

error importing databases
valley
Group: Webuzo Team
Post Group: Super Member
Posts: 1644
Status:
Could you please open a support ticket with the root details of your server and access to your Webuzo Enduser Panel, we will resolve your issues.

Support : https://www.softaculous.com/support/open.php

-----------------------
Webuzo : Single User Control Panel
Join Webuzo :
Facebook
Twitter

IP: --   

error importing databases
allahku
Group: Member
Post Group: Newbie
Posts: 6
Status:
Quote From : valley September 23, 2014, 5:39 am
Could you please open a support ticket with the root details of your server and access to your Webuzo Enduser Panel, we will resolve your issues.

Support : https://www.softaculous.com/support/open.php

Problem fixed, I'm import sql database using wordpress plugin. thank you
IP: --   

error importing databases
valley
Group: Webuzo Team
Post Group: Super Member
Posts: 1644
Status:
Glad to learn that your issue is resolved.

-----------------------
Webuzo : Single User Control Panel
Join Webuzo :
Facebook
Twitter

IP: --   

error importing databases
FPVtv
Group: Member
Post Group: Newbie
Posts: 2
Status:
Quote From : valley September 24, 2014, 5:47 am
Glad to learn that your issue is resolved.


I am facing this problem from 2 days , test SQL have  16mb size , after uploading there is still same message that sql gone away, if I try to upload 1mb sql size there is no problem.

Every setting is switch to max upload size 500MB. System ubuntu 14.04 / VPS

IP: --   

error importing databases
valley
Group: Webuzo Team
Post Group: Super Member
Posts: 1644
Status:
Quote From : FPVtv January 14, 2015, 9:41 pm
Quote From : valley September 24, 2014, 5:47 am
Glad to learn that your issue is resolved.


I am facing this problem from 2 days , test SQL have  16mb size , after uploading there is still same message that sql gone away, if I try to upload 1mb sql size there is no problem.

Every setting is switch to max upload size 500MB. System ubuntu 14.04 / VPS



Increase post_max_size as well in the /usr/local/emps/etc/php.ini

Hope this helps :)


-----------------------
Webuzo : Single User Control Panel
Join Webuzo :
Facebook
Twitter

IP: --   

error importing databases
FPVtv
Group: Member
Post Group: Newbie
Posts: 2
Status:
[/quote]

Increase post_max_size as well in the /usr/local/emps/etc/php.ini

Hope this helps :)
[/quote]

Nope :) ,  Like I wrote I canupload 500mb sql or file. I changed  php.ini in 3 different and this is not problem about size or time out, problem is somwhere deeper in a code.  I tested this on 3 different VPS and there is still same problem with bigger SQL.
IP: --   

error importing databases
valley
Group: Webuzo Team
Post Group: Super Member
Posts: 1644
Status:
[quote poster=FPVtv date=1421398121][/quote]

Increase post_max_size as well in the /usr/local/emps/etc/php.ini

Hope this helps :)
[/quote]

Nope :) ,  Like I wrote I canupload 500mb sql or file. I changed  php.ini in 3 different and this is not problem about size or time out, problem is somwhere deeper in a code.  I tested this on 3 different VPS and there is still same problem with bigger SQL.[/quote]

Could you please open a support ticket with the root details of your server and access to your Webuzo Enduser Panel, we will resolve your issues.

https://www.softaculous.com/support/open.php


-----------------------
Webuzo : Single User Control Panel
Join Webuzo :
Facebook
Twitter

IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is March 29, 2024, 10:04 am.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.025