Wow, that was a fast answer, thanks! :)
Unfortunately, I dont get it yet: I have BBEdit and a backup of my sql-file; but what is it precisely that has to be edited?
Here's a bit of the sql-file, it's the part with the categories: do you want me to delete everything between "CREATE TABLE" and "... AUTO_INCREMENT=6 ;"?
Of course, there are a lot of instances of text-blocks like this.
------------------from the .sql-file-----------------------------
-- Table structure for table wp_categories
--
DROP TABLE IF EXISTS wp_categories;
CREATE TABLE wp_categories (
cat_ID bigint(20) NOT NULL auto_increment,
cat_name varchar(55) NOT NULL default '',
category_nicename varchar(200) NOT NULL default '',
category_description longtext NOT NULL,
category_parent int(4) NOT NULL default '0',
PRIMARY KEY (cat_ID),
UNIQUE KEY cat_name (cat_name),
KEY category_nicename (category_nicename)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
--
-- Dumping data for table wp_categories
--
INSERT INTO wp_categories VALUES (1, 'General', 'general', '', 0);
INSERT INTO wp_categories VALUES (2, 'Generisch', 'generisch', '', 0);
INSERT INTO wp_categories VALUES (3, 'Bla√É≈�rot', 'bla%c3%9frot', '', 0);
INSERT INTO wp_categories VALUES (4, 'Veilchenrot', 'veilchenrot', '', 0);
INSERT INTO wp_categories VALUES (5, 'Schwarzrot', 'schwarzrot', '', 0);
----------------------------------------------------------
Actually, I was thinking that I could fix something about the charset-encoding when exporting the database, in order to get a sql-backup-file which is suitable for the MySQL on the server-site. Wrong idea?
I mean, I thought I could adjust the exported db-information in any way necessary.
Would be great if you could give me another hint. Sorry, being new to all this stuff.
