Search for project
More than 2000 projects issued through our platform and this
amount increases very fast.
Repair or rebuild Database (ID:6238)
| Project Creator: |
oman138
FC Member For 6176 Days
Credits 70 Completed Proj. Num. 4 / 16 Total payment USD 805.00 Avg Daily Online 0.06 h (From 21/5/2007) Available on MSN/Skype Yes Last Login 5/30/2013 Peers Rating 100.00% 
|
|---|---|
| Budget: | 250 - 500 |
| Created: | 11/14/2009 1:37:48 AM EST |
| Bidding Ends: | 11/18/2009 1:37:48 AM EST ( Expired ) |
| Development Cycle: | 2 Days |
| Bid Count: | 7
|
| Average Bid: | 338.57 |
| Project Description:
Need to repair or rebuild mysql database. Please read attachment It started with the fact that my success with importing records into an empty table often results in 30,000 blank records because of the way excel converts to csv and requires all the empty col and row to be deleted before saving as csv. So, before I imported 300 records into the LIVE table, I first made a copy of the live table as a backup with a different name. Then I made a second copy with a different name. Into this second copy I pulled the import records. The import worked fine. SO I renamed the original LIVE table something else, and then renamed the newly updated table back to the original name. Client tried writing the query against any of the other copies of the original LIVE table and none of them will process this new query properly. then I found that mysql article about renaming tables and dealing with the lock issue. |
|
| Job Type | .NET, Java, PHP, Javascript |
| Attached Files: | 20091114013040.pdf |
