CompatibleCarts Posted December 28, 2005 Share Posted December 28, 2005 Hi, I am trying to restore a 15.2mb file to my website but i cannot using the admin resotre and the phpmyadmin one doesnt seem to work. Any ideas? Many thanks Edd Link to comment Share on other sites More sharing options...
AlanR Posted December 28, 2005 Share Posted December 28, 2005 Hi, I am trying to restore a 15.2mb file to my website but i cannot using the admin resotre and the phpmyadmin one doesnt seem to work. Any ideas? Many thanks Edd Where do you have this file? Locally on your PC? What system is the server running and what system is your local PC? Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management) Link to comment Share on other sites More sharing options...
Jack_mcs Posted December 28, 2005 Share Posted December 28, 2005 Please read this. Jack Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
CompatibleCarts Posted December 28, 2005 Author Share Posted December 28, 2005 Where do you have this file? Locally on your PC? What system is the server running and what system is your local PC? Hi, I have the file saved on the pc and in the admin.backup folder. it is a linux system with cpanel and I am using windows xp. I have tried looking at that thread and it doesnt help. thanks Edd Link to comment Share on other sites More sharing options...
AlanR Posted December 28, 2005 Share Posted December 28, 2005 Hi, I have the file saved on the pc and in the admin.backup folder. it is a linux system with cpanel and I am using windows xp. I have tried looking at that thread and it doesnt help. thanks Edd OK, I assume you don't have ssh access to the server, right? On your local PC zip the file, you'll be surprised, it'll be about 10% - 15% of the original size, database files are ideal for compression, there are lots of space characters and tons of repeticious lines and entries. Then try uploading it into phpMyAdmin, it understands zip format automatically. I helped someone else with a similar problem, he emailed me a 3MB file. :lol: I gzipped it to about 350K, emailed it back to him and he imported it no sweat. Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management) Link to comment Share on other sites More sharing options...
CompatibleCarts Posted December 28, 2005 Author Share Posted December 28, 2005 OK, I assume you don't have ssh access to the server, right? On your local PC zip the file, you'll be surprised, it'll be about 10% - 15% of the original size, database files are ideal for compression, there are lots of space characters and tons of repeticious lines and entries. Then try uploading it into phpMyAdmin, it understands zip format automatically. thanks for your reply i have no idea what ssh is and do i use windows xp deafult zipper? thanks Edd Link to comment Share on other sites More sharing options...
AlanR Posted December 28, 2005 Share Posted December 28, 2005 thanks for your reply i have no idea what ssh is and do i use windows xp deafult zipper? thanks Edd The default zipper should be fine. zip is zip, it's a common standard. Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management) Link to comment Share on other sites More sharing options...
CompatibleCarts Posted December 28, 2005 Author Share Posted December 28, 2005 The default zipper should be fine. zip is zip, it's a common standard. wow, it went to 1.6mb!! in PHPmyadmin, where exactly do i go to upload it and what do i do? at the moment i open database topkno00_oscommerce and then click the small sql icon and then import files and browse for the file. Is this correct as it seems to create a new database? Thanks Edd Link to comment Share on other sites More sharing options...
AlanR Posted December 28, 2005 Share Posted December 28, 2005 wow, it went to 1.6mb!! in PHPmyadmin, where exactly do i go to upload it and what do i do? at the moment i open database topkno00_oscommerce and then click the small sql icon and then import files and browse for the file. Is this correct as it seems to create a new database? Thanks Edd If your server account lets you have multiple databases let it create a new one, who cares? Do you have a plain text editor that will open a 15MB file? Different versions of phyMyAdmin have slightly different interfaces, what version is running for you? Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management) Link to comment Share on other sites More sharing options...
CompatibleCarts Posted December 28, 2005 Author Share Posted December 28, 2005 wow, it went to 1.6mb!! in PHPmyadmin, where exactly do i go to upload it and what do i do? at the moment i open database topkno00_oscommerce and then click the small sql icon and then import files and browse for the file. Is this correct as it seems to create a new database? Thanks Edd when i do it this way i end up with this error: Error There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below: ----BEGIN CUT---- eNpzDQryD7JScDZUcDZS8HH1s1IwUjBWMDQz5QoOAYozc3E5hwVbKah4plgpFBfmFCQWFacW6eVk JukVZBTolCkY6Rmb6BnpGSoYGRiY6huY6RsbAHVbmVpYGRoq5KTmWiq4VhQoqHD5VgYH+lgpmOgZ 6BmZ6haXJOalJBalcIUGByn4B+soOLq7+oXoKIS5Au0Mz8xT8HRVMNMz4ArwdQQ6SM9Mz1i3IMeQ K8AjAKRExz8YZJKxHtAKn8y80gouH0c/dyuF1DzdzOJ8XQsLU0tdQy6wfQHezCwiDAwMHAzHZ+ka L5C1SNlwVobBjecvgzRQNCUpvjQ7NzFPF+R4QyNDS0MLQwMjUz2gR9/ERhc/OjGp7n38RMHnB+8K lvHvKpj9WUWPLSevt6C6NknZimulg1RLl6bnspnx9Zs2sXDsPP9OLafE+o1aeon1QvY3QZ5MXzRP /tp3Zs0leweV2I23C19+rJ7xtpJn3YkC5l/8y+vedG4yESn89FJeYMnLf9/v1wEAgziAoQ== ----END CUT---- ----BEGIN RAW---- ERROR: C1 C2 LEN: 2 3 165 STR: CVS: $Id: sqlparser.lib.php,v 2.34.2.1 2005/06/30 16:58:11 lem9 Exp $ MySQL: 4.0.25-standard USR OS, AGENT, VER: Win IE 6.0 PMA: 2.6.3-pl1 PHP VER,OS: 4.3.11 Linux LANG: en-iso-8859-1 SQL: PKǚ-3 8d??F?db_ukman-20051219181025.sql?][s?Ȓ~?_????v?p??$.ln?p{}b#: ?@??)I??_?????<?>??RI?)???̬??@$]??q??{??y??p??~쉲4q???????~ ----END RAW---- SQL query: PKǚ-3 8d??F ?db_ukman-20051219181025.sql?][s?Ȓ~?_????v?p??$.ln?p{}b#: ?@??)I??_?????<?>??RI?)???̬??@$]??q??{??y ??p??~쉲4q???????~ MySQL said: #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'PK' at line 1 i think this is wrong. any help much appreciated Edd Link to comment Share on other sites More sharing options...
CompatibleCarts Posted December 28, 2005 Author Share Posted December 28, 2005 when i do it this way i end up with this error: Error There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below: ----BEGIN CUT---- eNpzDQryD7JScDZUcDZS8HH1s1IwUjBWMDQz5QoOAYozc3E5hwVbKah4plgpFBfmFCQWFacW6eVk JukVZBTolCkY6Rmb6BnpGSoYGRiY6huY6RsbAHVbmVpYGRoq5KTmWiq4VhQoqHD5VgYH+lgpmOgZ 6BmZ6haXJOalJBalcIUGByn4B+soOLq7+oXoKIS5Au0Mz8xT8HRVMNMz4ArwdQQ6SM9Mz1i3IMeQ K8AjAKRExz8YZJKxHtAKn8y80gouH0c/dyuF1DzdzOJ8XQsLU0tdQy6wfQHezCwiDAwMHAzHZ+ka L5C1SNlwVobBjecvgzRQNCUpvjQ7NzFPF+R4QyNDS0MLQwMjUz2gR9/ERhc/OjGp7n38RMHnB+8K lvHvKpj9WUWPLSevt6C6NknZimulg1RLl6bnspnx9Zs2sXDsPP9OLafE+o1aeon1QvY3QZ5MXzRP /tp3Zs0leweV2I23C19+rJ7xtpJn3YkC5l/8y+vedG4yESn89FJeYMnLf9/v1wEAgziAoQ== ----END CUT---- ----BEGIN RAW---- ERROR: C1 C2 LEN: 2 3 165 STR: CVS: $Id: sqlparser.lib.php,v 2.34.2.1 2005/06/30 16:58:11 lem9 Exp $ MySQL: 4.0.25-standard USR OS, AGENT, VER: Win IE 6.0 PMA: 2.6.3-pl1 PHP VER,OS: 4.3.11 Linux LANG: en-iso-8859-1 SQL: PKǚ-3 8d??F?db_ukman-20051219181025.sql?][s?Ȓ~?_????v?p??$.ln?p{}b#: ?@??)I??_?????<?>??RI?)???̬??@$]??q??{??y??p??~쉲4q???????~ ----END RAW---- SQL query: PKǚ-3 8d??F ?db_ukman-20051219181025.sql?][s?Ȓ~?_????v?p??$.ln?p{}b#: ?@??)I??_?????<?>??RI?)???̬??@$]??q??{??y ??p??~쉲4q???????~ MySQL said: #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'PK' at line 1 i think this is wrong. any help much appreciated Edd i am usingversion 2.6.3 just to answer your question. thanks edd Link to comment Share on other sites More sharing options...
AlanR Posted December 28, 2005 Share Posted December 28, 2005 It looks like the file became corrupted somewhere along the line. It becomes more complicated now. I assume you're using a shared version of PMA provided by your host. I suggest you download and install the most recent version, get it at http://www.phpmyadmin.net/home_page/index.php If you need help post back, once it's installed we can try more things. If the file on your PC is corrupted the one on the server may be fine, the trick is to import it from a server directory which we can define. Are you trying to restore a backup to an existing store or trying to set up a new one? Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management) Link to comment Share on other sites More sharing options...
CompatibleCarts Posted December 28, 2005 Author Share Posted December 28, 2005 It looks like the file became corrupted somewhere along the line. It becomes more complicated now. I assume you're using a shared version of PMA provided by your host. I suggest you download and install the most recent version, get it at http://www.phpmyadmin.net/home_page/index.php If you need help post back, once it's installed we can try more things. If the file on your PC is corrupted the one on the server may be fine, the trick is to import it from a server directory which we can define. Are you trying to restore a backup to an existing store or trying to set up a new one? thanks for your reply. I am trying to set up a new site www.topknotch2.com thanks Edd Link to comment Share on other sites More sharing options...
CompatibleCarts Posted December 28, 2005 Author Share Posted December 28, 2005 thanks for your reply. I am trying to set up a new site www.topknotch2.com thanks Edd oops www.topknotch2.com/catalog Link to comment Share on other sites More sharing options...
AlanR Posted December 28, 2005 Share Posted December 28, 2005 oopswww.topknotch2.com/catalog So how did the file get to the server it's on now and where did it come from? Is the file on the server one you sent from your pc? The very same file version that's causing problems now? Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management) Link to comment Share on other sites More sharing options...
CompatibleCarts Posted December 29, 2005 Author Share Posted December 29, 2005 So how did the file get to the server it's on now and where did it come from? Is the file on the server one you sent from your pc? The very same file version that's causing problems now? it was a backup from the original site www.topknotch.com but i wouldl like to upload it for the new site. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.