• Resolved theplastickid

    (@theplastickid)


    I am having issues moving a site over to my clients Media Temple server.

    I am following this tutorial, which is very basic. Just runs through the usual steps, creating a package etc.

    I am establishing a secure connection but when I run the deployment I get:
    Errors: Deploy (2773) Update (4) Warnings: (0)

    The site is very large at over 600mb I don’t know if that has something to do with it.

    I have used this plugin with no problems in the past, could someone point me in the right direction or offer an alternative method to move this site from a localhost to a live server.

    Thanks.

    https://wordpress.org/plugins/duplicator/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Hey Plastickid,

    Can you past just a few of the Deploy errors your seeing (please don’t try to post the entire log). If you are moving an older WP site (pre 4.2) to a newer server you may have MySQL/Database conversion issues, see this thread.

    Thanks~

    Thread Starter theplastickid

    (@theplastickid)

    Hi Cory thanks for the reply. The WordPress verison I am moving is up to date.

    Here are some errors. I suspect it could be related to Media Temple as I have just got 220 errors trying to move another site to the Media Temple platform (different account)

    --------------------------------------
    DATABASE RESULTS
    --------------------------------------
    **ERROR** database error write 'MySQL server has gone away' - [sql=/* DUPLICATOR MYSQL SCRIPT CREATED ON : 2015-07-20 20:23:46 */
    
    SET FOREIGN...]
    **ERROR** database error write 'Unknown character set: 'utf8mb4'' - [sql=
    CREATE TABLE <code>wp_bp_activity</code> (
      <code>id</code> bigint(20) NOT NULL AUTO_INCREMENT,...]
    **ERROR** database error write 'Unknown character set: 'utf8mb4'' - [sql=
    CREATE TABLE <code>wp_bp_activity_meta</code> (
      <code>id</code> bigint(20) NOT NULL AUTO_INCRE...]
    <code>INSERT INTO</code>wp_revslider_css
     V...]
    **ERROR** database error write 'Table 'db156243_2015new.wp_revslider_css' doesn't exist' - [sql=INSERT INTO <code>wp_revslider_css</code> VALUES("2", ".tp-caption.small_text", NULL, ...]
    **ERROR** database error write 'Table 'db156243_2015new.wp_revslider_css' doesn't exist' - [sql=INSERT INTO <code>wp_revslider_css</code> VALUES("3", ".tp-caption.medium_text", NULL,...]
    **ERROR** database error write 'Table 'db156243_2015new.wp_revslider_css' doesn't exist' - [sql=INSERT INTO <code>wp_revslider_css</code> VALUES("4", ".tp-caption.large_text", NULL, ...]
    /* INSERT TABLE DATA: wp_woocommerce_order_items */
    INSERT INTO
    wp_woocom...]
    **ERROR** database error write 'Table 'db156243_2015new.wp_woocommerce_order_items' doesn't exist' - [sql=INSERT INTO <code>wp_woocommerce_order_items</code> VALUES("12", "Free Shipping", "shi...]
    **ERROR** database error write 'Table 'db156243_2015new.wp_woocommerce_termmeta' doesn't exist' - [sql=
    /* INSERT TABLE DATA: wp_woocommerce_termmeta */
    INSERT INTO
    
    wp_woocommer...]
    **ERROR** database error write 'Table 'db156243_2015new.wp_woocommerce_termmeta' doesn't exist' - [sql=INSERT INTO <code>wp_woocommerce_termmeta</code> VALUES("4", "9", "thumbnail_id", "103...]
    **ERROR** database error write 'Table 'db156243_2015new.wp_woocommerce_termmeta' doesn't exist' - [sql=INSERT INTO <code>wp_woocommerce_termmeta</code> VALUES("5", "5", "product_count_produ...]

    This looks like the Database your trying to install on doesn’t support ‘utf8mb4’. This is usually because the MySQL version is not 5.5.3 or higher. I would contact your host/server admin to see if they can update the mysql version to support this characterset.

    There are a few work-a-rounds here that you can try as well.

    Hope that helps!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Failure moving a site to Media Temple’ is closed to new replies.