Import

  • 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

    (@monikamagdalena)

    Or additionally, if I were to upload my xml backup file with an FTP client, what would the file location be?
    Thanks again.

    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

    (@monikamagdalena)

    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!

    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.