Change database

slashdot

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

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

Hey,

What's the exact error?

slashdot

when I change

define('DBNAME','support_db');

in ostconfig.php

define('DBNAME','testsupport_db');

then I get

<STRONG><s>**</s>Fatal Error: <e>**</e></STRONG>Contact site admin.

in my webbrowser

nothing in apache error_log

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)

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

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 GMT by xxxx (squid/2.5.STABLE14)

and ind apache error_log

child pid 22166 exit signal Segmentation fault (11)

I didn't change anything..promised

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

regards

david