Koozali.org: home of the SME Server

Legacy Forums => Suggestions => Topic started by: Duane Rinehart on November 16, 2001, 10:48:49 PM

Title: Backup to desktop
Post by: Duane Rinehart on November 16, 2001, 10:48:49 PM
Is it possible to include in the backup to the desktop option the /var/lib/mysql directory to backup the databases?  It appears this data are only saved in the tape backup option.  Otherwise is there any way to configure it personally?  (i.e., from the server manager)
Title: Re: Backup to desktop
Post by: Franck PIERRE on November 19, 2001, 09:23:17 PM
It is a known bug (see http://www.e-smith.org/bugs/index.php3?op=showBug&bugID=51).

But i have to warn you that the solution exposed may not be the best, as you'll have to modify the root password in all your applications using MySQL. And a friend of mine has told me that Mitel's solution did not work for him.

Here is an other way to correct that bug (i found it 2 ways ago and i'm not sure it won't have bad and unknown consequences) :

# grep password /root/.my.cnf | cut -d= -f2 > /etc/openldap/ldap.pw
# perl -i -pe 's/genLdap/Ldap/' /etc/e-smith/templates/etc/openldap/slapd.conf/80rootpw
# /sbin/e-smith/expand-template /etc/openldap/slapd.conf
# service ldap restart

With this solution, you change the LDAP password and not the MySQL pasword, so, I think it is a better way to correct that bug. But do be carreful, as i don't really know if it is not a worse solution.
In case of doubt, you should contact bugs@e-smith.com
Title: Re: Backup to desktop
Post by: Charlie Brady on November 29, 2001, 01:18:28 AM
Duane Rinehart wrote:
 
> Is it possible to include in the backup to the desktop option
> the /var/lib/mysql directory to backup the databases?

A dump of your tables should be found in /home/e-smith/db/mysql/ which is included in the backup file.

Charlie
Title: Re: Backup to desktop
Post by: Rich Lafferty on November 29, 2001, 01:35:21 AM
Also, be sure to apply either Update 3 or the workaround explained here:

http://www.e-smith.org/bugs/?op=showBug&bugID=51


Cheers,
 
  -Rich