Koozali.org: home of the SME Server

IMP address book export?

rk

IMP address book export?
« 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

Charlie Brady

Re: IMP address book export?
« Reply #1 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

rk

Re: IMP address book export?
« Reply #2 on: August 24, 2002, 02:37:42 AM »
Nope, the directory is empty.

Charlie Brady

Re: IMP address book export?
« Reply #3 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

Geoff Bennion

Re: IMP address book export?
« Reply #4 on: September 04, 2002, 12:47:00 PM »
on the server console try

mysqldump horde > hordedump.txt


voilla.

5c00byd00

Re: IMP address book export?
« Reply #5 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?)

Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
Re: IMP address book export?
« Reply #6 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
......