Re: [Bacula-users] brestore cache tables

I'm just thinking about the functions & procs ...
Perharps just changing the db/tables engine to innodb would suffice ?
As default myisam are not capable of ...

There's perharps a skip-innodb inside my.cnf ....



ebollengier wrote:
> Hello Paul,
> 
> Just remove all functions of the file (only one at the top i think)
> 
> Bye
> 
> 
> P.A wrote:
>> Eric, thanks for the reply.
>>
>> I kind of figure it was a compatibility issue with MYSQL version, I'm
>> using
>> centos 4 with mysql 4.1. Could you let me know what code I need to remove.
>> I
>> don't want to go through the trouble of recompiling mysql since this is a
>> test system.
>>
>>
>> Paul
>>
>> -----Original Message-----
>> From: ebollengier [mailto:eric AT eb.homelinux DOT org] 
>> Sent: Saturday, October 17, 2009 10:45 AM
>> To: bacula-users AT lists.sourceforge DOT net
>> Subject: Re: [Bacula-users] brestore cache tables
>>
>>
>>
>>
>> Paul A-2 wrote:
>>> Hi trying to get webrestore to work, so far I can see page clients but
>>> not
>>> jobs. I believe this is because I have no imported the bweb.sql.
>>>
>>>  
>>>
>>> According to the install file its says, "3) Make sure that brestore cache
>>> tables are in your catalog (bweb-xxx.sql files)"
>>>
>>>  
>>>
>>> How do I achieve this, I ran the following but it doesn't work.
>>>
>>>  
>>>
>>> mysql -u bacula -p bacula < bweb-mysql.sql
>>>
>>> Enter password:
>>>
>>> ERROR 1064 (42000) at line 7: 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 'IF EXISTS base64_decode_lstat' at line 1
>>>
>> Hello,
>>
>> Perhaps your Mysql version is a bit old to support PL procedure. You can
>> remove PL code from the 
>> bweb-mysql.sql, it is only used in the bfileview module or you can upgrade
>> your Mysql.
>>
>> Bye
>>


-- 

     Bruno Friedmann



------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users