OK, how to I do a dump using sqlite? Mike
Darien Hager wrote: > > Mike Vasquez wrote: >> What would be the best way to approach this? I have thought of just >> installing the latest version of Bacula in a different location and start >> with a fresh database. Then if someone wants to recover a file from an >> old >> backup, I could just use the older version of Bacula for this reason. >> Any >> opinions out there? >> > I am most-definitely-not-a-guru about this question, but two ideas... > First, if Bacula doesn't do much that takes advantage of DB-specific > stuff (e.g. foreign key constraints, etc), you may be able to simply > recompile (if needed) the director with support for MySQL and do a dump > from SQLite into plain SQL and then run that against your MySQL server. > > Failing that, you could start a new fresh Director+MySQL set-up, use all > the old config scripts, and use "bscan" to scan the old volumes and put > their data into the database. (With a lot of tapes, this may take a > while... but if you were using SQLite, I'm guessing it was a fairly > light set-up to files?) > > --Darien Hager > [EMAIL PROTECTED] > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > > -- View this message in context: http://www.nabble.com/Convert-from-SQLITE-TO-MYSQPL-tf3687649.html#a10312821 Sent from the Bacula - Users mailing list archive at Nabble.com. ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
