Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
mysql [2009/03/03 19:38]
greebo
mysql [2012/10/15 11:58] (current)
zagi old revision restored
Line 40: Line 40:
    mysql --user=username --password=password --execute="DROP DATABASE dbname; CREATE DATABASE dbname; CHARACTER SET utf8 COLLATE utf8_general_ci;"    mysql --user=username --password=password --execute="DROP DATABASE dbname; CREATE DATABASE dbname; CHARACTER SET utf8 COLLATE utf8_general_ci;"
    mysql --user=username --password=password --default-character-set=utf8 dbname < dump.sql    mysql --user=username --password=password --default-character-set=utf8 dbname < dump.sql
 +
  
  
Line 64: Line 65:
    # cat shema| mysql --default-character-set=utf8    # cat shema| mysql --default-character-set=utf8
    # cat data| mysql --default-character-set=latin2    # cat data| mysql --default-character-set=latin2
 +
 +===== Aternative (new) way Converting Character Sets  =====
 +
 +   wget http://www.pablowe.net/convert_charset
 +
 +It will be added to [[https://code.launchpad.net/perconatools|Percona Tools]] on Launchpad (or perhaps [[http://www.maatkit.org/|maatkit]], if it proves useful enough) once it is feature complete. Outstanding issues include:
  
 ===== InnoDB ===== ===== InnoDB =====
Line 94: Line 101:
 \\ \\
 </code> </code>
 +
 +=== Reducing ibdata mysql file ===
 +http://vdachev.net/blog/2007/02/22/mysql-reducing-ibdata1/
 +
mysql.1236105490.txt.gz ยท Last modified: 2009/05/25 00:34 (external edit)
CC Attribution-Share Alike 4.0 International
Driven by DokuWiki Recent changes RSS feed Valid CSS Valid XHTML 1.0 ipv6 ready