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 julien@pedrono.fr 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 ekompute@gmail.com
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 ekompute@gmail.com
wrote:
On Wed, May 6, 2009 at 4:40 PM, Julien Pedrono julien@pedrono.fr
wrote:
Hi,
2009/5/5 Ekompute .info ekompute@gmail.com
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 julien@pedrono.fr
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 michael.daly@kayakwiki.org
> 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 > 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
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
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