I have a 1 GB mysql DB which is not stable, and thus, an import process is failing.
I need help to stabilize the DB.
I have tried to Check , Repair, Optimize all tables. This was not enough.
I get for example error messages such as :
Problems with indexes of table `smf_members`
More than one INDEX key was created for column `memberName`
Problems with indexes of table `smf_messages`
UNIQUE and INDEX keys should not both be set for column `ID_TOPIC`
UNIQUE and INDEX keys should not both be set for column `ID_MEMBER`
More than one INDEX key was created for column `ID_MEMBER`
Maybe you as an experienced mysql coder might be able to get this done in 2 minutes. I will still accept your work if the import process I am doing works.
Of course you will be granted full phpmyadmin access to be able to do your work correctly.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
mysql