Hello all i am having database problems again, have recently updated to Bacula 
version 3.0.2 (installed from source on ubuntu 8.04). Tried to run 
/etc/bacula/update_mysql_tables and got this error

This script will update a Bacula MySQL database from version 10 to 11
 which is needed to convert from Bacula version 2.0.x to 3.0.x or higher

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: 
NO)
Update of Bacula MySQL tables failed.

So then i tried to pass the script to mysql like this still did not work

mysql bacula -ubacula -pbacula < /etc/bacula/update_mysql_tables
ERROR 1064 (42000) at line 5: 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 'echo " "
echo "This script will update a Bacula MySQL database from version 10 t' at 
line 1

Can i run the script from within mysql? seem to remember that being an unwise 
thing to do!  However i do not know how to get bacula's database updated! need 
pass a username and password to the script somehow? 

Please help
 

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users