Problem uploading database from hostgator to centos web panel
Posted: 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
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
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