Posted 2 years ago #
HI,
I have transferred a site to a new domain and host - all seems to have moved over - I can see the folders are there via FTP and WP is set-up and configured correctly. HOWEVER I cannot see any of the posts? Any ideas.
Maybe the posts aren't connected somehow....?
New site is; http://www.aleptiscoaching.co.uk
Really appreciate some HELP on this asap as this site should be live now.
Bx
You skipped the part where you move the database data over as well.
Have a look at Moving_WordPress for a step-by-step approach to moving both files and data.
Posted 2 years ago #
Thanks v much for your response.
I did export and import the databse earlier agin to double check - not sure if entirely successful as a commentmeta error...?
I did follow that guide you're referring to, under moving to a new server!
Help still lost and stuck. Thanks in advance.
B.x
Posted 2 years ago #
This is the error I am getting;
SQL query:
--
-- Database: aleptiscouk_***
--
-- --------------------------------------------------------
--
-- Table structure for table wp_commentmeta
--
CREATE TABLE IF NOT EXISTS wp_commentmeta (
meta_id bigint( 20 ) unsigned NOT NULL AUTO_INCREMENT ,
comment_id bigint( 20 ) unsigned NOT NULL default '0',
meta_key varchar( 255 ) default NULL ,
meta_value longtext,
PRIMARY KEY ( meta_id ) ,
KEY comment_id ( comment_id ) ,
KEY meta_key ( meta_key )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =3;
MySQL said: Documentation
#1046 - No database selected
Posted 2 years ago #
you've connected the WP install to the new DB in wp-config.php? With the new credentials, db name, etc?
Posted 2 years ago #
Hi,
FIXED This - It seems I couldn't import a database INTO another database - I deleted the one I had set-up and imported the old one again and it bought across the posts.
I wrongly assumed the SQL files would merge...
The Backupwordpress plugin went belly up too - so simply deleted that and going to start again.
Thanks for your help guys.
B. x
This topic has been closed to new replies.
