Hi Jule, thank you very much for your response. I suppose there will be thousands of people using InnoDB databases on the same mysql server. I will try to get my webhost to do it for me then.
By the way, just as an aside, I am wondering how to afford a dedicated server. It's so much more expensive and running the server from my computer is not a feasible proposition for me. PM Poon On Thu, May 7, 2009 at 11:00 PM, Julien Pedrono <[email protected]> wrote: > Hi, > Sorry for misunderstanding, I thought you were using and administrating > your > own server... > You can ask your hosting company support to look for a problem with thoses > tables, as they have direct access on their servers. > When I encountered my problem, I remember I created my wiki database again > (empty, then), I imported my SQL dump and I copied my backed up ibdata* and > ib_logfile* instead of the one used by mysql on my server... This is easy > only if you are the only database to use the InnoDB engine, I have no clue > if there are many InnoDB databases on the same mysql server... > Hope it help. > Regards > > Jules > > 2009/5/6 Ekompute .info <[email protected]> > > > Hi, ssh access? No idea what it is, but if you tell me, I may be able to > > ask > > my webhost to help me. Maiahost.com has been very helpful all these > while, > > unlike my previous one and I am quite confident they will be very willing > > to > > help if they know how. > > > > PM Poon > > > > On Wed, May 6, 2009 at 5:31 PM, Ekompute .info <[email protected]> > wrote: > > > > > > > > > > > On Wed, May 6, 2009 at 4:40 PM, Julien Pedrono <[email protected]> > > wrote: > > > > > >> Hi, > > >> > > >> 2009/5/5 Ekompute .info <[email protected]> > > >> > > >> > Hi, I backed up the table using phpMyAdmin. > > >> > > >> So you had some .sql files as a result... > > >> I had such a problem a few months ago: > > >> - my server crashed > > >> - I managed to access it in rescue, and to back up my databases (mysql > > >> dump > > >> and a backup of /var/lib/mysql/wiki/*). > > >> - when I restored my server, and my databases (with a mysql import of > my > > >> sql > > >> backups, I couldn't access my wiki tables correctly, this trouble was > > >> linked > > >> with the use of InnoDB engine (this engine uses files in your database > > >> directory under /var/lib/mysql AND some files in /var/lib/mysql/, > > ibdata*, > > >> ib_logfile*) but I can't remember the messages I got at this time... > > >> > > >> > > >> > Does it mean that I cannot > > >> > import? Guess I need to delete them then, since they are occupying > > quite > > >> a > > >> > lot of space. By the way, I am using 1.14 and it is still using > > InnoDB. > > >> > > >> Do you have a ssh access on your server? > > >> > > >> > > >> > > >> > > > >> > > > >> > PM Poon > > >> > > > >> > On Tue, May 5, 2009 at 11:41 PM, Julien Pedrono <[email protected]> > > >> wrote: > > >> > > > >> > > Hi, > > >> > > > > >> > > Did you backed up your tables using mysqldump, or a tool such as > > >> > > phpMyAdmin? > > >> > > Following my own experience, and because wiki tables use InnoDB > (at > > >> least > > >> > > 'till 1.12), importing tables can lead to data access problems. > > >> > > > > >> > > Jules > > >> > > > > >> > > 2009/5/5 Michael Daly <[email protected]> > > >> > > > > >> > > > Ekompute .info wrote: > > >> > > > > Hi, I backed up two tables (category, and categorylinks) from > my > > >> > > database > > >> > > > > and export it into another. Both wikis uses the same Mediawiki > > >> > Version > > >> > > > 1.14. > > >> > > > > Although I do see that the two tables are uploaded, I cannot > > >> access > > >> > > them. > > >> > > > Is > > >> > > > > there something that I miss? > > >> > > > > > >> > > > Do the tables have the same prefix? > > >> > > > > > >> > > > > > >> > > > _______________________________________________ > > >> > > > MediaWiki-l mailing list > > >> > > > [email protected] > > >> > > > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > > >> > > > > > >> > > _______________________________________________ > > >> > > MediaWiki-l mailing list > > >> > > [email protected] > > >> > > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > > >> > > > > >> > _______________________________________________ > > >> > MediaWiki-l mailing list > > >> > [email protected] > > >> > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > > >> > > > >> _______________________________________________ > > >> MediaWiki-l mailing list > > >> [email protected] > > >> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > > >> > > > > > > > > _______________________________________________ > > MediaWiki-l mailing list > > [email protected] > > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > > > _______________________________________________ > MediaWiki-l mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
