folkmunHi, This is a passage in my wp-comments table which I'm curious if it's ok:
ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci AUTO_INCREMENT=62963
The problem is when trying to restore the database the swedish characters gets messed up. They look like this:
Katt överkörd av djurplågare
Can I import this messed up wp_comment table to my new install without messing up all new comments as well.
This goes for wp_post which we also like to import.
Edit: This is what the first lines look:
`@OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Databas: web74595_ifolkmun
--
-- --------------------------------------------------------
--
-- Struktur för tabell wp_comments
--
DROP TABLE IF EXISTS wp_comments;
CREATE TABLE wp_comments (
comment_ID bigint(20) unsigned NOT NULL auto_increment,
comment_post_ID bigint(20) unsigned NOT NULL default '0',
comment_author tinytext character set latin1 NOT NULL,
comment_author_email varchar(100) character set latin1 NOT NULL default '',
comment_author_url varchar(200) character set latin1 NOT NULL default '',
comment_author_IP varchar(100) character set latin1 NOT NULL default '',
comment_date datetime NOT NULL default '0000-00-00 00:00:00',
comment_date_gmt datetime NOT NULL default '0000-00-00 00:00:00',
comment_content text character set latin1 NOT NULL,
comment_karma int(11) NOT NULL default '0',
comment_approved varchar(20) character set latin1 NOT NULL default '1',
comment_agent varchar(255) character set latin1 NOT NULL default '',
comment_type varchar(20) character set latin1 NOT NULL default '',
comment_parent bigint(20) unsigned NOT NULL default '0',
user_id bigint(20) unsigned NOT NULL default '0',
comment_subscribe enum('Y','N') character set latin1 NOT NULL default 'N',
PRIMARY KEY (comment_ID),
KEY comment_approved (comment_approved(1)),
KEY comment_post_ID (comment_post_ID),
KEY comment_approved_date_gmt (comment_approved,comment_date_gmt),
KEY comment_date_gmt (comment_date_gmt)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci AUTO_INCREMENT=62963 ;
--
-- Data i tabell wp_comments
--
INSERT INTO wp_comments
