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