This might be relevant, I don't know:
When I moved my database (named "wiki") to the new location I renamed
the new one that had been created when I reinstalled MediaWiki, from
"wiki" to "wiki-temp" and put the old one in place.
Christiaan
On 13 Sep 2005, at 10:27 pm, Christiaan Briggs wrote:
On 13 Sep 2005, at 8:50 pm, Jamie Bliss wrote:
You really messed it up.
Yup. Thanks for your help.
BTW, I hope you backed up before beginning this
project.
Well, no, but not for lack of trying. I had just finished getting
our new backup system running: 3x 100 GB portable hard disks on
rotation backing up all production data each day from the server
and everyone's home folders from their machines. Problem is
somewhere along the line I dropped the script out of Retrospect
that backed up relevant intranet files, and although I run my own
blog and religiously fetch a dump of my database every time I add a
post, for some reason I just didn't backup our MySQL database at
work. Being an amateur (my real job is drawing buildings) you tend
to learn these things the hard way. :(
(At the moment I'm comforting myself with the fact that if all else
fails I can at least open the database files up in a text editor
and extract the text)
Basically, shutdown MySQL. Either move the files
to the current DB
location or change the location to match them. Start MySQL and
make sure that went ok.
Okay, I can now view the database in phpMyAdmin, however somethings
not quite right as it says all the tables are in use and when I try
to look at any given table is says it can't find it:
e.g. MySQL said: #1017 - Can't find file: './wiki/cur.frm' (errno: 13)
Create AdminSettings.php, according to the
template. Then run
maintenance/update.php from the command-line (doesn't work on
HTTP!) to upgrade the DB schema. Depending on the size of the
wiki, this may take some time.
I created AdminSettings.php and ran the script, however this is
what I got (related to above, as in something's pointing to the
wrong place?):
>
Server:/Library/WebServer/Documents/wiki/maintenance root# php
> update.php
> Going to run database updates for wiki
> Depending on the size of your database this may take a while!
> Abort with control-c in the next five seconds to aboard.. 0
> Creating linkscc table...ok
> Creating hitcounter table...A database error has occurred
> Query: CREATE TABLE hitcounter ( hc_id INTEGER UNSIGNED NOT
> NULL ) TYPE=HEAP MAX_ROWS=25000
> Function:
> Error: 1050 Table 'hitcounter' already exists (localhost)
>
> Backtrace:
> GlobalFunctions.php line 524 calls wfbacktrace()
> Database.php line 383 calls wfdebugdiebacktrace()
> Database.php line 333 calls database::reportqueryerror()
> install-utils.inc line 118 calls database::query()
> updaters.inc line 44 calls dbsource()
> updaters.inc line 195 calls add_table()
> update.php line 26 calls do_all_updates()
>
I'm assuming you're going to tell me to put it back in the original
directory and to get MySQL up and running using the old directory.
I'm dreading that; I was winging it just to get MySQL and PHP
talking to each other as it is (using someone else's step-by-step
instructions).
Thanks again,
Christiaan
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)Wikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l