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@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l