Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: rk on August 24, 2002, 12:07:58 AM

Title: IMP address book export?
Post by: rk on August 24, 2002, 12:07:58 AM

Can anyone give me a quick set of mysql commands to dump the IMP addressbook information out of database?  I would like to have a flat file dump of the table for easier backup purposes.

Thanks...
rk

Title: Re: IMP address book export?
Post by: Charlie Brady on August 24, 2002, 12:59:55 AM

rk wrote:
 
> Can anyone give me a quick set of mysql commands to dump the
> IMP addressbook information out of database?  I would like to
> have a flat file dump of the table for easier backup purposes.

Have a look in /home/e-smith/db/mysql - you probably have a dump of all MySQL tables already.

Charlie

Title: Re: IMP address book export?
Post by: rk on August 24, 2002, 02:37:42 AM

Nope, the directory is empty.

Title: Re: IMP address book export?
Post by: Charlie Brady on August 25, 2002, 09:22:28 AM

rk wrote:

> Nope, the directory is empty.

Hm, yes, they would be. I see that the backup panel dumps all tables, performs a backup, then removes the dumped files. If your system does not have more than 2GB of data, then you can do a backup to desktop, then verify the backup - you'll see the table dumps in the list of files in your backup.

Charlie

Title: Re: IMP address book export?
Post by: Geoff Bennion on September 04, 2002, 12:47:00 PM

on the server console try

mysqldump horde > hordedump.txt


voilla.

Title: Re: IMP address book export?
Post by: 5c00byd00 on December 11, 2006, 11:46:45 AM

Quote from: "Geoff Bennion"

on the server console try

mysqldump horde > hordedump.txt


voilla.

This works perfectly, but how can this be imported into a fresh install of SME6 (or 7?)

Title: Re: IMP address book export?
Post by: mrjhb3 on January 07, 2007, 10:07:38 PM

Quote from: "5c00byd00"

Quote from: "Geoff Bennion"

on the server console try

mysqldump horde > hordedump.txt


voilla.

This works perfectly, but how can this be imported into a fresh install of SME6 (or 7?)

mysql horde < hordedump.txt

John