Misui’s BUGS

MySQL Convert all collation table and fields with one command line

July 10th, 2009 misui
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

Posted in programming | 4 Comments »

  • 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

    • 02 visitor(s) online
    • powered by WassUp

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

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