icebox Posted March 3, 2006 Posted March 3, 2006 ”Specs” Windows 2003 running IIS 6 Mysqladministrator V 1.0 Mysql Version 4.1.18 Php V4.4.2 OScommerce 2.2 Hello all! I just registered, and what better way to say hello then with a problem :P Well anyway, more to the point. Im experiencing some problems with SQL/Oscommerce, don’t know if I should be posting on this site or if I should have posted it on the mysql site. A year or so back I installed Oscommerce successfully on a server (windows 2000), and over the last couple of months, a lot of new items (products), configurations and so on have been made to the shop. Well anyway, recently we decided to upgrade the server oscommerce was located on. (windows 2003) so I asked a kolega of mine to take a sql dump of the webshop before upgrading the server. And so he did, he used Mysqladministrator to backup the database, and backed up the oscommerce files. After installing all the new stuff on the “new” server, I decided on trying to import the sql dump with Mysqladmin,. The import starts, but after a little while I get a SQL error 1064. I’ve tried searching around a bit, but haven’t been able to find a similar case. So I’m hoping that possibly someone here could help me out Best regards Sql newbe
tonymazz Posted November 28, 2006 Posted November 28, 2006 ”Specs”Windows 2003 running IIS 6 Mysqladministrator V 1.0 Mysql Version 4.1.18 Php V4.4.2 OScommerce 2.2 Hello all! I just registered, and what better way to say hello then with a problem :P Well anyway, more to the point. Im experiencing some problems with SQL/Oscommerce, don’t know if I should be posting on this site or if I should have posted it on the mysql site. A year or so back I installed Oscommerce successfully on a server (windows 2000), and over the last couple of months, a lot of new items (products), configurations and so on have been made to the shop. Well anyway, recently we decided to upgrade the server oscommerce was located on. (windows 2003) so I asked a kolega of mine to take a sql dump of the webshop before upgrading the server. And so he did, he used Mysqladministrator to backup the database, and backed up the oscommerce files. After installing all the new stuff on the “new” server, I decided on trying to import the sql dump with Mysqladmin,. The import starts, but after a little while I get a SQL error 1064. I’ve tried searching around a bit, but haven’t been able to find a similar case. So I’m hoping that possibly someone here could help me out Best regards Sql newbe Did you get an answer for this? I just upgraded and am having similar issues. Tony Mazz
natewlew Posted November 28, 2006 Posted November 28, 2006 Please post what the error says. Other great Open Source (Free) programs: (Free as in free speech not free beer) The Gimp - An image program. | Firefox - All you have to do is add the Web Developer add-on to make this web browser complete. | FileZilla - An ftp program. | Inkscape - A good program to create images with. | Thunderbird - An email program. | Openoffice.org - An office suite that is compatible with MS Office. | Abiword - Another office suite. | Audacity - A sound recording tool. | ddp's Picks | Wordpress - An easy to use blogging software. | Joomla - An easy to use CMS that has ecommerce plug-ins. | Drupal - Another CMS How do I find these programs? Google Search!
tonymazz Posted November 28, 2006 Posted November 28, 2006 Please post what the error says. Thanks for the reply Nate. I located the answer after I posted. It has to do with a SQL upgrade. Thanks again Tony Mazz
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.