Additionally you will need to run the other sql scripts to populate the database with the initial information as the otrs-schema.mysql.sql file only creates the table structure. The other script should be initial-insert.sql
 
I've not had much luck running the otrs-schema-post.mysql.sql script in a Windows environment.
 
Thanks.
 
Brad


From: West, Bradley G.
Sent: Friday, October 28, 2005 1:32 PM
To: 'User questions and discussions about OTRS.org'
Subject: RE: [otrs] 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