Re: [Bacula-users] Moving MYSQL database problem
2009-10-12 08:37:45
Subject: |
Re: [Bacula-users] Moving MYSQL database problem |
From: |
"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
>>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
|
|
|