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