Got error when I tried to import to new pacsone server machi

don · Post by **don** » Sat Jan 21, 2006 1:15 am

Hi Guy,
I was tried to import from current pacsone server (win2000) to new server (win2003). And I got the error...

Error: Failed to schedule database job for importing studies from E:/cd/VOL1/.
MySQL Error: Table 'pacsone.dbjob' doesn't exist

Do anyone know how to fix this error ? or how to transfer database from old pacsone server to new server.
Thx for any reply.
don

Post by **pacsone** » Sat Jan 21, 2006 2:19 am

This means the database tables on the server where you are performing the Import were not configured properly, since the dbjob table was missing from your database.

You can run the following query from a MySQL shell to check if your database is setup properly:

C:\mysql\bin>mysql -u $username -p $database

where:

$database/$username is the MySQL database/username you've assigned for PacsOne Server.

mysql>show tables;

Version 3.1.7 of PacsOne Server should have 31 tables while version 3.1.8 should have 32.

Don · Post by **Don** » Tue Jan 24, 2006 7:05 pm

Hi Pacsone admin,
But when I tried and I got another error on new server neither on old server too.

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -u $username -p $database
Enter password: **********
ERROR 1045 (28000): Access denied for user '$username'@'localhost' (using passwo
rd: YES)

thanks.

Post by **pacsone** » Wed Jan 25, 2006 3:32 am

This error means either your MySQL username or password is not valid for that server.

You can reset the MySQL username/password if you know the MySQL root password for that server.