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 <[email protected]> wrote: > > > 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
