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(a)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(a)gmail.com> wrote:
On Wed, May 6, 2009 at 4:40 PM, Julien Pedrono <julien(a)pedrono.fr>
wrote:
> Hi,
>
> 2009/5/5 Ekompute .info <ekompute(a)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(a)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(a)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(a)lists.wikimedia.org
> >
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
> >
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l(a)lists.wikimedia.org
>
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
>
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l