[ic] exporting all tables for backup

[Mark Weaver]

Grant wrote:
>>>>Is there a better way than this to export all tables so their data can
>>>>be backed up with the rest of the catalog:
>>>>
>>>>[loop list="products userdb etc"]
>>>>        [export table="[loop-code]"]
>>>>[/loop]
>>>>
>>>>- Grant
>>>
>>>Grant,
>>>
>>>Are we talking a manual or automated backup? If you're doing manual
>>>backups of your interchange data tables then MySQL Administrator works
>>>wonderful for this; puts everything including the SQL needed for restore
>>>along with all the data into on handy file that takes seconds to restore.
>>>
>>>If you're talking about an automated process you may want to take a look
>>>at assigning this duty to a perl program that will accomplish basically
>>>the same thing; a PERL program connected to a cron job.
>>>
>>>
>>
>>You may not need to write a perl script if you are using MySQL.  Just use the
>>mysqldump program found in most MySQL distributions.  You could add something
>>like this to your crontab:
>>
>>0 3 * * * mysqldump --user=user --password=password interchange_database >
>>/path/to/backup.sql
>>
>>Or a simple bash wrapper script that rotates the destination file.
>>
>>(Check mysqldump --help or http://dev.mysql.com/doc/mysql/en/mysqldump.html for
>>more options)
>>
>>- Brian
> 
> 
> Thanks guys, that sounds pretty slick but IC already has a
> dumper/exporter built in right?  Using that makes it easy to backup
> the database data along with the catalog files.  I suppose something
> like mysqldump would be just about as simple.
> 
> - Grant

Grant,

you could actually do both from a cron job which would be the best 
solution since you wouldn't have to do this manually. To back up the 
catalog files simply include this in the interchange users cron tab or 
the root user's cron tab.

	tar -zcf /home/interch/catalogs interch_cat.tgz

-- 
Mark
-----------------------------------------------------------
Paid for by Penguins against modern appliances(R)
Linux User Since 1996
Powered by Mandrake Linux 8.2, 10.0 & RH Fedora Core 3