Re: Re: Database Backup Question

> At 03:43 AM 2/18/2003 +0100, you wrote:
> >Why you don't like BACKUP TABLE command? :-)
> >To solve your problem you can do this:
> >1) backup selected tables to some empty directory.
> >2) zip all files in this directory using winzip on Windows or gzip/tar on
> >Linux platform to the same directory.

Better yet use bzip2, it will produce a smaller file (smaller that any
other archiver on win or nix as far as i know / test).
(On FreeBSD: tar -cjf  /tmp/mybackup.tbz2 /tmp/my_exp_dir/
where j stands for filtering through bzip2)
Pay attention to the max_execution_time (default: 30 seconds if not in a
CLI), if the db is large  it could hang here.
If your back-upping small tables i guess you could use bzip2 library of php
and do it all in one step (useful also if you don't have shell access on
the server).

IOnut

sql,query,database,odbc 



---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before
posting. To request this thread, e-mail win32-thread10563@xxxxxxxxxxxxxxx

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail win32-unsubscribe@xxxxxxxxxxxxxxx instead.