sh Johnson
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Archiving A Database
Do you need to archive it forever? Do you need live access to it?
If you just need to archive it, read the man page for mysqldump. You
can
dump specific rows to a file, rename that file dump.2002.05.24, compress
it
with
Do you need to archive it forever? Do you need live access to it?
If you just need to archive it, read the man page for mysqldump. You can
dump specific rows to a file, rename that file dump.2002.05.24, compress it
with gzip, and voila, you have all of your data readily available, easily
reinser
Does anyone know of speedy methods of periodically archiving and
retrieving a database table? I've got a table I'm using to log
statistical data, and it's getting 10k+ entries per day. Entries are
only logged in the database if the user is authenticated for access, and
only once per access session