Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: brad wright on September 17, 2002, 06:58:40 AM

Title: Backing up mySQL DB's
Post by: brad wright on September 17, 2002, 06:58:40 AM

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

Title: Re: Backing up mySQL DB's
Post by: Des Dougan on September 17, 2002, 08:20:24 AM

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

Des Dougan

Title: Re: Backing up mySQL DB's
Post by: Byte on September 17, 2002, 02:13:12 PM

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