Site Migration – Many and varied problems

  • Resolved Quarryscapes

    (@quarryscapes)


    9 years, 2 months ago

    Not sure how something so theoretically straightforward can be so frustrating, but here goes!

    I am not happy with my current host for one of my sites (coastlinemodels.co.uk), so to test if I want to set it up with a different host I use for a different site I have created a sub domain on a site I already run with that host. clm.ty-paulcottage.co.uk, with the files in directory ty-paulcottage.co.uk/clm.

    On the existing coastline site I used the the Migrate DB plugin to change the databse links and export it. I imported it to a new database over at clm.ty-paul.

    I used C Panel over on coastline to export all my files as a zip, which I then uploaded to clm.ty-paul and unzipped into the proper directory structure, I edited wp-config with the new database details and that should be it right?

    Well apparently not!

    I get this from phpmyadmin trying to import the databse:

    SQL query:

#
# Table structure of table <code>wp_relevanssi_stopwords</code>
#
CREATE TABLE  <code>wp_relevanssi_stopwords</code> (

 <code>stopword</code> VARCHAR( 50 ) CHARACTER SET utf8mb4 COLLATE utf8_bin NOT NULL ,
UNIQUE KEY  <code>stopword</code> (  <code>stopword</code> )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci;

MySQL said: Documentation

#1253 - COLLATION 'utf8_bin' is not valid for CHARACTER SET 'utf8mb4'

    , though it tests fine in mySQL databses under Cpanel, and I get 

    Warning: require_once(/home/typaulco/public_html/clm/wp-content/plugins/akismet/class.akismet-widget.php): failed to open stream: No such file or directory in /home/typaulco/public_html/clm/wp-content/plugins/akismet/akismet.php on line 50

Fatal error: require_once(): Failed opening required '/home/typaulco/public_html/clm/wp-content/plugins/akismet/class.akismet-widget.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/typaulco/public_html/clm/wp-content/plugins/akismet/akismet.php on line 50

    when trying to access the site. Seems the backup of the old site missed out shed loads of files, but I don’t know why, it was supposed to be a full site backup.

    Can anyone suggest some plugins or scripts that can take the sting out of this – something that can change the links in the database that works and something that can actually do a proper file backup?

Viewing 1 replies (of 1 total)
  • Thread Starter Quarryscapes

    (@quarryscapes)

    Right, all up and running now, did a plain old fashioned export from phpmyadmin on old site and imported to new, adjusted the site url and home url in the new database after import which took care of that part.

    The missing files – I went back to the whole site backup zip and noticed for some reason the directory structure was all screwed up – all the files which are in home/coastlin/public_html on the server were saved there and also as home/ in the archive. Extracted to local disk and rearranged where they all belong, re zipped and uploaded to new server and unzipped and all works perfectly.

Viewing 1 replies (of 1 total)
  • The topic ‘Site Migration – Many and varied problems’ is closed to new replies.