Jump to content

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


engorgpk

Recommended Posts

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).

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.
Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.
Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
×
×
  • Create New...