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

-- 
View this message in context: 
http://www.nabble.com/brestore-cache-tables-tp25928701p25938851.html
Sent from the Bacula - Users mailing list archive at Nabble.com.


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