2009/5/8 Ekompute .info ekompute@gmail.com
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 julien@pedrono.fr 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 ekompute@gmail.com
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 ekompute@gmail.com
wrote:
On Wed, May 6, 2009 at 4:40 PM, Julien Pedrono julien@pedrono.fr
wrote:
Hi,
2009/5/5 Ekompute .info ekompute@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@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@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@lists.wikimedia.org > > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > > > _______________________________________________ > MediaWiki-l mailing list > MediaWiki-l@lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > _______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l