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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
