An Entrepreneur, Coach, IT Consultant, Strategic Adviser, and a Traveler craving to explore and contribute to forming a better society.

Friday, August 21, 2009

mysqldump utf8

1 comment :
Keywords: mysqldump options, mysqldump



mysqldump utf8

The following mysqldump option helps us specifying the charset we want the dump option to use


--default-character-set=charset_name

Example:

# mysqldump -u username -ppassword --databases database1,database2,databasen --default-character-set=charset_name

If no character set is specified, mysqldump uses utf8 (some older versions use latin1)

Keywords: mysqldump options, mysqldump

1 comment :

Colin said...

I created something earlier today that uses the mysqldump and then emails the .sql file to a recipient(s), best thing is you can schedule it in a cron job :) if you are interested see the source code here:

http://www.thephpanswers.com/viewtopic.php?f=11&t=8&start=0