Problem moving wordpress to new server

  • phillip29

    (@phillip29)


    11 years, 6 months ago

    Woe is me! I created a lovely site and then blew it all moving to a new server. I did an FTP back up of all files and dumped the database using phpmyadmin on my desktop. Can I get it back on the new server? No

    I am stuck getting the database back up and running. I am using godaddy and created a new datase using the hosting tools. I am then going back into phpmyadmin and using import. The problem is, I think, that I dumped both the “information schema” and the database into .sql file so I when I import I get the error message

    Error
    SQL query:

    —
    — Database: information_schema
    —
    CREATE DATABASE information_schema DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

    MySQL said:

    #1044 – Access denied for user ‘red1228904594900’@’%’ to database ‘information_schema’

    I think I need to go back to first principles with mysql – HELP!

Viewing 12 replies - 1 through 12 (of 12 total)
  • esmi

    (@esmi)

    11 years, 6 months ago

    There’s something wrong with your backup file. The information_schema database is part of your MySQL setup and has nothing to do with WordPress. You need to remove all references to it from (a copy of) your backup file.

    Thread Starter phillip29

    (@phillip29)

    11 years, 6 months ago

    Thanks esmi – I will do that now and try and import

    Thread Starter phillip29

    (@phillip29)

    11 years, 6 months ago

    Well I remove all the schema data – now I get the following message

    Error
    SQL query:

    —————————————————— —
    —
    — Table structure for table INNODB_IO_PATTERN
    —
    CREATE TEMPORARY TABLE INNODB_IO_PATTERN (

    SPACE BIGINT( 11 ) NOT NULL DEFAULT ‘0’,
    OFFSET BIGINT( 11 ) NOT NULL DEFAULT ‘0’,
    INDEX_ID BIGINT( 11 ) NOT NULL DEFAULT ‘0’,
    TABLE_NAME VARCHAR( 32 ) NOT NULL DEFAULT ”,
    INDEX_NAME VARCHAR( 32 ) NOT NULL DEFAULT ”,
    N_READ BIGINT( 11 ) NOT NULL DEFAULT ‘0’,
    N_WRITE BIGINT( 11 ) NOT NULL DEFAULT ‘0’
    ) ENGINE = MEMORY DEFAULT CHARSET = utf8;

    MySQL said:

    #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 ‘——————————————————–

    —
    — Table structure ‘ at line 1

    which looks a bit nasty

    esmi

    (@esmi)

    11 years, 6 months ago

    Again, that table has nothing to do with WordPress. Remove all references to it.

    Thread Starter phillip29

    (@phillip29)

    11 years, 6 months ago

    Thanks Esmi I did that – now I get the following

    Error
    SQL query:

    DATABASE : red1225804151029 —
    CREATE DATABASE red1225804151029 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

    MySQL said:

    #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 ‘Database: red1225804151029
    CREATE DATABASE red1225804151029 DEFAULT CHARACTE’ at line 1

    red1225804151029 being the name of the database I originally backed up. This is NOT the name of the database I am trying to upload to

    esmi

    (@esmi)

    11 years, 6 months ago

    Then you need to change all references from red1225804151029 to the new database name. And remove:

    DATABASE : red1225804151029 --
CREATE DATABASE red1225804151029 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    Thread Starter phillip29

    (@phillip29)

    11 years, 6 months ago

    Would it be possible for me to send you the original database dump to take a look at? it seems a bit weird that the extra stuff was in there.

    esmi

    (@esmi)

    11 years, 6 months ago

    I’m sorry but these forums do not offer support by email and I, personally, only offer email support to commercial clients.

    Thread Starter phillip29

    (@phillip29)

    11 years, 6 months ago

    oh ok – I am getting any where?

    esmi

    (@esmi)

    11 years, 6 months ago

    What was the table prefix used in your old site (the default is wp_)?

    Thread Starter phillip29

    (@phillip29)

    11 years, 6 months ago

    I think it is wp_ for instance further down the text file is the entry “– Table structure for table wp_ai1ec_event_category_colors”

    esmi

    (@esmi)

    11 years, 6 months ago

    Then remove all references to any tables that don’t use the wp_ prefix.

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘Problem moving wordpress to new server’ is closed to new replies.