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
STR: ://
SQL: des-22646'),
('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.


VM’s picture

A) you can't be using Drupal 8.x
B) this question is better served in the 'post installation' forum. Please edit the opening post and move it. Thanks.

DJQuad’s picture

Done, thanks for the suggestion.

I'm not sure of the Drupal version, but regardless, the database itself was a phpMyAdmin .sql export and I'm trying to import it to a blank database through phpMyAdmin on the new host.

DJQuad’s picture

Nevermind, I did a manual import.

And they wonder why everyone is switching to WordPress.

VM’s picture

And they wonder why everyone is switching to WordPress.

everyone? can you qualify or quantify that? You are aware that the amount of active drupal sites increases with every release?

That aside, your issue isn't Drupal as much as it is the environment. you're importing nearly a gig of data into a database. Shared host perhaps? if so, expect to hit resource limits. Cache tables, watchdog table, and sessions tables are typically emptied before export to aid in making the export smaller. There are also scripts that can be used to get around resource limits. BIGDUMP for example.