Zen Cart Logo
Forums / Installing on a Linux/Unix Server / Moving Hosting and Upgrating to 1.3.7

Moving Hosting and Upgrating to 1.3.7

Locked

Views: 1,598

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
25 Jan 2007, 9:14 PM
#1
jgarabot avatar

jgarabot

New Zenner

Join Date:
Dec 2006
Posts:
17
Plugin Contributions:
0

Moving Hosting and Upgrating to 1.3.7

I am moving to a new host and upgrading at the same time, I have my database backed up but I don't know how to restore in the new database it keep giving me some errors when I try to upload the tables

#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' at line 4

I had made a fresh install from1.3.6 to 1.3.7 I don't know which files to add or replace in the new install

25 Jan 2007, 9:52 PM
#2
merlinpa1969 avatar

merlinpa1969

Totally Zenned

Join Date:
Mar 2004
Posts:
13,031
Plugin Contributions:
4

Re: Moving Hosting and Upgrating to 1.3.7

you need to open your DB file in a good text editor, and do a search replace

DEFAULT CHARSET=latin1' to

replace it with blank

25 Jan 2007, 10:07 PM
#3
jgarabot avatar

jgarabot

New Zenner

Join Date:
Dec 2006
Posts:
17
Plugin Contributions:
0

Re: Moving Hosting and Upgrating to 1.3.7

Now I get this

 CREATE  TABLE  `google_checkout` ( `customers_id` int( 11  ) default NULL ,

buyer_id bigint( 20 ) default NULL
) ENGINE = MYISAM --
-- Dumping data for table google_checkout


--
-- Table structure for table google_orders

DROP TABLE IF EXISTS google_orders

#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 'DROP TABLE IF EXISTS google_orders' at line 17

25 Jan 2007, 11:04 PM
#4
merlinpa1969 avatar

merlinpa1969

Totally Zenned

Join Date:
Mar 2004
Posts:
13,031
Plugin Contributions:
4

Re: Moving Hosting and Upgrating to 1.3.7

do the same search and replace for this stupid charachter

`

that little mark is a PITA