Thanks Cam, I saw this page too and did attempt this, ultimately it
didn't work. I've wandered off in the direction of Steve's reply which
is similar in many ways but adds a bit.
I haven't given up quite yet, I can restore this VM to a snapshot or
backup. I have another couple of options to get the wiki going again,
this particular thread is about getting the data into a different
machine as I want to actually have it hosted on a server rather than my
workstation which is not always on. Another tack is to go back to
looking at my workstation and fixing what I broke in the upgrade to Hardy.
Last option, get the text out of the dump file and manually re-create,
there are only a dozen or 2 pages. That's the loss of too many geek
points though . . .
Thanks for your reply :-)
Roger
Cam Mckenzie wrote:
mysql -u sadmin -p PASSWORD DB_NAME_TO_OVERWRITE < YOURSQLFILE.sql
A quick google turns up
http://www.devshed.com/c/a/MySQL/Backing-up-and-restoring-your-MySQL-Database/
2008/5/30 Roger Searle <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>>:
Hi, I have a HH machine running in vmware that has mediawiki
freshly installed and configured, I can browse to the main page of
the wiki and could begin creating articles etc. I have a mysql
backup of a wiki that I had previously when running Gutsy (which
broke on upgrading to Hardy). I created this using the mysql
administrator tool - creates a .sql dump file that I am now
wanting to restore and replace the database of the freshly
installed wiki.
I can use the MySQL Administrator tool's Restore Backup function
to do a restore, however I am lost at the point of understanding
where this restored database has gone, but more importantly how to
replace the database of the freshly installed wiki and therefore
see the previously created articles. Any pointers on where to
look or how to go about such a process would be greatly appreciated.
Cheers,
Roger
