Uploding to website..

[Guest]

Hi,

 

I worked on my local computer to setup my store as wanted. When I completed it I uploading it to my website using CuteFtp. I firstly installed it again on my website and copied the configuration files. I then uploaded my shop to my website and replaced the configuration file.

 

Everything worked well but the setting are some way lost. For example the Categories and the products.

 

What do suggest I should do? :blink: :blink:

[♥Vger]

Take a backup of your local database, dump the contents of your online database and import the contents of your local backup into it - using phpMyAdmin.

 

Vger

[Guest]

Ok thanks I will try it.. :blink: :rolleyes:

 

Regards,

 

Nick

[Guest]

Hi,

 

I droped the tables and created the tables and inserted the data into them successfully but I had to modify the SQL sysntax a bit>

 

CREATE TABLE `categories_description` (

`categories_id` int(11) NOT NULL default '0',

`language_id` int(11) NOT NULL default '1',

`categories_name` varchar(32) NOT NULL default '',

PRIMARY KEY (`categories_id`,`language_id`),

KEY `idx_categories_name` (`categories_name`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

I had to remove the DEFAULT CHARSET=latin1 cause the server on my web host runs on a newer version.

 

:blink: Now I noticed that when I insert Greek characters into the database through the configuration for the Categories menu they are not encoded correctly. A is added at the end and eats up the word.

Take a look here: http://www.myweather.gr/eshop/catalog/

 

What do you suggest?