Hi Jules, thanks for your information. 170€ per year for your server sounds like a reasonable proposition. Siteground wanted US$99 per month which works out to almost US$1,200. By the way, what is the name of your webhost? May consider it one day, since I am now paying half of what you are paying for my shared hosting and I have reached my 5 domain name limit. I am running a private Mediawiki on my own computer for years and seems like it has less problems.
PM Poon On Fri, May 8, 2009 at 7:08 PM, Julien Pedrono <[email protected]> wrote: > 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 > _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
