I am using mysql 5.0 on Suse10.0 for a logging system where one table is
used for each day.
So the tables of yesterday and earlier are not used for writing, only for
When I want to make a backup of the tables is it then safe to do
cp tablename.* /tmp/backup
from a shell script, or do I need to use the mysqldrop command?
And as for deleting of the tables, is it safe to delete the tables' files
(with "rm yesterday.* "), or do I need to execute the 'DROP TABLE yesterday'
Again, is ...