2009/5/8 Ekompute .info <[email protected]> > Hi Jule, thank you very much for your response.
You're welcome, hope it helps. > I suppose there will be > thousands of people using InnoDB databases on the same mysql server. I will > try to get my webhost to do it for me then. If the problem is the same I had, it's your only solution ;) > By the way, just as an aside, I am wondering how to afford a dedicated > server. It's so much more expensive and running the server from my computer > is not a feasible proposition for me. Nearly any webhost is able to rent you a full dedicated server, or a dedicated server with a certain amount of network disk, or a virtual dedicated server... Price depends on support quality, most of the time, and on used bandwidth. For instance I pay something like 170€ per year for my server, with a 20Gb dedicated space on a disk array, and illimited bandwitdh... which is really enough to host somes websites (between 10 and 20 in my case). The point is you have to know sysadmin good enough to manage your server by yourself (from system configuration to web server configuration, let's say), and you must have a TSE access (for windows) or SSH access (linux) to reach it. Regards. Jules > > > PM Poon > > On Thu, May 7, 2009 at 11:00 PM, Julien Pedrono <[email protected]> wrote: > > > 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 <[email protected]> > > > > > 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 > > > > > _______________________________________________ > > 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
