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!
