Topic: IMP address book export?

[rk]

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]

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]

Nope, the directory is empty.

[Charlie Brady]

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]

on the server console try

mysqldump horde > hordedump.txt


voilla.

[5c00byd00]

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?)

[mrjhb3]

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