DB Question....2.0.3

If all you're trying to do is get a "clean" database then you can do the following tasks

I recommend that you back up your existing database first using the mysqlhotcopy command

then use the mysql command line

followed by the commands listed below

drop database otrs;

create database otrs;

use otrs;

\. ./C:\path to otrs directory\scripts\database\otrs-schema.mysql.sql

I think :)

Remember that the semicolons indicate end of sql command string

Brad West

Network/Systems Engineer

Spang & Company

From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Davis, Gary H
Sent: Friday, October 28, 2005 12:44 PM
To: User questions and discussions about OTRS.org
Subject: [otrs] DB Question....2.0.3

Is there a "quick" way to rebuild the initial database delivered with OTRS (Windows version - mysql). Some how in our testing efforts, we have corrupted the database and now no one can login or access the system… even as root.

Follow-up question: has anyone "migrated" a 1.2.3 mysql database into a new install of OTRS 2.0.3? We have done a new install on a different server of the base OTRS system and would like to copy - migrate our existing 1.2.3 data into the new install.

Thanks
Gary Davis
GM PSIC lab Manager