Loading...
 
Architecture / Installation

Architecture / Installation


Re: Moving entire tiki installation to new server

posts: 2881 United Kingdom

Quite easy :-)

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

On the new run
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 :-)

posts: 2 Spain

> Quite easy :-)
>

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

>

> On the new run
> 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


posts: 55 United States

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.

posts: 3588 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.

Upcoming Events

No records to display

Why Register?

Register at tiki.org and you'll be able to use the account at any *.tiki.org site, thanks to the InterTiki feature. A valid email address is required to receive site notifications and occasional newsletters. You can opt out of these items at any time.