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