DokuWiki

• encodingu määramine:

CREATE TABLE unicode_stuff (
 ...
) CHARACTER SET utf8;

CREATE TABLE intl_strings (
  id INTEGER UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  german_string VARCHAR(255) CHARACTER SET latin1,
  japanese_string VARCHAR(255) CHARACTER SET utf8,
  enlish_us_string VARCHAR(255) CHARACTER SET latin1,
  chinese_string VARCHAR(255) CHARACTER SET big5
);

where clausliga normaalse dump'i tegemine mysqldump -c -t –compact –host=84.50.42.170 –lock-tables=false -u dtvmw -p dtvmw recording_watched –where=“watch_start between '2012-07-01 21:00:00' and '2012-07-03 00:04:00'” > /tmp/dump.sql