On 1/26/2011 11:37 PM, J. Echter wrote: > 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. > hi, you don't need that line, comment out with a # at the beginning, please if you have more problems feed the next lines before the database/table create statements here and I will look them up. Here are some notes on converting a google search brings more:
http://stackoverflow.com/questions/18671/quick-easy-way-to-migrate-sqlite3-to-mysql http://www.google.com/search?q=convert+sqlite+to+mysql&ie=utf-8&oe=utf-8&aq=t&client=firefox-a&rlz=1R1GGLL_en___US399 I hope that helps, take care Randy ------------------------------------------------------------------------------ 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
