[Mediawiki-l] backup advice wanted

[Sullivan, Andrew C CTR USA 116th (GD)]

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 at lists.wikimedia.org
[mailto:mediawiki-l-bounces at lists.wikimedia.org] On Behalf Of Matthias
Korn
Sent: Tuesday, June 24, 2008 3:30 AM
To: mediawiki-l at lists.wikimedia.org
Subject: Re: [Mediawiki-l] backup advice wanted

Hi,

Am Mon, 23 Jun 2008 23:30:06 -0700
schrieb roger at 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 at lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l