[Mediawiki-l] [SPAM] Re: Importing MySQL tables

[Julien Pedrono]

Hi,

2009/5/5 Ekompute .info <ekompute at 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 at 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 at 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 at lists.wikimedia.org
> > > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
> > >
> > _______________________________________________
> > MediaWiki-l mailing list
> > MediaWiki-l at lists.wikimedia.org
> > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
> >
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l at lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
>