Re: [Bacula-users] Moving MYSQL database problem

2009-11-09 Thread Bartosz.C
Hi, Solution for this problem was very easy, Bacula director was on debian lenny, and bacula storage was on debian etch, I have installed lenny and all my problems with bacula goes away. Thank you for helping. S. On Mon, Oct 12, 2009 at 1:56 PM, Jari Fredriksson wrote: > > Hi, > > > > after: >

Re: [Bacula-users] Moving MYSQL database problem

2009-10-12 Thread Jari Fredriksson
> Hi, > > after: > > ALTER TABLE Job MODIFY COLUMN ClientId INT(11) NOT NULL > DEFAULT '0'; > > result: > (0 row(s) affected) > Execution Time : 00:00:00:016 > Transfer Time : 00:00:01:015 > Total Time : 00:00:01:031 > Now, if you wonder the "0 row(s) affected" that is maybe because ALTE

Re: [Bacula-users] Moving MYSQL database problem

2009-10-12 Thread Bartosz.C
Hi, after: ALTER TABLE Job MODIFY COLUMN ClientId INT(11) NOT NULL DEFAULT '0'; result: (0 row(s) affected) Execution Time : 00:00:00:016 Transfer Time : 00:00:01:015 Total Time : 00:00:01:031 >>How did you move the database to the another instance? Using mysqldump and the run the script i

Re: [Bacula-users] Moving MYSQL database problem

2009-10-09 Thread John Drescher
> 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:

Re: [Bacula-users] Moving MYSQL database problem

2009-10-09 Thread Jari Fredriksson
> 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,J

[Bacula-users] Moving MYSQL database problem

2009-10-08 Thread Bartosz.C
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 ('TygW