Change database

[slashdot]

Hi

At the moment I have two osTickets systems.

One test and one 'beta' ;)

But they have the same mysql database so I made a dump and imported it into a new db.

Now where can I switch the db in my osTicket config?

Do I have to run the setup again and will lost all my configuration? That wouldn't be a good solution..


Thanks
slashdot

[kilahimm]

I think I follow what you're saying. If you open the ostconfig.php file you can point it to the new database host and new database name if necessary.

Hope this helps.

[slashdot]

thanks for the hint..

but now I have a Fatal error :D

It's strange because in phpMyAdmin the DBs look similar..

I used

mysqldump -u root -p support_db > /tmp/suppbak.sql

and

mysqldump -u root -p testsupport_db < /tmp/suppbak.sql

to copy the DB...

[Corey]

thanks for the hint..
but now I have a Fatal error :D


Hey,

What's the exact error?

[slashdot]

when I change

define('DBNAME','support_db');

in ostconfig.php

to

define('DBNAME','testsupport_db');

then I get

Fatal Error: Contact site admin.

in my webbrowser


[edit]
nothing in apache error_log

[edit2]

What version of MySQL do you have osTicket installed on?
mysql Ver 14.12 Distrib 5.0.26, for suse-linux (x86_64) using readline 5.1

What version of PHP do you have osTicket installed on?

PHP 5.2.5 with Suhosin-Patch 0.9.6.2 (cli) (built: Mar 12 2009 15:47:05)

What OS (Windows, Linux) do you have osTicket installed on?
SLES 10

What version of osTicket do you have installed?
1.6 RC4

What's the link to your install?
change my DB from support_db to testsupport_db

[Corey]

Hey,

Replace main.inc.php with this file: http://www.ostickethacks.com/code_edits/main.inc.phps. It should tell you the exact MySQL error.

[slashdot]

solved..

My DB user (support) didn't have the rights for the new database...my fault *head -> desk* ;)

but thanks for the help!

cheers
slashdot

[slashdot]

hm..strange

in my test DB the ticketID is now only one digit when I create a new ticket..
so after 10 tickets I get this error when creating a new ticket


ERROR
The requested URL could not be retrieved

While trying to retrieve the URL: http://xx/testsupport/scp/tickets.php

The following error was encountered:

* Zero Sized Reply

Squid did not receive any data for this request.

Your cache administrator is webmaster.
Generated Wed, 01 Jul 2009 15:09:55 GMT by xxxx (squid/2.5.STABLE14)


and ind apache error_log

[Wed Jul 01 17:04:34 2009] [notice] child pid 22166 exit signal Segmentation fault (11)

I didn't change anything..promised :D


It's not that urgent. I know you are busy with the new RC ;)


cheers
slashdot

[royale]

Hi,
where can i change the DB-data in RC1.65? I need to migrate from one server to another...

EDIT: Found it.. :D

regards
david