phpMyAdmin Database importing/exporting

[shawnm]

I have spent over a day and a half on this with no luck. I need to find a way to export my data and import it into another server. Seems simple, but this is just not working.

 

I have extensive HTML in the descriptions and special characters like quotation marks, apostrophes, degree signs, etc... when I export via phpMyAdmin, it looks perfect... when I import back in, all the quotation marks, apostrophes, and degree signs turn into question marks.

 

How in the world can I fix this? Is it the importing I am doing wrong or the exporting?

 

I know you can add a backslash before it and it will work, however I have too many descriptions to do this. Also,... if I copy the exported data and paste it into the import Run section, it will import perfectly. Again, database is too large to do it this way.

 

Any help will be greatly appreciated!

 

Thank you,

Shawn

[digbydo]

Never spotted this before so just tested it on the flag:

https://hostcms.co.uk/shop/product_info.php...ucts_id=28{6}14

 

worked a treat exporting as sql - came out looking like:

INSERT INTO `products_description` VALUES (28, 1, 'flag', 'spanish /mexican<br>\r\nA "special" character test ? HostCMS which is ? Netwise Computing Limited<br>\r\nAt > ? 15?? outside the weather is great', '', 3);

 

and went back in perfect :)

does your export follow that sort of pattern?

[shawnm]

OK thanks for the help... I think I may be on to something... Here is what happened. I copied what you had and imported it into my database, then I exported it again and it worked perfectly!

 

However, here is what I noticed. When I exported everything... here what it gave me:

 

CREATE TABLE `products_description` (

`products_id` int(11) NOT NULL auto_increment,

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

`products_name` varchar(75) NOT NULL default '',

`products_description` text,

`products_url` varchar(255) default NULL,

`products_viewed` int(5) default '0',

PRIMARY KEY (`products_id`,`language_id`),

KEY `products_name` (`products_name`)

) TYPE=MyISAM AUTO_INCREMENT=16277 ;

 

 

When I went to the other database and exported your data it gave me this:

 

CREATE TABLE `products_description` (

`products_id` int(11) NOT NULL auto_increment,

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

`products_name` varchar(75) NOT NULL default '',

`products_description` text,

`products_url` varchar(255) default NULL,

`products_viewed` int(5) default '0',

PRIMARY KEY (`products_id`,`language_id`),

KEY `products_name` (`products_name`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=16277 ;

 

Notice the Default Charset=latin1... and on my first database it did not give me a charset. How do I go about fixing this? I am running two different version of phpmyadmin... one is 2.6.4 and the other is 2.6.1 do you think that could be the problem?

 

Thanks for all of your help... this is really helping me out a bunch!

Shawn

[digbydo]

We have phpMyAdmin 2.6.3-pl1 installed and it's showing

) TYPE=MyISAM AUTO_INCREMENT= etc..