Hi Jule, thank you very much for your response.
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.
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(a)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(a)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(a)gmail.com>
wrote:
>
> >
> >
> > On Wed, May 6, 2009 at 4:40 PM, Julien Pedrono <julien(a)pedrono.fr>
> wrote:
> >
> >> Hi,
> >>
> >> 2009/5/5 Ekompute .info <ekompute(a)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(a)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(a)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(a)lists.wikimedia.org
> > > >
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
> > > >
> > > _______________________________________________
> > > MediaWiki-l mailing list
> > > MediaWiki-l(a)lists.wikimedia.org
> > >
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
> > >
> > _______________________________________________
> > MediaWiki-l mailing list
> > MediaWiki-l(a)lists.wikimedia.org
> >
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
> >
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l(a)lists.wikimedia.org
>
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
>
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l