Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Installing .sql script


jpn

Recommended Posts

I am currently moving to another Web Hosting Company.

 

I have made a back up of database and wish to install it into my new database.

 

I am connecting to my database using MYSQL Administrator.

 

 

Here is part of the SQL script

insert into address_book (address_book_id, customers_id, entry_gender, entry_company, entry_firstname, entry_lastname, entry_street_address, entry_suburb, entry_postcode, entry_city, entry_state, entry_country_id, entry_zone_id) values ('360', '304', '', NULL, Joe, Bloggs, '118 Dean Road', '', 'EH 510 HD', 'Bo\'Ness', NULL, '222', '0');

 

 

Here is the error message I receive

 

Script line: 379 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 ';

insert into address_book (address_book_id, customers_id, ent

 

Any data that has a \' in it brings the script to a halt.

 

Any ideas on how to solve this??

 

 

Jpn

 

PS IS there a minimum version of MYSQL that OSCommerce uses?

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...