Support » Installing WordPress » New to WordPress – trouble moving Database to New Server

  • I’m trying to move a SQL database from one server to a new one on NetworkSolutions. I moved all the files via FTP but the database gives me error messages each time.

    I dumped the database from the old server as localhost.sql and tried to import it into my new host and get this error message:

    ———————————–

    SQL query:


    — Database: information_schema

    CREATE DATABASE information_schema DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

    MySQL said:

    #1044 – Access denied for user ‘1_0332c83_0’@’localhost’ to database ‘information_schema’

    ———————————–

    What am I don’t wrong?

    HERE IS MY CODE:

    ———————————–

    — phpMyAdmin SQL Dump
    — version 3.3.9
    http://www.phpmyadmin.net

    — Host: localhost
    — Generation Time: Mar 02, 2011 at 11:34 AM
    — Server version: 5.0.91
    — PHP Version: 5.2.6

    SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;

    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    /*!40101 SET NAMES utf8 */;


    — Database: information_schema

    CREATE DATABASE information_schema DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    USE information_schema;

    — ——————————————————–


    — Table structure for table CHARACTER_SETS

    CREATE TEMPORARY TABLE CHARACTER_SETS (
    CHARACTER_SET_NAME varchar(64) NOT NULL default ”,
    DEFAULT_COLLATE_NAME varchar(64) NOT NULL default ”,
    DESCRIPTION varchar(60) NOT NULL default ”,
    MAXLEN bigint(3) NOT NULL default ‘0’
    ) ENGINE=MEMORY DEFAULT CHARSET=utf8;


    — Dumping data for table CHARACTER_SETS

    INSERT INTO CHARACTER_SETS (CHARACTER_SET_NAME, DEFAULT_COLLATE_NAME, DESCRIPTION, MAXLEN) VALUES
    (‘big5’, ‘big5_chinese_ci’, ‘Big5 Traditional Chinese’, 2),
    (‘dec8’, ‘dec8_swedish_ci’, ‘DEC West European’, 1),
    (‘cp850’, ‘cp850_general_ci’, ‘DOS West European’, 1),
    (‘hp8’, ‘hp8_english_ci’, ‘HP West European’, 1),
    (‘koi8r’, ‘koi8r_general_ci’, ‘KOI8-R Relcom Russian’, 1),
    (‘latin1’, ‘latin1_swedish_ci’, ‘cp1252 West European’, 1),
    (‘latin2’, ‘latin2_general_ci’, ‘ISO 8859-2 Central European’, 1),
    (‘swe7’, ‘swe7_swedish_ci’, ‘7bit Swedish’, 1),
    (‘ascii’, ‘ascii_general_ci’, ‘US ASCII’, 1),
    (‘ujis’, ‘ujis_japanese_ci’, ‘EUC-JP Japanese’, 3),
    (‘sjis’, ‘sjis_japanese_ci’, ‘Shift-JIS Japanese’, 2),
    (‘hebrew’, ‘hebrew_general_ci’, ‘ISO 8859-8 Hebrew’, 1),
    (’tis620′, ’tis620_thai_ci’, ‘TIS620 Thai’, 1),
    (‘euckr’, ‘euckr_korean_ci’, ‘EUC-KR Korean’, 2),
    (‘koi8u’, ‘koi8u_general_ci’, ‘KOI8-U Ukrainian’, 1),
    (‘gb2312’, ‘gb2312_chinese_ci’, ‘GB2312 Simplified Chinese’, 2),
    (‘greek’, ‘greek_general_ci’, ‘ISO 8859-7 Greek’, 1),
    (‘cp1250’, ‘cp1250_general_ci’, ‘Windows Central European’, 1),
    (‘gbk’, ‘gbk_chinese_ci’, ‘GBK Simplified Chinese’, 2),
    (‘latin5’, ‘latin5_turkish_ci’, ‘ISO 8859-9 Turkish’, 1),
    (‘armscii8’, ‘armscii8_general_ci’, ‘ARMSCII-8 Armenian’, 1),
    (‘utf8’, ‘utf8_general_ci’, ‘UTF-8 Unicode’, 3),
    (‘ucs2’, ‘ucs2_general_ci’, ‘UCS-2 Unicode’, 2),
    (‘cp866’, ‘cp866_general_ci’, ‘DOS Russian’, 1),
    (‘keybcs2’, ‘keybcs2_general_ci’, ‘DOS Kamenicky Czech-Slovak’, 1),
    (‘macce’, ‘macce_general_ci’, ‘Mac Central European’, 1),
    (‘macroman’, ‘macroman_general_ci’, ‘Mac West European’, 1),
    (‘cp852’, ‘cp852_general_ci’, ‘DOS Central European’, 1),
    (‘latin7’, ‘latin7_general_ci’, ‘ISO 8859-13 Baltic’, 1),
    (‘cp1251’, ‘cp1251_general_ci’, ‘Windows Cyrillic’, 1),
    (‘cp1256’, ‘cp1256_general_ci’, ‘Windows Arabic’, 1),
    (‘cp1257’, ‘cp1257_general_ci’, ‘Windows Baltic’, 1),
    (‘binary’, ‘binary’, ‘Binary pseudo charset’, 1),
    (‘geostd8’, ‘geostd8_general_ci’, ‘GEOSTD8 Georgian’, 1),
    (‘cp932’, ‘cp932_japanese_ci’, ‘SJIS for Windows Japanese’, 2),
    (‘eucjpms’, ‘eucjpms_japanese_ci’, ‘UJIS for Windows Japanese’, 3);

    — ——————————————————–

Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘New to WordPress – trouble moving Database to New Server’ is closed to new replies.