Re: [Bacula-users] resetting bacula to a clean state

Here link for This cuestión. (In spanish) http://blogsistemas.com/resetear-por-completo-la-base-de-datos-de-bacula/ Good luck! El 2 nov. 2016 18:41, "Thing" escribió: > Hi, > > I have bacula running on centos7.2 using mysql. > > What do I do to delete the test backups

Re: [Bacula-users] resetting bacula to a clean state

google eventually returned the syntax I needed, [root@ovirt1 bacula]# /usr/libexec/bacula/grant_mysql_privileges -u root -p Enter password: 8><- Privileges for user bacula granted on database bacula. [root@ovirt1 bacula]# /usr/libexec/bacula/make_mysql_tables -u bacula -p Enter password:

Re: [Bacula-users] resetting bacula to a clean state

I already tried that, [root@ovirt1 bacula]# ./create_mysql_database ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Creation of bacula database failed. [root@ovirt1 bacula]# On 3 November 2016 at 11:03, Mike Ruskai wrote: >

Re: [Bacula-users] resetting bacula to a clean state

make_mysql_tables is a shell script, not just a set of SQL statements. Run it by itself, providing whatever options you need to connect to and authenticate with the correct MySQL instance. In your case, it looks like you just need to get rid of "mysql <" on your command line. On 11/2/2016

Re: [Bacula-users] resetting bacula to a clean state

I went into the mysql and dropped the bacula database. However I am having problems trying to re-create the database/tables, [root@ovirt1 bacula]# mysql < make_mysql_tables -p Enter password: ERROR 1064 (42000) at line 9: You have an error in your SQL syntax; check the manual that

[Bacula-users] resetting bacula to a clean state

Hi, I have bacula running on centos7.2 using mysql. What do I do to delete the test backups and start fresh? This must rate being a FAQ? however I find little via google on how to do this (that worked). thanks --