MySQL Forums
Forum List  »  Microsoft SQL Server

Compact & Repair
Posted by: Tom White
Date: September 08, 2011 07:27AM

We've a new database running MY SQL 5.0.
Imported several hundred entries, deleted them, reimported and scrapped them again. Now thelatest import appears to do what we want.

Response time accessing via the phpMyAdmin panel is now extremely slow. Access has a compact & repair option: anything similar in Myn SQL?
I backed up the database before playing with it so could revert to original but sometime in the future, the problem will no doubt arise again.

Is the following URL of any use or is there a better way:-
http://softwaretopic.informer.com/mysql-database-compact-and-repair/

Options: ReplyQuote


Subject
Written By
Posted
Compact & Repair
September 08, 2011 07:27AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.