[SOLVED]Can I use an existing DB into installation´s phase?

[rschirin]

as I say into the title, if I have an existing mysql DB, can I specify it(and the admin user) during the installation? or I have to create a new DB?

[crythias]

If you have an existing db, you probably do not want to do an install, as it may drop your tables.

inbefore "But how ..." just make the new tables and then change Config.pm to point to the old data.

Also, your old data may need to be converted to the version being installed. Check upgrading documentation for the installed version.

[rschirin]

My Db is empty. I want only that OTRS will work on it. I don need to drop any data.
if, during installation, I use the name of my Db what will happen?

[rschirin]

can someone help me?
if during the web installation I insert the existing db´s name, otrs returns me an error

Code: Select all

FALSE :-(---==> Can't create database 'prova'; database exists

so what can I do?

inbefore "But how ..." just make the new tables and then change Config.pm to point to the old data.

why I have to create a new DB if I have yet an empty DB?

[crythias]

Your options:

Create a new database

Delete your current database and use the setup procedures

Ignore the setup procedure and manually import the sql according to the README.database

http://source.otrs.org/viewvc.cgi/otrs/ ... iew=markup

Any particular method will be good enough, but if you're encountering an issue because the setup is not happy with you already having the database, then just do an import.

[rschirin]

I used the manually procedures.

now, imagine that I start from the beginning, configure manually the db and don´t use web installer. at last, is root@localhost user set automatically?

[crythias]

Yes, and you can verify from the sql user table .. or view viewtopic.php?f=62&t=9101