Am 27.01.2011 09:57, schrieb J. Echter: > Am 27.01.2011 08:53, schrieb Randy Katz: >> 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 > Hi, > > im stuck on starting bacula-director again. There's no error message but > bconsle cant connect and netstat -tulpen show no listening director on > port 9101. > > any hints how to solve this? > > greets > > 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 ok, my bad...
i forgot to add new db password in catalog config section. back(ing) up again :) thanks and have a nice day!! 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
