Also, make sure you end your statement with ";" or "\G"...
mysql> SHOW CREATE TABLE text\G
If you are using MySQL 5, then you can get the information you want from the information_schema tables...
SELECT table_collation FROM information_schema.tables WHERE table_name = 'text' AND table_schema = 'database_name'
Be sure to change the "database_name" above to the name of the database you are using. If you want to see the collation from all tables for the wiki, just leave off the part of the WHERE statement that specifies the table.
Andrew
-----Original Message----- From: mediawiki-l-bounces@lists.wikimedia.org [mailto:mediawiki-l-bounces@lists.wikimedia.org] On Behalf Of Matthias Korn Sent: Tuesday, June 24, 2008 3:30 AM To: mediawiki-l@lists.wikimedia.org Subject: Re: [Mediawiki-l] backup advice wanted
Hi,
Am Mon, 23 Jun 2008 23:30:06 -0700 schrieb roger@rogerchrisman.com:
How can I see what character set my MediaWiki's mysql database is using?
[..]
mysql> SHOW CREATE TABLE text ->
you have to check for the correct name of your table. For me it is wiki_text => "SHOW CREATE TABLE wiki_text"
Regards, Matthias
-- Rock in China http://wiki.rockinchina.com/ http://www.rockinchina.com/
_______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l