Problem uploading database from hostgator to centos web panel

General support questions
Post Reply
admmin
Posts: 1
Joined: 2018/02/21 13:50:38

Problem uploading database from hostgator to centos web panel

Post by admmin » 2018/02/21 13:57:36

i have tried to upload mysql file in .sql .zip .gzip
as well even i try to upload one by one files some files uploaded and some show error
what should i do not
error comes
"Error
Static analysis:

1 errors were found during analysis.

Missing expression. (near "ON" at position 25)
SQL query: Edit Edit

SET FOREIGN_KEY_CHECKS = ON;

MySQL said: Documentation

#2006 - MySQL server has gone away
Open new phpMyAdmin window

"





Warning in ./libraries/dbi/DBIMysqli.php#262
Error while sending QUERY packet. PID=839

Backtrace

./libraries/dbi/DBIMysqli.php#262: mysqli_query(
,
string 'DROP TABLE IF EXISTS `nvzel_aiowps_login_activity`',
integer 0,
)
./libraries/DatabaseInterface.php#244: PMA\libraries\dbi\DBIMysqli->realQuery(
string 'DROP TABLE IF EXISTS `nvzel_aiowps_login_activity`',
,
integer 0,
)
./libraries/import.lib.php#78: PMA\libraries\DatabaseInterface->tryQuery(string 'DROP TABLE IF EXISTS `nvzel_aiowps_login_activity`')
./libraries/import.lib.php#230: PMA_executeQuery(
string 'DROP TABLE IF EXISTS `nvzel_aiowps_login_activity`',
string 'DROP TABLE IF EXISTS `nvzel_aiowps_login_activity`',
array,

i am searching last 3 days and fine solution even i try to do nano editor but when i try to install it do nothing
even i try to add different format to upload database but nothing happen can any one tell me what the issue and what the solution for this to upload database

my database is 18 MB only i did configuration on php.in to upload maximum size but nothing happen

User avatar
TrevorH
Site Admin
Posts: 33202
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: Problem uploading database from hostgator to centos web panel

Post by TrevorH » 2018/02/21 16:10:15

You should ask the people that write CentOS Web Panel. It has nothing whatsoever to do with the CentOS project except that they have stolen our good name to brand their product.
The future appears to be RHEL or Debian. I think I'm going Debian.
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 and 6 are deadest, do not use them.
Use the FAQ Luke

Post Reply