engorgpk Posted June 22, 2019 Share Posted June 22, 2019 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, Link to comment Share on other sites More sharing options...
Luigi123 Posted June 22, 2019 Share Posted June 22, 2019 What error message did you get when you try to upload the backup files or files in File Manager or FTP? Link to comment Share on other sites More sharing options...
engorgpk Posted June 22, 2019 Author Share Posted June 22, 2019 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. Link to comment Share on other sites More sharing options...
Luigi123 Posted June 23, 2019 Share Posted June 23, 2019 Hmmm. I don’t know, i’ll have to get our root admin to help you with that. Escalating Link to comment Share on other sites More sharing options...
wolstech Posted June 23, 2019 Share Posted June 23, 2019 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 More sharing options...
engorgpk Posted June 23, 2019 Author Share Posted June 23, 2019 Hi I was already trying to workout with PhpMyAdmin however there is problem as well. Link to comment Share on other sites More sharing options...
Krydos Posted June 23, 2019 Share Posted June 23, 2019 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 More sharing options...
engorgpk Posted June 23, 2019 Author Share Posted June 23, 2019 Hi thanks for the help. /home1/engorgpk/Dump20190624.sql Please import to below database: engorgpk_ngnr_wrdprss Link to comment Share on other sites More sharing options...
Krydos Posted June 23, 2019 Share Posted June 23, 2019 Double check your file. I'm not seeing it there. Link to comment Share on other sites More sharing options...
engorgpk Posted June 24, 2019 Author Share Posted June 24, 2019 (edited) Please check /etc/engineer.org.pk/Dump20190624.sql Edited June 24, 2019 by engorgpk Link to comment Share on other sites More sharing options...
Krydos Posted June 25, 2019 Share Posted June 25, 2019 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 More sharing options...
engorgpk Posted June 26, 2019 Author Share Posted June 26, 2019 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 More sharing options...
Krydos Posted June 28, 2019 Share Posted June 28, 2019 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 More sharing options...
engorgpk Posted June 28, 2019 Author Share Posted June 28, 2019 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 More sharing options...
engorgpk Posted June 28, 2019 Author Share Posted June 28, 2019 Anyhow thanks for your help. Link to comment Share on other sites More sharing options...
Recommended Posts