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
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
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