> I would like to move MYSQL database to another server. But when I run any
> job I have message like below:
>
I can tell you that this works. My database has always (5+ years)
existed on a different server than the director.
>
> 09-paĹş 07:40 max-dir: TygWymiatacz.2009-10-09_07.40.25 Fatal error:
> sql_create.c:85 sql_create.c:85 insert INSERT INTO Job
> (Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES
> ('TygWymiatacz.2009-10-09_07.40.25','TygWymiatacz','B','I','C','2009-10-09
> 07:40:23',1255066823) failed:
>
> Field 'ClientId' doesn't have a default value 09-paĹş 07:40 max-dir:
> TygWymiatacz.2009-10-09_07.40.25 Fatal error: sql_create.c:87 Create DB Job
> record INSERT INTO Job (Job,Name,Type,Level,JobStatus,SchedTime,JobTDate)
> VALUES
> ('TygWymiatacz.2009-10-09_07.40.25','TygWymiatacz','B','I','C','2009-10-09
> 07:40:23',1255066823) failed. ERR=Field 'ClientId' doesn't have a default
> value
>
> What can I do?
> Bartosz.
>

I have never seen this error.

How did you move the database? Using mysqldump then pipe the output
file to mysql on the new machine?

http://www.thegeekstuff.com/2008/09/backup-and-restore-mysql-database-using-mysqldump/

John

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users