I tried to restore my database from myphpadmin but i got this error - "You attempted to load file with unsupported compression (application/zip). Either support for it is not implemented or disabled by your configuration." What can i do to fix this? Thanks. I need help please.
you need to upload the .sql file not a .zip file. If the file is too large then you should look at using this great program called bigdump http://www.ozerov.de/bigdump.php this will import in stages, also if the file is in gzip format it will import that
I upload the .sql file and not the .zip file. I seem not to know how to use the bigdump. The tool is too complicated for me.
Please could you elaborate because i do not get this please. What is an editor? Where can i get one? How can i copy manually from editor to sql tab? Where can i find the sql tab? Please am new to all this.
Editor such as Notepad and the SQL tab is called SQL and once you click the database your using you will see the tab labeled as such. Copy and paste from your .sql file into the window and click GO.
This post ( below ) is the way I have been doing it for years. It works fine. Open the backup like a regular text file and put it (copy and paste) in the SQL command window that is under "SQL". Empty your tables just before you do this. Create backups of your database without compression and download them as a text file (.sql ). Good luck.
As you have been suggested you should try to extract the zipped file, open it with an editor ( notepad++ is a good one ). This means you double click on the zip file and drag the contained file from there to the editor. Done this you can paste it into PHPmyAdmin SQL tab ( click SQL from the top menu ). If the file is too large and gives you problems you can copy/paste in multiple times, just make sure you don't break SQL instructions ( always paste parts ending with ';' ) As suggested bigdump is a handy tool you should always consider when working with large databases on shared hosting accounts.