Before any kind souls spend any time on this... I seem to have fixed
the problem. I assumed that the blank wiki meant that my database had
been cleared. Actually, I somehow stupidly swapped the wiki database
name and the wiki username in the install set up, so I got a new blank
database with a new user!
The original database was still there, so I took the opportunity to do
another backup via phpmyadmin (this time checking "Drop Tables" under
structure, just to make sure I had a full backup. Then I ran the
install again (with the correct database and wiki usernames) and all
went well.
The only problem that I have remaining is that all of the images are
missing. I'm assuming specifying some path somewhere will correct that
(and that hopefully all the uploaded images are still there!).
On 5/20/06, CheekyGeek <cheekygeek(a)gmail.com> wrote:
Following the directions pointed to (thanks for that
link) I ran into some
problems. First of all, I locked the database from changes by removing the
wiki-user's INSERT, DELETE, UPDATE privileges. However, the instructions do
not tell you when you need to restore the wiki-user's privileges. I realized
this when,during the install process, things seemed to be going well but ran
into an error message part way through that seemed to indicate something the
wiki-user was unable to do. So, I restored the wiki-user's INSERT, DELETE,
UPDATE privileges and ran the install process again. Instead of the messages
I got before (that tables were found...good...etc.) I just got the instant
"your wiki is setup" message. Now I have a blank fresh wiki.
I'm not sure what I did wrong but the bottom line is that I need to restore
from my wiki backup.sql.
However, (next problem) the backup.sql looks a wee bit incomplete. For one
thing it is missing the " ### DATABASE DUMP COMPLETED ###" message at the
end. The good news is that it seems to have the INSERT commands for all of
the tables (ending after a long list of "INSERT INTO `watchlist` VALUES").
However, when I try to restore using phpmyadmin (using the SQL tab and
browsing to the file - hitting GO) I get a "No SQL Query!".
So questions 1 & 2: does it appear that my backup file is incomplete? And if
so, can I add the text to the end to make it appear complete (because it
looks like almost all of it is there). If someone could look at the end of
their mediawiki's dump and tell me what comes after the "INSERT INTO
`watchlist` VALUES", I'd greatly appreciate it.
I also tried to restore from the command line using:
*mysql -u rootuser -prootpw mywiki **< /tmp/__DB__mywiki.sql*
but I get a "Can't create database 'mywiki_db'; database exists"
message no
matter whether I'm trying to restore the database of the original name or a
new blank (no tables) database that I created with a different name.
As you can probably tell, I'm not a real MySQL or mediawiki guru.
: (
If I can make the backup.sql file valid by adding whatever it needs at the
end and figure out the correct procedure for restoring it, I'm assuming I
can make another run at the upgrade.
Thanks in advance to any who take pity on this poor soul.