yankeerivera@yahoo.com wrote:

> While this takes place, the mysqld process has to be down and we
> experience down time. We need to do this at 12AM EST which is a
> problem for Tokyo since it is smack during their busy hours.
>
> What if we just renamed the files, put empty ones in their place and
> restarted mysqld? That is:
<cut>...</cut>
> Assume XYZ_emptyShell.* are valid mysql files representing an XYZ
> table with 0 rows.

If you don't need the old data, that would work, but why not just mirror the
hard drive, that way you always have a backup.

--

//Aho