Loading...
 
Skip to main content

Architecture / Installation

Forum List Topic List

Forums » Architecture / Installation » create a copy of running tiki (how to copy database?)
 
Thread actions
Print this page
  • Print all pages

    • create a copy of running tiki (how to copy database?)

    Posted by eSeL posts: 40 Austria

    i am trying to create an identical copy of my running tiki (1.9.7)

    both copies should start with the same content, layout, users and settings...
    and then "split up", i.e. each installation needs to have its own database.

    maybe there is a better way to get a duplicate running?

    -


    here´s how i planned to do it and where i am stuck:

    1. php files on server


    I copied all the files and directories of my runing tiki to a new directory on the server.
    no problem. done.

    2. duplicate database


    i just cannot copy the database with myphpadmin
    myphpadmin does not allow "copying" a db

    so in order to get an identical copy of the tiki-db running I thought i would need to:
    1. export existing db
    2. create a new db
    3. import old db in new db

    as my tiki-db export-file is 51mb i get timeout during upload (even as zip it is too big)
    any ideas how to achieve that?

    so i am stuck here.
    if i managed i would only need to..

    3. configure copied tiki for database


    i think i would just have to change the info
    in /db/local.php

    or is there a way to change the db-name on a RUNNING tiki?
    via the tiki-install.php maybe?


    thanks for any help
    e.










    Reads: 1011
    Posted by Marc Laporte posts: 1644 Canada


    1- Agreed.

    2- Bigdump is your friend:
    http://www.ozerov.de/bigdump.php

    3- Yes, you can edit db/local.php with a text editor.

    Keep us informed on your progress 😊

    M 😉


    Posted by eSeL posts: 40 Austria

    dear marc,

    thanks for the advice.

    i have to admit that i just created a new tiki from scratch -
    and imported all i needed.

    very sorry, the whole sql-db business sounded just above my head.
    (but now i finally know what i would need to learn bigdump if ever had to rely on my tiki-backups... >;e)

    i am currently rebuilding everything - quite enjoyable, i have to admit,
    except: if i only knew how i ever got rid of the bottom line saying "Created by / last changed" in my original tiki...

    sigh.. >;e)