Am 26.01.2011 17:04, schrieb J. Echter:
> Hi,
>
> im running Ubuntu Lucid Server x64.
>
> I'd like to migrate from bacula-sqlite to bacula-mysql, but i have one
> problem. Im not a MySQL expert and i already have one Database running
> with MySQL.
>
> Can someone advice how to handle my situation without damaging anything? :)
>
> I would do the following:
>
> 1. dump sqlite db
> 2. remove sqlite parts of bacula
> 3. install mysql parts of bacula
> 4. creating db (there im not sure if can break something if i just use
> the script from bacula)
> 5. loading previously dumped tables back to mysql (i dont know how yet)
>
> or would postgresql the better choice?
>
> cheers
>
> juergen
>
> ------------------------------------------------------------------------------
> Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
> Finally, a world-class log management solution at an even better price-free!
> Download using promo code Free_Logger_4_Dev2Dev. Offer expires
> February 28th, so secure your free ArcSight Logger TODAY!
> http://p.sf.net/sfu/arcsight-sfd2d
> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
Hi,

im currently trying to feed my sqlite dump back into mysql db... Error i 
get is:

mysql -u root -p < bacula.sql
Enter password:
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; 
check the manual that corresponds to your MySQL server version for the 
right syntax to use near 'PRAGMA foreign_keys=OFF' at line 1

as i said im not so good in this sql stuff :) could anyone point me into 
the right direction?

cheers.

juergen.

------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires 
February 28th, so secure your free ArcSight Logger TODAY! 
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users