Hi, I have a large Drupal database .sql export (824MB). I'm trying to import it into a new database via phpMyAdmin.
It's large so I got the error "Script timeout passed, if you want to finish import, please resubmit same file and import will resume", which was expected. The Partial Imported noted "Previous import timed out, after resubmitting will continue from position 589264049."
After resubmitting, the error was:
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
ERROR: Unknown Punctuation String @ 322
('0ee04fbb47cb6eb148412f623f21d70a', 'cache/normal/djquad.com/Starcraft_2_Wings_of_Liberty/Achievements/Liberty_Campaign/Artifact_Missions/Supernova_.html', 'cache/normal/djquad.com', 0, -1, -1, 'node', 'achievement_sub', '1963', '.html', 3048, 2128, '802c76f9741495c81143b0facc188982', 'http://djquad.com/Starcraft_2_Wings_of_Liberty/Achievements/Liberty_Camp...'),
There were a few lines that contained "des-22646". 1 of them was:
('0fafae5a4d179748187454ada7e20103', 'cache/normal/djquad.com/Search_cx=partner-pub-2800480548064540:9781774728&cof=FORID:11&ie=UTF-8&as_q=la noire traffic&sa=Search.html', 'cache/normal/djquad.com', 0, -1, -1, 'node', 'page', '7888', '.html', 888, 714, '8ed7d1d0a0c53b0732176ce5c3b51d5a', 'http://djquad.com/Search?cx=partner-pub-2800480548064540%3A9781774728&co...');des-22646'),
I'm not sure how to get this import working. Unfortunately I don't have access to phpMyAdmin that exported the .sql file, just the .sql file itself.