Mail Archive Search: <+subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*\[Bacula\-users\]\s+Moving\s+MYSQL\s+database\s+problem\s*$/>

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*\[Bacula\-users\]\s+Moving\s+MYSQL\s+database\s+problem\s*$/: 6 ]

Total 6 documents matching your query.

1. Re: [Bacula-users] Moving MYSQL database problem (score: 1): Author: "Bartosz.C" <bartosz.c AT gmail DOT com>; Date: Tue, 10 Nov 2009 08:41:52 +0100; 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 shoul; /usr/local/webapp/mharc-adsm.org/html/Bacula-users/2009-11/msg00161.html (13,278 bytes)
2. [Bacula-users] Moving MYSQL database problem (score: 1): Author: "Bartosz.C" <bartosz.c AT gmail DOT com>; Date: Fri, 9 Oct 2009 08:10:07 +0200; 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_cre; /usr/local/webapp/mharc-adsm.org/html/Bacula-users/2009-10/msg00121.html (12,395 bytes)
3. Re: [Bacula-users] Moving MYSQL database problem (score: 1): Author: "Jari Fredriksson" <jarif AT iki DOT fi>; Date: Fri, 9 Oct 2009 16:04:51 +0300; 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; /usr/local/webapp/mharc-adsm.org/html/Bacula-users/2009-10/msg00128.html (13,074 bytes)
4. Re: [Bacula-users] Moving MYSQL database problem (score: 1): Author: John Drescher <drescherjm AT gmail DOT com>; Date: Fri, 9 Oct 2009 09:04:48 -0400; I can tell you that this works. My database has always (5+ years) existed on a different server than the director. I have never seen this error. How did you move the database? Using mysqldump then p; /usr/local/webapp/mharc-adsm.org/html/Bacula-users/2009-10/msg00129.html (13,361 bytes)
5. Re: [Bacula-users] Moving MYSQL database problem (score: 1): Author: "Bartosz.C" <bartosz.c AT gmail DOT com>; Date: Mon, 12 Oct 2009 14:35:39 +0200; 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 m; /usr/local/webapp/mharc-adsm.org/html/Bacula-users/2009-10/msg00163.html (12,321 bytes)
6. Re: [Bacula-users] Moving MYSQL database problem (score: 1): Author: "Jari Fredriksson" <jarif AT iki DOT fi>; Date: Mon, 12 Oct 2009 15:56:16 +0300; 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 s; /usr/local/webapp/mharc-adsm.org/html/Bacula-users/2009-10/msg00165.html (12,393 bytes)

Current List: 1 - 6
Page: [1]