Topic: Backing up mySQL DB's

[brad wright]

Hi all,

I am now desperate to upgrade my e-smith 4.1.2 server to the SME sever 5.5 (especially now I have been informed of the latest security update).

Before I do tho, I would liek to backup my mySQL permissions DB (and its contents) as well as the other DB's I have been working on/with.

Can someone tell me the how I can go about this?? Apart form the permissioons DB, I only need to save the structure ofmy DB's, not the actual data.

Thanks,
Brad

[Des Dougan]

/sbin/e-smith/signal-event mysql-dump-tables (from /sbin/e-smith/backup).

Des Dougan

[Byte]

take a look in /var/lib/mysql

All the databases are stored in there you will probably need to create the database as you would using mysql the just copy databases as needed i found it work fine

hope this helps

Byte