Title: Problem moving wordpress to new server Last modified: August 20, 2016 --- # Problem moving wordpress to new server * [phillip29](https://wordpress.org/support/users/phillip29/) * (@phillip29) * [13 years, 8 months ago](https://wordpress.org/support/topic/problem-moving-wordpress-to-new-server/) * 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](https://wordpress.org/support/users/esmi/) * (@esmi) * [13 years, 8 months ago](https://wordpress.org/support/topic/problem-moving-wordpress-to-new-server/#post-3121244) * 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](https://wordpress.org/support/users/phillip29/) * (@phillip29) * [13 years, 8 months ago](https://wordpress.org/support/topic/problem-moving-wordpress-to-new-server/#post-3121248) * Thanks esmi – I will do that now and try and import * Thread Starter [phillip29](https://wordpress.org/support/users/phillip29/) * (@phillip29) * [13 years, 8 months ago](https://wordpress.org/support/topic/problem-moving-wordpress-to-new-server/#post-3121251) * 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](https://wordpress.org/support/users/esmi/) * (@esmi) * [13 years, 8 months ago](https://wordpress.org/support/topic/problem-moving-wordpress-to-new-server/#post-3121259) * Again, that table has nothing to do with WordPress. Remove all references to it. * Thread Starter [phillip29](https://wordpress.org/support/users/phillip29/) * (@phillip29) * [13 years, 8 months ago](https://wordpress.org/support/topic/problem-moving-wordpress-to-new-server/#post-3121270) * 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](https://wordpress.org/support/users/esmi/) * (@esmi) * [13 years, 8 months ago](https://wordpress.org/support/topic/problem-moving-wordpress-to-new-server/#post-3121273) * 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](https://wordpress.org/support/users/phillip29/) * (@phillip29) * [13 years, 8 months ago](https://wordpress.org/support/topic/problem-moving-wordpress-to-new-server/#post-3121276) * 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](https://wordpress.org/support/users/esmi/) * (@esmi) * [13 years, 8 months ago](https://wordpress.org/support/topic/problem-moving-wordpress-to-new-server/#post-3121281) * 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](https://wordpress.org/support/users/phillip29/) * (@phillip29) * [13 years, 8 months ago](https://wordpress.org/support/topic/problem-moving-wordpress-to-new-server/#post-3121285) * oh ok – I am getting any where? * [esmi](https://wordpress.org/support/users/esmi/) * (@esmi) * [13 years, 8 months ago](https://wordpress.org/support/topic/problem-moving-wordpress-to-new-server/#post-3121286) * What was the table prefix used in your old site (the default is `wp_`)? * Thread Starter [phillip29](https://wordpress.org/support/users/phillip29/) * (@phillip29) * [13 years, 8 months ago](https://wordpress.org/support/topic/problem-moving-wordpress-to-new-server/#post-3121292) * 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](https://wordpress.org/support/users/esmi/) * (@esmi) * [13 years, 8 months ago](https://wordpress.org/support/topic/problem-moving-wordpress-to-new-server/#post-3121311) * 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. ## Tags * [move](https://wordpress.org/support/topic-tag/move/) * [MySQL](https://wordpress.org/support/topic-tag/mysql/) * [server](https://wordpress.org/support/topic-tag/server/) * [upload](https://wordpress.org/support/topic-tag/upload/) * In: [Installing WordPress](https://wordpress.org/support/forum/installation/) * 12 replies * 2 participants * Last reply from: [esmi](https://wordpress.org/support/users/esmi/) * Last activity: [13 years, 8 months ago](https://wordpress.org/support/topic/problem-moving-wordpress-to-new-server/#post-3121311) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics