First you need to recover the database, and see if all is in order, before you can be certain of no data loss. To do that, don't only copy the "maqwiki" folder, but I would recommend the whole "/var/lib/mysql" (if that is your mysql data folder).
Once you copy that folder to a different machine, I would then recommend, you copy it to a different path, say "/bak/oldmysql". Then, install a new MySQL in that computer, and check to make sure that everything is working with MySQL (like a basic "select 1", "show databases" etc.). Then, install "Media Wiki 1.93" (make sure it is the same version that you originally had installed) on this computer, and it is better if you can use the same name as you used in your older installation, like "maqwiki". After installing MediaWiki, check out the number of files under "/var/lib/mysql/<db>" (where <db> is to be replaced with the new db-name that you used in the last step. Once inside the folder, you can check if the name / number of files match you backed up folder. Now, I would suggest that you stop MySQL and edit the MySQL config file (usually /etc/my.cnf) and change the "datadir" value to the backed up folder (like "/bak/oldmysql" if you followed my email to the letter). Now, start MySQL. If MySQL comes up cleanly, then you need to run the mysql cli, and check out if you can do basic "select 1" and "show databases" etc. If you're through with all the above, then you need to change MediaWiki should work just fine when you open it in the browser. Good luck on getting your data back. Regards HASSAN On Wed, Sep 15, 2010 at 03:20, George Herbert <george.herb...@gmail.com>wrote: > On Tue, Sep 14, 2010 at 2:04 PM, Uwe Brauer <o...@mat.ucm.es> wrote: > >>>>>> On Tue, 14 Sep 2010 00:38:17 +0200, Platonides > >>>>>> <platoni...@gmail.com> wrote: > > > > > Uwe Brauer wrote: > > >> most of the files are very small in size with the > > >> exception of searchindex.MYD and searchindex.MYI. I > > >> have no idea whether this is "normal". > > > > >> Well I run strings and grep over these files but the > > >> only files with useful information are searchindex.MYD > > >> and searchindey.MYI > > >> > > > > > Your tables will be in InnoDB, with the table files > > > just holding pointers to ibdata1 file. searchindex > > > table is in MyIsam and thus the content is really on > > > those files. > > > > To be honstest I don't understand completely what you ay, > > since I don't know exactly what InnoDB is although I have > > heard the word. > > > > I just found a mysql dump file from another wiki. > > I could succesfully use that dump and later conncect > > wikimedia to that db. There is however a difference this db > > has more .MYD and MYI files for example > > wp_users.MYD > > wp_users.MYI > > > > Etc. > > > > Does this mean that the database from the crashed hard disk > > is may be corrupt, since it has only 1 MYD and 1 MYI > > file???? > > > > > > Is there any way to extract the ASCII text (anything more > > sophisticated than "strings") from > > searchindex.MYD and searchindey.MYI > > > > >> > Look at the Mediawiki logfiles, see if they're > > >> > indicating any database problems. If they are... > > >> > > >> > Log in to the database with the mysql command line > > >> > command and run the command "show tables;" > > sorry my ignorance > > > > You mean > >> mysql -p wikidb > > mysql > show tables > > > > Well it does not return anything also mediawiki connects > > correctly to that database. > > > > I am puzzled > > The "show tables;" command within MySQL has to have the semicolon at > the end, or it doesn't work. > > What are you seeing in the logs that convinces you the connection from > MediaWiki is working properly? > > > -- > -george william herbert > george.herb...@gmail.com > > _______________________________________________ > MediaWiki-l mailing list > MediaWiki-l@lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > _______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
