Re: [Bacula-users] Moving MYSQL database problem

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 in the another db?
>>Using mysqldump and the run the script in the another db?
yes, I did mysqldump and restore

mysqldump -u backup -ppasword bacula -h myserver > 2009-10-08bacula
mysql -u root -D bacula -p<2009-10-08-bacula

only one thing was changed - default charset for entire DB from latin1 to utf-8 (and of course IP from local to remote host)

Bartosz.

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