StarDestroyer.Net BBS

Posted: **2006-06-10 06:07pm**

I tried uploading my zipped database via phpMyAdmin, and got this message:

Error message wrote:Error

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: Unclosed quote @ 91
STR: '
SQL:
INSERT INTO phpbb_search_wordlist (word_text, word_id, word_common) VALUES('�', '8159', '0');

SQL query:

INSERT INTO phpbb_search_wordlist (word_text, word_id, word_common) VALUES('�', '8159', '0');

MySQL said: Documentation
#1062 - Duplicate entry '?' for key 1

I had previously tried using bigdump.php, which said that it completed successfully, but didn't actually import anything.

This is getting ridiculous. There's no way it should be this hard just to restore a friggin' backup. Can someone please help me? I posted this on the phpBB forums this morning, and nobody even looked at it, much less responded.

Posted: **2006-06-10 07:23pm**

I uploaded from scratch and it threw the same error.

Posted: **2006-06-10 10:11pm**

Crisis averted. Managed to upload it using bigdump. The problem before was that I wiped it clean and therefore there was no config file. Anyway, it's working now. Thanks for the help.

Posted: **2006-06-11 09:22pm**

In future, remember that phpmyadmin does not handle very large files well. With a huge DB like mine (which is pushing 3 GB before compression, and more than 600MB even with bzip2 compression), it would be insane to even attempt to upload it through phpMyAdmin.

Eventually, any phpBB admin (or an admin of any large database-driven content) must learn how to work the command-line for uploading and backup/restore of database contents.

Posted: **2006-06-12 02:00am**

Well, I'm hoping to put off having to do that for as long as possible.

I at least have the basics down, now, even though I wasn't able to successfully upload a database using SSH.

StarDestroyer.Net BBS

phpBB backup restore woes

phpBB backup restore woes