Koozali.org formerly Contribs.org

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