Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Transfer shop to another domain


thesiege84

Recommended Posts

I am trying to "duplicate" ,y shop onto another domain. I thought the process was the following:

 

1) Copy files from old domain accross to the new one.

2) Import backed up database to new domain

3) change config files

 

However i did step 1 and then i tried to import the database file into a new database that i created and it came up with the following error.

 

Error
SQL query: 

CREATE TABLE `address_book` (

`address_book_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`customers_id` int( 11 ) NOT NULL default '0',
`entry_gender` char( 1 ) NOT NULL default '',
`entry_company` varchar( 32 ) default NULL ,
`entry_firstname` varchar( 32 ) NOT NULL default '',
`entry_lastname` varchar( 32 ) NOT NULL default '',
`entry_street_address` varchar( 64 ) NOT NULL default '',
`entry_suburb` varchar( 32 ) default NULL ,
`entry_postcode` varchar( 10 ) NOT NULL default '',
`entry_city` varchar( 32 ) NOT NULL default '',
`entry_state` varchar( 32 ) default NULL ,
`entry_country_id` int( 11 ) NOT NULL default '0',
`entry_zone_id` int( 11 ) NOT NULL default '0',
PRIMARY KEY ( `address_book_id` ) ,
KEY `idx_address_book_customers_id` ( `customers_id` ) 
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =31;



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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=31' at line 17

 

 

Any help would be great thanks

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...