Re: [Bacula-users] Moving MYSQL database problem

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 <jarif AT iki DOT fi> wrote:

> 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 ALTER TABLE is a DDL and not a DML statement. It does not change any rows in the database.

Now, if you command

DESC Job ;

It should show you that the default for ClientId is 0. Does it?

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

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users