Misui’s BUGS

MySQL Convert all collation table and fields with one command line

mysql –database=dbname -B -N -e “SHOW TABLES” | awk ‘{print “ALTER TABLE”, $1, “CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;”}’ | mysql –database=dbname &
thanks, http://www.commandlinefu.com/commands/view/1575/convert-all-mysql-tables-and-fields-to-utf8

This entry was posted on Friday, July 10th, 2009 at 7:48 pm and is filed under programming. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

« Watches
memory_limit »

4 Responses to “MySQL Convert all collation table and fields with one command line”

  1. mywpblog Says:
    September 16th, 2009 at 12:05 am

    You are not right. I can defend the position. Write to me in PM, we will communicate.

    And very interesting inforgation you can find here
    See you! :)
    gunherfieldu

  2. reverse phone lookup Says:
    January 10th, 2010 at 8:44 pm

    Blame you as a service to the wonderful information.

  3. Dukan Diet Australia Says:
    August 27th, 2010 at 1:30 am

    Welcome to my Dukan Diet Journey. I’m not doing this alone, be sure to check out other people in my blogroll who are on the same adventure as me!

  4. Dukan Diet Australia Says:
    August 29th, 2010 at 5:48 am

    Just what I was looking for. Google rocks - so glad I found this.

Leave a Reply

  • Recent Comments

    • Dukan Diet Australia on Notebook
    • Dukan Diet Australia on Adding Javadoc to NetBeans IDE
    • Dukan Diet Australia on Linux on iPaq h6365
    • Dukan Diet Australia on How will I die ?
    • Dukan Diet Australia on SVN error “Attempted to lock an already-locked dir”

  • Recent Posts

    • Show PID and kill it.
    • Regex thai language
    • memory_limit
    • MySQL Convert all collation table and fields with one command line
    • Watches

  • Pages

    • About

  • Archives

    • December 2009
    • September 2009
    • August 2009
    • July 2009
    • June 2009
    • May 2009
    • March 2009
    • February 2009
    • January 2009
    • December 2008
    • October 2008
    • September 2008
    • August 2008
    • June 2008
    • May 2008
    • April 2008

  • Categories

    • arm
    • camera
    • database
    • embeded
    • english
    • general
    • gps
    • linux
    • programming
    • programs
    • project
    • Uncategorized

  • Blogroll

    • Brewbg
    • JavaBoom Collection
    • llun
    • Makissy
    • Misui Multiply
    • Misui’s twitter
    • Sourcode
    • SvZ
    • UP1
    • Vunknown

  • Meta

    • Log in
    • Entries RSS
    • Comments RSS
    • WordPress.org

  • Visitors Online

    • 01 visitor(s) online
    • powered by WassUp

    • |_|0|_|
    |_|_|0|
    |0|0|0|

Misui’s BUGS is hosted by Nytes.net | Bob