Batch file to easily optimize the mysql database
Batch file to easily optimize the mysql database
SET mysqldir=c:mysql in
SET mysqluser=root
SET mysqlpassword=mypass
@REM Change to mysqldir
CD %mysqldir%
@REM dump database. This is all one line
"%mysqldir%mysqlcheck" -u %mysqluser% -p%mysqlpassword% --repair --analyze --optimize --all-databases --auto-repair"