Re: MySQL 4 maintenance tasks on Windows

2003-06-10 Thread rich johnson
Hi, Hi all I've recently moved a database to MySQL from MSSQL, and am running it on a Windows 2000 Server. Can anybody advise me on the best method for running regular maintenance tasks (i.e. optimize and analyze)? First, I would question that you even need to optimize and analyze "on a regular

MySQL 4 maintenance tasks on Windows

2003-06-10 Thread Gary Broughton
Hi all I've recently moved a database to MySQL from MSSQL, and am running it on a Windows 2000 Server. Can anybody advise me on the best method for running regular maintenance tasks (i.e. optimize and analyze)? I assumed I would be best creating a batch file containing and running 'myisamchk ...