Architecture / Installation

Posted by Rick Sapir / Tiki for Smarties 04 Oct 2006 15:27 GMT-0000 posts: 3665

You don't say what DB you're using, so I'll assume MySQL with PHPAdmin:

On the Win2K Box:

1. Using PHPAdmin, log into the existing database on the Win2K box
2. Click the EXPORT tab.
3. Select both the STRUCTURE and DATA options.
4. Select the SAVE AS FILE option and click GO. When prompted for a location and filename, save the resulting SQL file to your Win2K box.
5. Copy the file from the Win2K box to the Win2003Server.

On the Win2003Server:

1. Using PHPAdmin, create a new database (for simplicity, you might want to name it identically to the old DB on the Win2K box).
2. Using PHPAdmin log into the new database you just created.
3. Click the IMPORT tab.
4. In the File to Import area, click BROWSE and select the SQL file (that you copied from the Win2K box to the Win2003Server.
5. Click GO. You have now copied the database.
6. Open a webbrowser to http://localhost/tiki-install.php. Enter the new database information (database name, login, etc.) and click SUBMIT.
7. On the next installation screen, click DO NOTHING AND ENTER TIKI.

HTH,

-Rick

> I have a working Tiki database on a Windows 2000 box but that computer is needed for other resources and i can't get the existing db moved over to a windows server 2003 server. I can get the basic frame work up but am having a very hard time moving the existing db to the new box. PLEASE HELP THIS VERY GREEN NEWBIE.