On 1/27/2011 12:57 AM, J. Echter wrote:
> 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 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.
>>>
>> 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?
>
check what is it /var/bacula/working/log
and act accordingly.

------------------------------------------------------------------------------
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