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@lists.sourceforge.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users