C:\Program Files\MySQL\MySQL Server 5.5\bin>mysqlcheck -u root -p --optimize --databases dg_db_batch Enter password: ********** mysqlcheck -u root -p --optimize --databases dg_db_batch mysqlcheck -u root -p --optimize --databases dg_db_chart_day mysqlcheck -u root -p --optimize --databases dg_db_chart_month mysqlcheck -u root -p --optimize --databases dg_db_chart_week mysqlcheck -u root -p --opt..

RESTORE FILELISTONLY FROM DISK = 'D:\ems_monitor_backup_20070226' RESTORE DATABASE ems_monitor FROM DISK = 'D:\ems_monitor_backup_20070226' WITH MOVE 'ems_monitor_Data_01' TO 'D:\MSSQL\ems_monitor_Data_01_Data.NDF', MOVE 'ems_monitor_Log_01' TO 'D:\MSSQL\ems_monitor_Log_01_Log.LDF', stats = 10 exec sp_helpdb ems_monitor exec sp_dbcmptlevel 'ems_monitor', '90' DBCC SHRINKDATABASE (ems_monitor) GO