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?
PM Poon
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?
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
Hi, I backed up the table using phpMyAdmin. 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.
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
Hi Michael, I don't use prefix as I am already having a problem of database getting too big for shared hosting (not so much of space usage but more of downloading and uploading backups) and am thinking of splitting them as you can see from my other thread.
PM Poon
On Wed, May 6, 2009 at 2:27 AM, Ekompute .info ekompute@gmail.com wrote:
Hi, I backed up the table using phpMyAdmin. 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.
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
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
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
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
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
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.
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
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
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 julien@pedrono.fr wrote:
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
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
mediawiki-l@lists.wikimedia.org