Topic: Backup to desktop

[Duane Rinehart]

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)

[Franck PIERRE]

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

[Charlie Brady]

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

[Rich Lafferty]

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