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
