Jump to content


Photo

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


  • This topic is locked This topic is locked
17 replies to this topic

#1 engorgpk

engorgpk

    Rank I Member

  • Members
  • Pip
  • 31 posts

Posted 22 June 2019 - 09:30 PM

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,

 

 

 



#2 Luigi123

Luigi123

    Rank X Member

  • Moderators
  • 1,759 posts
  • Gender:Male
  • Location:Winnipeg, Manitoba, Canada

Posted 22 June 2019 - 10:47 PM

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

#3 engorgpk

engorgpk

    Rank I Member

  • Members
  • Pip
  • 31 posts

Posted 22 June 2019 - 11:03 PM

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.

 

 

 

Attached Files



#4 Luigi123

Luigi123

    Rank X Member

  • Moderators
  • 1,759 posts
  • Gender:Male
  • Location:Winnipeg, Manitoba, Canada

Posted 23 June 2019 - 01:54 PM

Hmmm.

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

Escalating
Posted ImagePosted ImagePosted Image
Posted ImagePosted ImagePosted Image

#5 wolstech

wolstech

    Rank X Member

  • Root Admin
  • 10,776 posts
  • Gender:Male
  • Location:Pennsylvania

Posted 23 June 2019 - 04:02 PM

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

Please do not PM me for support. Posting on our forums lets all of us learn.
Do you play Minecraft? | Server Monitors | And the Dumbass of the Decade award goes to...


#6 engorgpk

engorgpk

    Rank I Member

  • Members
  • Pip
  • 31 posts

Posted 23 June 2019 - 07:47 PM

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

 

 

Attached Files



#7 Krydos

Krydos

    Rank X Member

  • Root Admin
  • 18,418 posts
  • Gender:Male

Posted 23 June 2019 - 08:18 PM

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.

#8 engorgpk

engorgpk

    Rank I Member

  • Members
  • Pip
  • 31 posts

Posted 23 June 2019 - 09:24 PM

Hi thanks for the help.

 

/home1/engorgpk/Dump20190624.sql

 

Please import to below database:

 

engorgpk_ngnr_wrdprss



#9 Krydos

Krydos

    Rank X Member

  • Root Admin
  • 18,418 posts
  • Gender:Male

Posted 23 June 2019 - 10:40 PM

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

#10 engorgpk

engorgpk

    Rank I Member

  • Members
  • Pip
  • 31 posts

Posted 24 June 2019 - 06:23 PM

Please check 

 

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


Edited by engorgpk, 24 June 2019 - 06:23 PM.


#11 Krydos

Krydos

    Rank X Member

  • Root Admin
  • 18,418 posts
  • Gender:Male

Posted 25 June 2019 - 02:52 AM

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.

#12 engorgpk

engorgpk

    Rank I Member

  • Members
  • Pip
  • 31 posts

Posted 26 June 2019 - 02:48 PM

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



#13 Krydos

Krydos

    Rank X Member

  • Root Admin
  • 18,418 posts
  • Gender:Male

Posted 28 June 2019 - 07:10 PM

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.


#14 engorgpk

engorgpk

    Rank I Member

  • Members
  • Pip
  • 31 posts

Posted 28 June 2019 - 07:52 PM

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.



#15 engorgpk

engorgpk

    Rank I Member

  • Members
  • Pip
  • 31 posts

Posted 28 June 2019 - 07:54 PM

Anyhow thanks for your help.






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users