[Solved] Can't upload backup or Upload any file using File Manager or FTP

[engorgpk]

Hello Sir,

 

 

Please look into my account I can't upload backup or Upload any file using File Manager or FTP,

 

I am trying to upload 100MB backup

 

 

Best Regards,

 

 

 

[Luigi123]

What error message did you get when you try to upload the backup files or files in File Manager or FTP?

[engorgpk]

Now uploading using Plain FTP and Port 21.

 

But still can't use Backup Restore option to restore database.

 

The browser goes to connection reset page.

 

Please see snapshot.

 

 

 

[Luigi123]

Hmmm.

 

I don’t know, i’ll have to get our root admin to help you with that.

 

Escalating

[wolstech]

Try creating an empty database instead, then use the import tab in phpmyadmin to restore the backup file into the database (edit the backup file first to remove the CREATE DATABASE statement).

[engorgpk]

Hi I was already trying to workout with PhpMyAdmin however there is problem as well.

 

 

[Krydos]

Put the .sql file in /home/engorgpk/whatever.sql and create the empty database that you want it loaded into in cpanel. Once you have those two steps done post the name of the file, and the name of the database you want it imported into and I'll do it on the command line. 100 MB is pretty massive for a database so the web interfaces are probably timing out or can't handle that large of a database.

[engorgpk]

Hi thanks for the help.

 

/home1/engorgpk/Dump20190624.sql

 

Please import to below database:

 

engorgpk_ngnr_wrdprss

[Krydos]

Double check your file. I'm not seeing it there.

[engorgpk]

Please check 

 

/etc/engineer.org.pk/Dump20190624.sql

Edited June 24, 2019 by engorgpk

[Krydos]

This is the reason your .sql file won't import:

INSERT INTO `ngnr_wfBlockedIPLog` VALUES (_binary '\0\0\0\0\0\0\0\0\0\0ÿÿl¢\×A','US',1,18056,'waf'),(_binary '\0\0\0\0\0\0\0\0\0\0ÿÿ¢<9e>Ne','US',1,1\0\0ÿÿ¬EZ^E','US',1,18050,'brute'),(_binary '\0\0\0\0\0\0\0\0\0\0ÿÿ¬D<84><8a>','US',1,18050,'brute');^M

See those <9e> and <84> etc? Those are binary characters which aren't valid in a .sql file.

[engorgpk]

Hi Root,

 

Thanks for help. I tried to split the db in parts now thats imported.

 

However seems there are so many restrictions on the server. I cant extract the backup file I uploaded /etc/engineer.org.pk/Backup-10-Jun-2019.zip

 

please extract this to /etc/engineer.org.pk/extracted

[Krydos]

However seems there are so many restrictions on the server.

The only real restriction is that your files must be valid. Once again your file is corrupt.

Archive:  Backup-10-Jun-2019.zip
  End-of-central-directory signature not found.  Either this file is not
  a zipfile, or it constitutes one disk of a multi-part archive.  In the
  latter case the central directory and zipfile comment will be found on
  the last disk(s) of this archive.
unzip:  cannot find zipfile directory in one of Backup-10-Jun-2019.zip or
        Backup-10-Jun-2019.zip.zip, and cannot find Backup-10-Jun-2019.zip.ZIP, period.

[engorgpk]

if the file is not valid how come its being extracted on windows?

 

can you please check downloading on windows?

 

Seems like another restriction. Please check your server.

 

The DB issue I found out on localserver installing wamp

 

it was also a restriction of max_allowed_packet.

[engorgpk]

Anyhow thanks for your help.