Loading...
 
Skip to main content

Architecture / Installation

Forum List Topic List

 
Thread actions
Print this page
  • Print all pages

    • Re: Moving entire tiki installation to new server

    Posted by Damian Parker posts: 2881 United Kingdom

    Quite easy 😊

    On the existing installation perform a
    Copy to clipboard
    mysqldump -u tikiuser -p tiki-db > dump.sql
    or use similar in phpmyadmin.

    On the new run
    Copy to clipboard
    mysql -u tikiuser -p tiki-db < dump.sql
    or similar in phpMyaadmin


    Now, you will need to copy over any file, image, and forum directories that are setup, also copy over img/wiki_up , games?, custom themes in styles/ and templates/styles/ to the new installation.

    That should be it then 😊

    Reads: 10405
    Posted by eva posts: 2 Spain

    > Quite easy 😊
    >

    > On the existing installation perform a
    Copy to clipboard
    > mysqldump -u tikiuser -p tiki-db > dump.sql
    or use similar in phpmyadmin.

    >

    > On the new run
    Copy to clipboard
    > mysql -u tikiuser -p tiki-db < dump.sql
    or similar in phpMyaadmin

    >
    > Now, you will need to copy over any file, image, and forum directories that are setup, also copy over img/wiki_up , games?, custom themes in styles/ and templates/styles/ to the new installation.
    >
    > That should be it then 😊
    >

    The problem now is when you want to move of a server with mysql version more old than the new server mysql. When you do mysql -u tikiuser -p tiki-db < dump.sql, appear erros about syntax.

    Then? Some idea?

    EVA


    Posted by littledove posts: 55

    Thank you for your concise description, but you left out how/where to do this. In phpmyadmin (the only place I can access sql), I get this error:

    "#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqldump -u tikiuser -p tiki-db > dump.sql' at line 1"

    Please offer a phpmyadmin version of this action.

    Posted by Rick Sapir / Tiki for Smarties posts: 3665 United States

    The process is quite easy:

    On the old site:

    1. Back up your existing Tiki database. The exact process will vary, but you might find my primer helpful.
    2. Back up any customizations you've made, images you've uploaded, etc. Again, my primer might be helpful.


    On the new site:

    1. Restore your database.
    2. Restore your customizations.
    3. Complete the Tiki installer, selecting the UPGRADE option.



    You should also consider reviewing the "Move Tiki to a New Server" section in the docs

    HTH,

    - Rick | My Tiki Blog | My Tiki UserPage

    Why be a dummy? Get smarty! TikiForSmarties.com
    Tiki for Smarties, your source for the best (and only) Tiki books, guides, and tutorials.