> Hi,
> I would like to move MYSQL database to another server.
> But when I run any job I have message like below: 
> 
> 
> 
> 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       
> 

In my Job table the ClientId has default value 0.

I don't know what has caused that in your database. How did you move the 
database to the another instance? Using mysqldump and the run the script in the 
another db?

However, you can set the default with the following MySQL command:

    alter table Job modify column ClientId int(11) NOT NULL DEFAULT '0' ;

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