k...@computerking.ca wrote: > 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 > > Any arguments you pass to the update script are passed blindly on to mysql, so if you use the -u and -p options to log in to mysql, you need to use those same arguments for the update script, like so:
/etc/bacula/update_mysql_tables -u bacula -pbacula - Cedric ------------------------------------------------------------------------------ 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
