Dear All,
After successfully migrate from 1.32f-5/sqlite on a
sol8/sparc to 1.38.5-4/mysql on a centos3/i386, I post
my diary here.
----
ALWAYS keep older production-run bacula's source-tree
and environment.
Install AppServ to your PC and use phpMyAdmin to
monitor DBs when migrating.
1. Dump bacula sqlite to SQL file on your older
production-run bacula host.
2. Copy it to your newer host, then split SQL file by
__grep "INSERT INTO what-table-you-see-in-phpMyAdmin "
SQL-file-you-just-copy > table-name-you-see.sql__.
3. Use older "create_mysql_database" and
"make_mysql_tables"(do you kept your previous
source-tree?) to prepare mysql on your newer host.
4. Feed mysql on newer host with files split in step
2, monitor mysql on newer host with phpMyAdmin(install
on your PC, use it to monitor your server). Each line
of split SQL files is a "record". Use "cat -n | tail"
to count, compare and fix it until all-error-free.
5. Read "TABLE Version"'s record. Use
"update_mysql_tables_?_to_?" step-by-step in newer
source-tree to update mysql on newer host.
6. Check newer records with bconsole and phpMyAdmin.
----
That's all.
Regards.
_________________________________________________________
捇誥轎煤G蚘眊ㄜ笢弊菴珨橈拸嶼僵蚘璃玊閉湮蚘眊
http://cn.mail.yahoo.com/?id=77071
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
