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
3 messages in com.mysql.lists.win32Re: Re: Database Backup Question 
