artmaker Posted January 16, 2012 Share Posted January 16, 2012 Hey guys, I'm trying to move my old databse tables to a new one but always getting a error on the phpMyAdmin import function, stating that the file type is not supported: "You attempted to load file with unsupported compression (application/zip). Either support for it is not implemented or disabled by your configuration." I tried to import with different type of extensions such as, csv.zip / gzip sql,zip / gzip and so on but still getting the same error, the table that I'm trying to import is "ps_orders" and it's not on the PrestaShop control panel to automatically upload it, so if there are any other solutions please help me out! Link to comment Share on other sites More sharing options...
Richard S Posted January 17, 2012 Share Posted January 17, 2012 Have you tried to upload simple .sql file? Link to comment Share on other sites More sharing options...
artmaker Posted January 17, 2012 Author Share Posted January 17, 2012 Hi Richard! Yes i tried sql file too. Link to comment Share on other sites More sharing options...
Richard S Posted January 17, 2012 Share Posted January 17, 2012 And what error you got on .sql file? Link to comment Share on other sites More sharing options...
artmaker Posted January 17, 2012 Author Share Posted January 17, 2012 Its the error message I wrote above. "You attempted to load file with unsupported compression (application/zip). Either support for it is not implemented or disabled by your configuration." Link to comment Share on other sites More sharing options...
Richard S Posted January 17, 2012 Share Posted January 17, 2012 Hm... strange... Can you see all the queries when you open .sql with any text editor? Have you tried to re-export those tables from old database? Maybe the file is to big, but truly I cannot think of anything else useful. Link to comment Share on other sites More sharing options...
artmaker Posted January 17, 2012 Author Share Posted January 17, 2012 Can you see all the queries when you open .sql with any text editor? Yes I can, in the .csv file too, but when I export the table as gzip, it becomes corrupt (cannot open it). Have you tried to re-export those tables from old database? Yes I have, multiple times. Could it be because the version of the phpMyAdmin is older than the other one I'm trying to upload to? Because on the new DB's phpMyAdmin, I can see more professional & sleek design compared to the old one. Link to comment Share on other sites More sharing options...
Richard S Posted January 17, 2012 Share Posted January 17, 2012 Hm... There should not be any problems uploading import from older database version. It is hard to say anything else to me, maybe other community members will now a solution. Link to comment Share on other sites More sharing options...
artmaker Posted January 17, 2012 Author Share Posted January 17, 2012 Maybe I'm doing this wrong.. Going to phpMyAdmin>My DB>ps_orders (old one)>Export (blabla.csv.zip / sql.zip)>Go *switch tabs* Going to the other phpMyAdmin (they're in different hosts)>My DB>ps_orders (new one)>Import (the file I exported) (no settings touched)> Go Am I? Link to comment Share on other sites More sharing options...
Richard S Posted January 17, 2012 Share Posted January 17, 2012 Try to extract it from the .zip or .gzip and then important only the .sql file Link to comment Share on other sites More sharing options...
artmaker Posted January 17, 2012 Author Share Posted January 17, 2012 Try to extract it from the .zip or .gzip and then important only the .sql file I tried that too. Link to comment Share on other sites More sharing options...
Richard S Posted January 17, 2012 Share Posted January 17, 2012 Then I do not know what to say else Link to comment Share on other sites More sharing options...
artmaker Posted January 18, 2012 Author Share Posted January 18, 2012 Anyone else that has a solution for this? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now