Title: Import
Last modified: August 19, 2016

---

# Import

 *  [monikamagdalena](https://wordpress.org/support/users/monikamagdalena/)
 * (@monikamagdalena)
 * [16 years, 11 months ago](https://wordpress.org/support/topic/import-1/)
 * Hi,
    I recently changed the web-hosting on my website and while trying to import
   my old WordPress information onto the new server I have had issues. When I import
   my xml file from the previous export, it leads me to import/create a new author.
   I have tried using an author from the previous file as well as an admin user.
   After completing this step, none of the old data is imported or displayed on 
   the homepage. Any advice would be helpful, thanks!

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Thread Starter [monikamagdalena](https://wordpress.org/support/users/monikamagdalena/)
 * (@monikamagdalena)
 * [16 years, 11 months ago](https://wordpress.org/support/topic/import-1/#post-1117204)
 * Or additionally, if I were to upload my xml backup file with an FTP client, what
   would the file location be?
    Thanks again.
 *  [orbitingsolutions](https://wordpress.org/support/users/orbitingsolutions/)
 * (@orbitingsolutions)
 * [16 years, 11 months ago](https://wordpress.org/support/topic/import-1/#post-1117221)
 * Are you getting any data from the import steps you have taken? Another option
   may be to just go to the mysql database itself and export your database and then
   import. I am using cpanel and able to get to this area through the php myadmin
   section. Let me know if you would like some additional assistance with this.
 *  Thread Starter [monikamagdalena](https://wordpress.org/support/users/monikamagdalena/)
 * (@monikamagdalena)
 * [16 years, 11 months ago](https://wordpress.org/support/topic/import-1/#post-1117391)
 * 1. Exported database from old server as a .sql file
    2. Set up WordPress on new
   host 3. Went to manage the new database on new host and import the .sql backup
   file 4. When attempting to upload, got this error. Error SQL query: — — Database:`
   blaglash_sswp01` — — ——————————————————– — — Table structure for table `wp_comments`—
   CREATE TABLE IF NOT EXISTS `wp_comments` ( `comment_ID` bigint(20) unsigned NOT
   NULL auto_increment, `comment_post_ID` int(11) NOT NULL default ‘0’, `comment_author`
   tinytext NOT NULL, `comment_author_email` varchar(100) NOT NULL default ”, `comment_author_url`
   varchar(200) NOT NULL default ”, `comment_author_IP` varchar(100) NOT NULL default”,`
   comment_date` datetime NOT NULL default ‘0000-00-00 00:00:00’, `comment_date_gmt`
   datetime NOT NULL default ‘0000-00-00 00:00:00’, `comment_content` text NOT NULL,`
   comment_karma` int(11) NOT NULL default ‘0’, `comment_approved` varchar(20) NOT
   NULL default ‘1’, `comment_agent` varchar(255) NOT NULL default ”, `comment_type`
   varchar(20) NOT NULL default ”, `comment_parent` bigint(20) NOT NULL default ‘
   0’, `user_id` bigint(20) NOT NULL default ‘0’, PRIMARY KEY[…] MySQL said: #1046–
   No database selected 5. Any ideas or suggestions? Thank you in advance!
 *  [Lucian Florian](https://wordpress.org/support/users/fldtrace/)
 * (@fldtrace)
 * [16 years, 11 months ago](https://wordpress.org/support/topic/import-1/#post-1117400)
 * First, make sure you have the same username and password to the new hosting provider
   with full rights for the database. Database needs the same name like old one 
   to save some configuration setting headache.
 * If you still have problems, open the exported database and search at beginning
   for a line Create Database or something similar. You need to get rid of that.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Import’ is closed to new replies.

 * In: [Everything else WordPress](https://wordpress.org/support/forum/miscellaneous/)
 * 4 replies
 * 3 participants
 * Last reply from: [Lucian Florian](https://wordpress.org/support/users/fldtrace/)
 * Last activity: [16 years, 11 months ago](https://wordpress.org/support/topic/import-1/#post-1117400)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics