I have a large database which apparently has information which must be cleaned before my hosting provider will upload. It is a wordpress database with an added 65,000 posts. A year a I had to manually upload 10k at a time. Once complete I thought it was ok. I am moving servers and my host does not allow an upload bigger than 10meg. My database is now 65 meg so I have had to open a ticket with them. This is their response:
"""The importing process was interrupted by following error occurring at multiple instance: Stopped at the line 787. At this place the current query includes more than 300 dump lines. That can happen if your dump file was created by some tool which doesn't place a semicolon followed by a linebreak at the end of each query, or if your dump contains extended inserts. Please read the BigDump FAQs for more infos."""
I NEED SOMEONE WHO KNOWS HOW TO WORK WITH DATABASES. YOU WILL GET A COPY OF THE DATABASE AND FIX IT THEN SEND IT BACK. Apparently it is simple to do for the right person.
In order to bid on this project you must have completed a mysql skills test and have more than a number of feedback.
Hello, I would like to work on this project. I understand that while exporting the database, you used extended inserts feature which causes such issues. Please check PM for more details.