[Bacula-users] drop_mysql_tables
2009-04-15 03:57:12
Out of curiosity, can anyone tell me why this script got rid of all of
the volumes, but not the old jobs? (When I ran it I got the succeeded
comment.) I also tried just deleting the jobs from bconsole, but they
didn't seem to go away then either.
thanks,
maria
#!/bin/sh
#
# shell script to delete Bacula tables for MySQL
bindir=@SQL_BINDIR@
if $bindir/mysql $* <<END-OF-DATA
USE bacula;
DROP TABLE IF EXISTS Filename;
DROP TABLE IF EXISTS Path;
DROP TABLE IF EXISTS LongName;
DROP TABLE IF EXISTS Device;
DROP TABLE IF EXISTS Storage;
DROP TABLE IF EXISTS MediaType;
DROP TABLE IF EXISTS File;
DROP TABLE IF EXISTS Client;
DROP TABLE IF EXISTS Job;
DROP TABLE IF EXISTS Media;
DROP TABLE IF EXISTS JobMedia;
DROP TABLE IF EXISTS Pool;
DROP TABLE IF EXISTS MultiVolume;
DROP TABLE IF EXISTS FileSave;
DROP TABLE IF EXISTS FileSet;
DROP TABLE IF EXISTS Version;
DROP TABLE IF EXISTS Counters;
DROP TABLE IF EXISTS BaseFiles;
DROP TABLE IF EXISTS UnsavedFiles;
DROP TABLE IF EXISTS CDImages;
DROP TABLE IF EXISTS Status;
DROP TABLE IF EXISTS MAC;
DROP TABLE IF EXISTS Log;
DROP TABLE IF EXISTS Location;
DROP TABLE IF EXISTS LocationLog;
END-OF-DATA
then
echo "Deletion of Bacula MySQL tables succeeded."
else
echo "Deletion of Bacula MySQL tables failed."
fi
exit 0
------------------------------------------------------------------------------
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- [Bacula-users] drop_mysql_tables,
Maria McKinley <=
|
|
|