The answer is more of a work around... edit the make_mysql_tables script
to show:

if $bindir/mysql -u bacula -p <rest of line goes here

Now you can put in the password when prompted. Still there is no drop
tables script. So you would have to do:

mysql -u bacula -p <type in password>

At mysql prompt: drop database bacula; create database bacula; \q

Then (on Ubuntu anyways) cd /usr/share/bacula-director Next:
sudo ./make_mysql_tables

It's all I could think of to do.

--james

On Wed, 2008-06-18 at 17:11 -0400, Ryan Novosielski wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> James Bowes wrote:
> > Hi.
> > 
> > I wanted to start fresh now that I have a good understanding of the set
> > up and testing. Unfortunately Ubuntu 8.04 has no drop_mysql_tables
> > script to automate the process. So I am wondering how would I do that?
> > 
> > Secondly, with the make_mysql_tables script which areas edited to pass
> > along the mysql -u bacula -p (password)?
> 
> I do not believe you need to edit the script -- I'm fairly certain you
> can pass flags to the script to do this.


-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users