WordPress.org

Ready to get started?Download WordPress

Forums

Problem moving wordpress to new server (13 posts)

  1. phillip29
    Member
    Posted 1 year 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!

  2. esmi
    Forum Moderator
    Posted 1 year 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.

  3. phillip29
    Member
    Posted 1 year ago #

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

  4. phillip29
    Member
    Posted 1 year 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

  5. esmi
    Forum Moderator
    Posted 1 year ago #

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

  6. phillip29
    Member
    Posted 1 year 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

  7. esmi
    Forum Moderator
    Posted 1 year 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;
  8. phillip29
    Member
    Posted 1 year 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.

  9. esmi
    Forum Moderator
    Posted 1 year ago #

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

  10. phillip29
    Member
    Posted 1 year ago #

    oh ok - I am getting any where?

  11. esmi
    Forum Moderator
    Posted 1 year ago #

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

  12. phillip29
    Member
    Posted 1 year 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"

  13. esmi
    Forum Moderator
    Posted 1 year ago #

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

Topic Closed

This topic has been closed to new replies.

About this Topic