How to properly backup mediawiki database (mysql) without messing up the data?
- by Toto
I want to backup a mediawiki database stored in a MySQL server 5.1.36 using mysqldump.
Most of the wiki articles are written in spanish and a don't want to mess up with it by creating the dump with the wrong character set.
mysql> status
--------------
...
Current database: wikidb
Current user: root@localhost
...
Server version: 5.1.36-community-log MySQL Community Server (GPL)
....
Server characterset: latin1
Db characterset: utf8
Client characterset: latin1
Conn. characterset: latin1
...
Using the following command:
mysql> show create table text;
I see that the table create statement set the charset to binary:
CREATE TABLE `text` (
`old_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`old_text` mediumblob NOT NULL,
`old_flags` tinyblob NOT NULL,
PRIMARY KEY (`old_id`)
) ENGINE=InnoDB AUTO_INCREMENT=317 DEFAULT CHARSET=binary MAX_ROWS=10000000 AVG_ROW_LENGTH=10240
How should I use mysqldump to properly generate a backup for that database?
