Jump to content

Sql Backup Question


Alec
 Share

Recommended Posts

One of my websites is currently running a Wiki script. The script uses a MySQL database, as the Wiki is starting to grow in size pretty rapidly I wanted to make a backup just incase anything should go wrong (as well as regular backups in the future every few weeks).

 

When I looked on the mediawiki website (the software I am using), it gives the following warning:

 

Warning for MySQL 4.1 and later: In some common configurations, mysqldump can corrupt MediaWiki's stored text. If your database's character set is set to "latin1" rather than "UTF-8", mysqldump in 4.1+ will apply a character set conversion step which can corrupt text containing non-English characters as well as punctuation like "smart quotes" and long dashes used in English text.

 

You can see which charset your tables are set to with a command like SHOW CREATE TABLE text. The last line will include a 'DEFAULT CHARSET' bit.

 

Use the option --default-character-set=latin1 on the mysqldump command line to avoid the conversion if you find it set to "latin1".

 

I don't have the first idea what it means or how to check what the default character set is. I poked about a little in phpMyAdmin, but in all honesty I didn't have a clue what I was doing. Can somebody please advise me on how to go about performing the check described above, or even just tell me if the database is likely to be set to latin1 or UTF-8?

 

Thanks in advance,

 

Alec

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...