Support » Fixing WordPress » Trying to move WP to a new server

  • I can’t import my old database to the new server … following error shows up …
    #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near …

    I don’t have access to my old server anymore 🙁
    any ideas?
    thanks

Viewing 3 replies - 1 through 3 (of 3 total)
  • Moderator t-p

    (@t-p)

    I don’t have access to my old server anymore

    – Try asking your new host for assistance. They should be able to help you.

    – also, there is this useful WP codex: https://codex.wordpress.org/Moving_WordPress#Moving_to_a_New_Server

    the 1064 error may be caused by different causes. You may need to trouble shoot on your import file. You can search “#1064 – You have an error in your SQL syntax” in google to find some hints (e.g. MySQL Error 1064: You have an error in your SQL syntax) for solution.

    thanks for the quick reply … I searched google, but nothing i tried really worked and my new host told me to ask in a forum 🙁

    here’s the file, maybe someone knows what to change?

    here’s part of the code, can’t seem to post all of it:

    --
    -- Table structure for table <code>CHARACTER_SETS</code>
    -- 
    
    CREATE TEMPORARY TABLE <code>CHARACTER_SETS</code> (
      <code>CHARACTER_SET_NAME</code> varchar(64) NOT NULL default '',
      <code>DEFAULT_COLLATE_NAME</code> varchar(64) NOT NULL default '',
      <code>DESCRIPTION</code> varchar(60) NOT NULL default '',
      <code>MAXLEN</code> bigint(3) NOT NULL default '0'
    ) ENGINE=MEMORY DEFAULT CHARSET=utf8;
    
    --
    -- Dumping data for table <code>CHARACTER_SETS</code>
    -- 
    
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('big5', 'big5_chinese_ci', 'Big5 Traditional Chinese', 2);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('dec8', 'dec8_swedish_ci', 'DEC West European', 1);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('cp850', 'cp850_general_ci', 'DOS West European', 1);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('hp8', 'hp8_english_ci', 'HP West European', 1);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('koi8r', 'koi8r_general_ci', 'KOI8-R Relcom Russian', 1);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('latin1', 'latin1_swedish_ci', 'cp1252 West European', 1);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('latin2', 'latin2_general_ci', 'ISO 8859-2 Central European', 1);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('swe7', 'swe7_swedish_ci', '7bit Swedish', 1);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('ascii', 'ascii_general_ci', 'US ASCII', 1);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('ujis', 'ujis_japanese_ci', 'EUC-JP Japanese', 3);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('sjis', 'sjis_japanese_ci', 'Shift-JIS Japanese', 2);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('hebrew', 'hebrew_general_ci', 'ISO 8859-8 Hebrew', 1);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('tis620', 'tis620_thai_ci', 'TIS620 Thai', 1);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('euckr', 'euckr_korean_ci', 'EUC-KR Korean', 2);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('koi8u', 'koi8u_general_ci', 'KOI8-U Ukrainian', 1);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('gb2312', 'gb2312_chinese_ci', 'GB2312 Simplified Chinese', 2);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('greek', 'greek_general_ci', 'ISO 8859-7 Greek', 1);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('cp1250', 'cp1250_general_ci', 'Windows Central European', 1);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('gbk', 'gbk_chinese_ci', 'GBK Simplified Chinese', 2);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('latin5', 'latin5_turkish_ci', 'ISO 8859-9 Turkish', 1);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('armscii8', 'armscii8_general_ci', 'ARMSCII-8 Armenian', 1);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('utf8', 'utf8_general_ci', 'UTF-8 Unicode', 3);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('ucs2', 'ucs2_general_ci', 'UCS-2 Unicode', 2);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('cp866', 'cp866_general_ci', 'DOS Russian', 1);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('keybcs2', 'keybcs2_general_ci', 'DOS Kamenicky Czech-Slovak', 1);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('macce', 'macce_general_ci', 'Mac Central European', 1);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('macroman', 'macroman_general_ci', 'Mac West European', 1);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('cp852', 'cp852_general_ci', 'DOS Central European', 1);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('latin7', 'latin7_general_ci', 'ISO 8859-13 Baltic', 1);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('cp1251', 'cp1251_general_ci', 'Windows Cyrillic', 1);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('cp1256', 'cp1256_general_ci', 'Windows Arabic', 1);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('cp1257', 'cp1257_general_ci', 'Windows Baltic', 1);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('binary', 'binary', 'Binary pseudo charset', 1);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('geostd8', 'geostd8_general_ci', 'GEOSTD8 Georgian', 1);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('cp932', 'cp932_japanese_ci', 'SJIS for Windows Japanese', 2);
    INSERT INTO <code>CHARACTER_SETS</code> VALUES ('eucjpms', 'eucjpms_japanese_ci', 'UJIS for Windows Japanese', 3);
    
    -- --------------------------------------------------------
    
    --
    -- Table structure for table <code>COLLATIONS</code>
    -- 
    
    CREATE TEMPORARY TABLE <code>COLLATIONS</code> (
      <code>COLLATION_NAME</code> varchar(64) NOT NULL default '',
      <code>CHARACTER_SET_NAME</code> varchar(64) NOT NULL default '',
      <code>ID</code> bigint(11) NOT NULL default '0',
      <code>IS_DEFAULT</code> varchar(3) NOT NULL default '',
      <code>IS_COMPILED</code> varchar(3) NOT NULL default '',
      <code>SORTLEN</code> bigint(3) NOT NULL default '0'
    ) ENGINE=MEMORY DEFAULT CHARSET=utf8;
    
    --
    -- Dumping data for table <code>COLLATIONS</code>
    -- 
    
    INSERT INTO <code>COLLATIONS</code> VALUES ('big5_chinese_ci', 'big5', 1, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('big5_bin', 'big5', 84, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('dec8_swedish_ci', 'dec8', 3, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('dec8_bin', 'dec8', 69, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('cp850_general_ci', 'cp850', 4, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('cp850_bin', 'cp850', 80, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('hp8_english_ci', 'hp8', 6, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('hp8_bin', 'hp8', 72, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('koi8r_general_ci', 'koi8r', 7, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('koi8r_bin', 'koi8r', 74, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('latin1_german1_ci', 'latin1', 5, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('latin1_swedish_ci', 'latin1', 8, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('latin1_danish_ci', 'latin1', 15, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('latin1_german2_ci', 'latin1', 31, '', 'Yes', 2);
    INSERT INTO <code>COLLATIONS</code> VALUES ('latin1_bin', 'latin1', 47, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('latin1_general_ci', 'latin1', 48, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('latin1_general_cs', 'latin1', 49, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('latin1_spanish_ci', 'latin1', 94, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('latin2_czech_cs', 'latin2', 2, '', 'Yes', 4);
    INSERT INTO <code>COLLATIONS</code> VALUES ('latin2_general_ci', 'latin2', 9, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('latin2_hungarian_ci', 'latin2', 21, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('latin2_croatian_ci', 'latin2', 27, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('latin2_bin', 'latin2', 77, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('swe7_swedish_ci', 'swe7', 10, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('swe7_bin', 'swe7', 82, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('ascii_general_ci', 'ascii', 11, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('ascii_bin', 'ascii', 65, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('ujis_japanese_ci', 'ujis', 12, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('ujis_bin', 'ujis', 91, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('sjis_japanese_ci', 'sjis', 13, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('sjis_bin', 'sjis', 88, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('hebrew_general_ci', 'hebrew', 16, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('hebrew_bin', 'hebrew', 71, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('tis620_thai_ci', 'tis620', 18, 'Yes', 'Yes', 4);
    INSERT INTO <code>COLLATIONS</code> VALUES ('tis620_bin', 'tis620', 89, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('euckr_korean_ci', 'euckr', 19, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('euckr_bin', 'euckr', 85, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('koi8u_general_ci', 'koi8u', 22, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('koi8u_bin', 'koi8u', 75, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('gb2312_chinese_ci', 'gb2312', 24, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('gb2312_bin', 'gb2312', 86, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('greek_general_ci', 'greek', 25, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('greek_bin', 'greek', 70, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('cp1250_general_ci', 'cp1250', 26, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('cp1250_czech_cs', 'cp1250', 34, '', 'Yes', 2);
    INSERT INTO <code>COLLATIONS</code> VALUES ('cp1250_croatian_ci', 'cp1250', 44, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('cp1250_bin', 'cp1250', 66, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('gbk_chinese_ci', 'gbk', 28, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('gbk_bin', 'gbk', 87, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('latin5_turkish_ci', 'latin5', 30, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('latin5_bin', 'latin5', 78, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('armscii8_general_ci', 'armscii8', 32, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('armscii8_bin', 'armscii8', 64, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('utf8_general_ci', 'utf8', 33, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('utf8_bin', 'utf8', 83, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('utf8_unicode_ci', 'utf8', 192, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('utf8_icelandic_ci', 'utf8', 193, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('utf8_latvian_ci', 'utf8', 194, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('utf8_romanian_ci', 'utf8', 195, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('utf8_slovenian_ci', 'utf8', 196, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('utf8_polish_ci', 'utf8', 197, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('utf8_estonian_ci', 'utf8', 198, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('utf8_spanish_ci', 'utf8', 199, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('utf8_swedish_ci', 'utf8', 200, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('utf8_turkish_ci', 'utf8', 201, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('utf8_czech_ci', 'utf8', 202, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('utf8_danish_ci', 'utf8', 203, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('utf8_lithuanian_ci', 'utf8', 204, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('utf8_slovak_ci', 'utf8', 205, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('utf8_spanish2_ci', 'utf8', 206, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('utf8_roman_ci', 'utf8', 207, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('utf8_persian_ci', 'utf8', 208, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('utf8_esperanto_ci', 'utf8', 209, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('utf8_hungarian_ci', 'utf8', 210, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('ucs2_general_ci', 'ucs2', 35, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('ucs2_bin', 'ucs2', 90, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('ucs2_unicode_ci', 'ucs2', 128, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('ucs2_icelandic_ci', 'ucs2', 129, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('ucs2_latvian_ci', 'ucs2', 130, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('ucs2_romanian_ci', 'ucs2', 131, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('ucs2_slovenian_ci', 'ucs2', 132, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('ucs2_polish_ci', 'ucs2', 133, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('ucs2_estonian_ci', 'ucs2', 134, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('ucs2_spanish_ci', 'ucs2', 135, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('ucs2_swedish_ci', 'ucs2', 136, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('ucs2_turkish_ci', 'ucs2', 137, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('ucs2_czech_ci', 'ucs2', 138, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('ucs2_danish_ci', 'ucs2', 139, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('ucs2_lithuanian_ci', 'ucs2', 140, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('ucs2_slovak_ci', 'ucs2', 141, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('ucs2_spanish2_ci', 'ucs2', 142, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('ucs2_roman_ci', 'ucs2', 143, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('ucs2_persian_ci', 'ucs2', 144, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('ucs2_esperanto_ci', 'ucs2', 145, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('ucs2_hungarian_ci', 'ucs2', 146, '', 'Yes', 8);
    INSERT INTO <code>COLLATIONS</code> VALUES ('cp866_general_ci', 'cp866', 36, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('cp866_bin', 'cp866', 68, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('keybcs2_general_ci', 'keybcs2', 37, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('keybcs2_bin', 'keybcs2', 73, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('macce_general_ci', 'macce', 38, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('macce_bin', 'macce', 43, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('macroman_general_ci', 'macroman', 39, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('macroman_bin', 'macroman', 53, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('cp852_general_ci', 'cp852', 40, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('cp852_bin', 'cp852', 81, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('latin7_estonian_cs', 'latin7', 20, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('latin7_general_ci', 'latin7', 41, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('latin7_general_cs', 'latin7', 42, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('latin7_bin', 'latin7', 79, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('cp1251_bulgarian_ci', 'cp1251', 14, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('cp1251_ukrainian_ci', 'cp1251', 23, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('cp1251_bin', 'cp1251', 50, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('cp1251_general_ci', 'cp1251', 51, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('cp1251_general_cs', 'cp1251', 52, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('cp1256_general_ci', 'cp1256', 57, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('cp1256_bin', 'cp1256', 67, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('cp1257_lithuanian_ci', 'cp1257', 29, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('cp1257_bin', 'cp1257', 58, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('cp1257_general_ci', 'cp1257', 59, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('binary', 'binary', 63, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('geostd8_general_ci', 'geostd8', 92, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('geostd8_bin', 'geostd8', 93, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('cp932_japanese_ci', 'cp932', 95, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('cp932_bin', 'cp932', 96, '', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('eucjpms_japanese_ci', 'eucjpms', 97, 'Yes', 'Yes', 1);
    INSERT INTO <code>COLLATIONS</code> VALUES ('eucjpms_bin', 'eucjpms', 98, '', 'Yes', 1);
    
    -- --------------------------------------------------------
    
    --
    -- Table structure for table <code>COLLATION_CHARACTER_SET_APPLICABILITY</code>
    -- 
    
    CREATE TEMPORARY TABLE <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> (
      <code>COLLATION_NAME</code> varchar(64) NOT NULL default '',
      <code>CHARACTER_SET_NAME</code> varchar(64) NOT NULL default ''
    ) ENGINE=MEMORY DEFAULT CHARSET=utf8;
    
    --
    -- Dumping data for table <code>COLLATION_CHARACTER_SET_APPLICABILITY</code>
    -- 
    
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('big5_chinese_ci', 'big5');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('big5_bin', 'big5');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('dec8_swedish_ci', 'dec8');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('dec8_bin', 'dec8');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('cp850_general_ci', 'cp850');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('cp850_bin', 'cp850');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('hp8_english_ci', 'hp8');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('hp8_bin', 'hp8');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('koi8r_general_ci', 'koi8r');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('koi8r_bin', 'koi8r');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('latin1_german1_ci', 'latin1');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('latin1_swedish_ci', 'latin1');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('latin1_danish_ci', 'latin1');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('latin1_german2_ci', 'latin1');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('latin1_bin', 'latin1');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('latin1_general_ci', 'latin1');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('latin1_general_cs', 'latin1');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('latin1_spanish_ci', 'latin1');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('latin2_czech_cs', 'latin2');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('latin2_general_ci', 'latin2');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('latin2_hungarian_ci', 'latin2');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('latin2_croatian_ci', 'latin2');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('latin2_bin', 'latin2');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('swe7_swedish_ci', 'swe7');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('swe7_bin', 'swe7');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('ascii_general_ci', 'ascii');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('ascii_bin', 'ascii');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('ujis_japanese_ci', 'ujis');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('ujis_bin', 'ujis');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('sjis_japanese_ci', 'sjis');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('sjis_bin', 'sjis');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('hebrew_general_ci', 'hebrew');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('hebrew_bin', 'hebrew');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('tis620_thai_ci', 'tis620');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('tis620_bin', 'tis620');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('euckr_korean_ci', 'euckr');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('euckr_bin', 'euckr');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('koi8u_general_ci', 'koi8u');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('koi8u_bin', 'koi8u');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('gb2312_chinese_ci', 'gb2312');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('gb2312_bin', 'gb2312');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('greek_general_ci', 'greek');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('greek_bin', 'greek');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('cp1250_general_ci', 'cp1250');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('cp1250_czech_cs', 'cp1250');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('cp1250_croatian_ci', 'cp1250');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('cp1250_bin', 'cp1250');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('gbk_chinese_ci', 'gbk');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('gbk_bin', 'gbk');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('latin5_turkish_ci', 'latin5');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('latin5_bin', 'latin5');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('armscii8_general_ci', 'armscii8');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('armscii8_bin', 'armscii8');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('utf8_general_ci', 'utf8');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('utf8_bin', 'utf8');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('utf8_unicode_ci', 'utf8');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('utf8_icelandic_ci', 'utf8');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('utf8_latvian_ci', 'utf8');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('utf8_romanian_ci', 'utf8');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('utf8_slovenian_ci', 'utf8');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('utf8_polish_ci', 'utf8');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('utf8_estonian_ci', 'utf8');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('utf8_spanish_ci', 'utf8');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('utf8_swedish_ci', 'utf8');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('utf8_turkish_ci', 'utf8');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('utf8_czech_ci', 'utf8');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('utf8_danish_ci', 'utf8');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('utf8_lithuanian_ci', 'utf8');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('utf8_slovak_ci', 'utf8');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('utf8_spanish2_ci', 'utf8');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('utf8_roman_ci', 'utf8');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('utf8_persian_ci', 'utf8');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('utf8_esperanto_ci', 'utf8');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('utf8_hungarian_ci', 'utf8');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('ucs2_general_ci', 'ucs2');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('ucs2_bin', 'ucs2');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('ucs2_unicode_ci', 'ucs2');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('ucs2_icelandic_ci', 'ucs2');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('ucs2_latvian_ci', 'ucs2');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('ucs2_romanian_ci', 'ucs2');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('ucs2_slovenian_ci', 'ucs2');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('ucs2_polish_ci', 'ucs2');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('ucs2_estonian_ci', 'ucs2');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('ucs2_spanish_ci', 'ucs2');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('ucs2_swedish_ci', 'ucs2');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('ucs2_turkish_ci', 'ucs2');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('ucs2_czech_ci', 'ucs2');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('ucs2_danish_ci', 'ucs2');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('ucs2_lithuanian_ci', 'ucs2');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('ucs2_slovak_ci', 'ucs2');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('ucs2_spanish2_ci', 'ucs2');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('ucs2_roman_ci', 'ucs2');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('ucs2_persian_ci', 'ucs2');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('ucs2_esperanto_ci', 'ucs2');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('ucs2_hungarian_ci', 'ucs2');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('cp866_general_ci', 'cp866');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('cp866_bin', 'cp866');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('keybcs2_general_ci', 'keybcs2');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('keybcs2_bin', 'keybcs2');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('macce_general_ci', 'macce');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('macce_bin', 'macce');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('macroman_general_ci', 'macroman');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('macroman_bin', 'macroman');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('cp852_general_ci', 'cp852');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('cp852_bin', 'cp852');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('latin7_estonian_cs', 'latin7');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('latin7_general_ci', 'latin7');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('latin7_general_cs', 'latin7');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('latin7_bin', 'latin7');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('cp1251_bulgarian_ci', 'cp1251');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('cp1251_ukrainian_ci', 'cp1251');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('cp1251_bin', 'cp1251');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('cp1251_general_ci', 'cp1251');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('cp1251_general_cs', 'cp1251');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('cp1256_general_ci', 'cp1256');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('cp1256_bin', 'cp1256');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('cp1257_lithuanian_ci', 'cp1257');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('cp1257_bin', 'cp1257');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('cp1257_general_ci', 'cp1257');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('binary', 'binary');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('geostd8_general_ci', 'geostd8');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('geostd8_bin', 'geostd8');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('cp932_japanese_ci', 'cp932');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('cp932_bin', 'cp932');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('eucjpms_japanese_ci', 'eucjpms');
    INSERT INTO <code>COLLATION_CHARACTER_SET_APPLICABILITY</code> VALUES ('eucjpms_bin', 'eucjpms');
    
    -- --------------------------------------------------------
    
    --
    -- Table structure for table <code>COLUMNS</code>
    -- 
    
    CREATE TEMPORARY TABLE <code>COLUMNS</code> (
      <code>TABLE_CATALOG</code> varchar(512) default NULL,
      <code>TABLE_SCHEMA</code> varchar(64) NOT NULL default '',
      <code>TABLE_NAME</code> varchar(64) NOT NULL default '',
      <code>COLUMN_NAME</code> varchar(64) NOT NULL default '',
      <code>ORDINAL_POSITION</code> bigint(21) NOT NULL default '0',
      <code>COLUMN_DEFAULT</code> longtext,
      <code>IS_NULLABLE</code> varchar(3) NOT NULL default '',
      <code>DATA_TYPE</code> varchar(64) NOT NULL default '',
      <code>CHARACTER_MAXIMUM_LENGTH</code> bigint(21) default NULL,
      <code>CHARACTER_OCTET_LENGTH</code> bigint(21) default NULL,
      <code>NUMERIC_PRECISION</code> bigint(21) default NULL,
      <code>NUMERIC_SCALE</code> bigint(21) default NULL,
      <code>CHARACTER_SET_NAME</code> varchar(64) default NULL,
      <code>COLLATION_NAME</code> varchar(64) default NULL,
      <code>COLUMN_TYPE</code> longtext NOT NULL,
      <code>COLUMN_KEY</code> varchar(3) NOT NULL default '',
      <code>EXTRA</code> varchar(20) NOT NULL default '',
      <code>PRIVILEGES</code> varchar(80) NOT NULL default '',
      <code>COLUMN_COMMENT</code> varchar(255) NOT NULL default ''
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
    
    --
    -- Dumping data for table <code>COLUMNS</code>
    -- 
    
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'CHARACTER_SETS', 'CHARACTER_SET_NAME', 1, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'CHARACTER_SETS', 'DEFAULT_COLLATE_NAME', 2, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'CHARACTER_SETS', 'DESCRIPTION', 3, '', 'NO', 'varchar', 60, 180, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(60)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'CHARACTER_SETS', 'MAXLEN', 4, '0', 'NO', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(3)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLLATIONS', 'COLLATION_NAME', 1, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLLATIONS', 'CHARACTER_SET_NAME', 2, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLLATIONS', 'ID', 3, '0', 'NO', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(11)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLLATIONS', 'IS_DEFAULT', 4, '', 'NO', 'varchar', 3, 9, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(3)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLLATIONS', 'IS_COMPILED', 5, '', 'NO', 'varchar', 3, 9, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(3)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLLATIONS', 'SORTLEN', 6, '0', 'NO', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(3)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLLATION_CHARACTER_SET_APPLICABILITY', 'COLLATION_NAME', 1, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLLATION_CHARACTER_SET_APPLICABILITY', 'CHARACTER_SET_NAME', 2, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLUMNS', 'TABLE_CATALOG', 1, NULL, 'YES', 'varchar', 512, 1536, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(512)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLUMNS', 'TABLE_SCHEMA', 2, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLUMNS', 'TABLE_NAME', 3, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLUMNS', 'COLUMN_NAME', 4, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLUMNS', 'ORDINAL_POSITION', 5, '0', 'NO', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(21)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLUMNS', 'COLUMN_DEFAULT', 6, NULL, 'YES', 'longtext', 4294967295, 4294967295, NULL, NULL, 'utf8', 'utf8_general_ci', 'longtext', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLUMNS', 'IS_NULLABLE', 7, '', 'NO', 'varchar', 3, 9, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(3)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLUMNS', 'DATA_TYPE', 8, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLUMNS', 'CHARACTER_MAXIMUM_LENGTH', 9, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(21)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLUMNS', 'CHARACTER_OCTET_LENGTH', 10, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(21)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLUMNS', 'NUMERIC_PRECISION', 11, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(21)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLUMNS', 'NUMERIC_SCALE', 12, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(21)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLUMNS', 'CHARACTER_SET_NAME', 13, NULL, 'YES', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLUMNS', 'COLLATION_NAME', 14, NULL, 'YES', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLUMNS', 'COLUMN_TYPE', 15, '', 'NO', 'longtext', 4294967295, 4294967295, NULL, NULL, 'utf8', 'utf8_general_ci', 'longtext', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLUMNS', 'COLUMN_KEY', 16, '', 'NO', 'varchar', 3, 9, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(3)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLUMNS', 'EXTRA', 17, '', 'NO', 'varchar', 20, 60, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(20)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLUMNS', 'PRIVILEGES', 18, '', 'NO', 'varchar', 80, 240, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(80)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLUMNS', 'COLUMN_COMMENT', 19, '', 'NO', 'varchar', 255, 765, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(255)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLUMN_PRIVILEGES', 'GRANTEE', 1, '', 'NO', 'varchar', 81, 243, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(81)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLUMN_PRIVILEGES', 'TABLE_CATALOG', 2, NULL, 'YES', 'varchar', 512, 1536, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(512)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLUMN_PRIVILEGES', 'TABLE_SCHEMA', 3, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLUMN_PRIVILEGES', 'TABLE_NAME', 4, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLUMN_PRIVILEGES', 'COLUMN_NAME', 5, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLUMN_PRIVILEGES', 'PRIVILEGE_TYPE', 6, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'COLUMN_PRIVILEGES', 'IS_GRANTABLE', 7, '', 'NO', 'varchar', 3, 9, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(3)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'KEY_COLUMN_USAGE', 'CONSTRAINT_CATALOG', 1, NULL, 'YES', 'varchar', 512, 1536, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(512)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'KEY_COLUMN_USAGE', 'CONSTRAINT_SCHEMA', 2, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'KEY_COLUMN_USAGE', 'CONSTRAINT_NAME', 3, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'KEY_COLUMN_USAGE', 'TABLE_CATALOG', 4, NULL, 'YES', 'varchar', 512, 1536, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(512)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'KEY_COLUMN_USAGE', 'TABLE_SCHEMA', 5, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'KEY_COLUMN_USAGE', 'TABLE_NAME', 6, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'KEY_COLUMN_USAGE', 'COLUMN_NAME', 7, '', 'NO', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'KEY_COLUMN_USAGE', 'ORDINAL_POSITION', 8, '0', 'NO', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(10)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'KEY_COLUMN_USAGE', 'POSITION_IN_UNIQUE_CONSTRAINT', 9, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(10)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'KEY_COLUMN_USAGE', 'REFERENCED_TABLE_SCHEMA', 10, NULL, 'YES', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'KEY_COLUMN_USAGE', 'REFERENCED_TABLE_NAME', 11, NULL, 'YES', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'KEY_COLUMN_USAGE', 'REFERENCED_COLUMN_NAME', 12, NULL, 'YES', 'varchar', 64, 192, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(64)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'PROFILING', 'QUERY_ID', 1, '0', 'NO', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(20)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'PROFILING', 'SEQ', 2, '0', 'NO', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(20)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'PROFILING', 'STATE', 3, '', 'NO', 'varchar', 30, 90, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(30)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'PROFILING', 'DURATION', 4, '', 'NO', 'varchar', 9, 27, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(9)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'PROFILING', 'CPU_USER', 5, NULL, 'YES', 'varchar', 9, 27, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(9)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'PROFILING', 'CPU_SYSTEM', 6, NULL, 'YES', 'varchar', 9, 27, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(9)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'PROFILING', 'CONTEXT_VOLUNTARY', 7, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(20)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'PROFILING', 'CONTEXT_INVOLUNTARY', 8, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(20)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'PROFILING', 'BLOCK_OPS_IN', 9, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(20)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'PROFILING', 'BLOCK_OPS_OUT', 10, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(20)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'PROFILING', 'MESSAGES_SENT', 11, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(20)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'PROFILING', 'MESSAGES_RECEIVED', 12, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(20)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'PROFILING', 'PAGE_FAULTS_MAJOR', 13, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(20)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code> VALUES (NULL, 'information_schema', 'PROFILING', 'PAGE_FAULTS_MINOR', 14, NULL, 'YES', 'bigint', NULL, NULL, 19, 0, NULL, NULL, 'bigint(20)', '', '', 'select', '');
    INSERT INTO <code>COLUMNS</code&g
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Trying to move WP to a new server’ is closed to new replies.