Hi everyone,
I'd like to upgrade from 1.3.1 to 1.3.9 on our internal network. First I backup the database : mysqldump -u root -p wikidb > wiki.db
Then, I follow the normal setup of a fresh install of mediawiki 1.3.9
When I want to restore my old data : cat wiki.db | mysql -u root -p wikidb this tells me : "ERROR 1050 at line 11: Table 'archive' already exists"
Indeed, the definition of the table 'archive' seems to be at line 11 of file wiki.db, and I guess that the fresh install of mediawiki already created such a table.
So my question would be : how do i get my old data back into my new install of mediawiki ?
Thank's for any help.
I've been looking through the pages : http://meta.wikimedia.org/wiki/How_to_become_a_MediaWiki_hacker http://fr.wikipedia.org/wiki/Wikip%C3%A9dia:Installation_du_logiciel .... but i could not get any information on this problem.
You only need to dump the db for backup purpose only, don't import it back after upgrade. For ugrading, what you need it: - Copy the new files over your installation - Run #php maintenance/upgrade.php if necessary Chinh
On Mon, 03 Jan 2005 11:29:50 +0100, François Van Der Biest francois.vanderbiest@loa.espci.fr wrote:
Hi everyone,
I'd like to upgrade from 1.3.1 to 1.3.9 on our internal network. First I backup the database : mysqldump -u root -p wikidb > wiki.db
Then, I follow the normal setup of a fresh install of mediawiki 1.3.9
When I want to restore my old data : cat wiki.db | mysql -u root -p wikidb this tells me : "ERROR 1050 at line 11: Table 'archive' already exists"
Indeed, the definition of the table 'archive' seems to be at line 11 of file wiki.db, and I guess that the fresh install of mediawiki already created such a table.
So my question would be : how do i get my old data back into my new install of mediawiki ?
Thank's for any help.
I've been looking through the pages : http://meta.wikimedia.org/wiki/How_to_become_a_MediaWiki_hacker http://fr.wikipedia.org/wiki/Wikip%C3%A9dia:Installation_du_logiciel .... but i could not get any information on this problem. _______________________________________________ MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Quoting Fran?ois Van Der Biest, from the post of Mon, 03 Jan:
When I want to restore my old data : cat wiki.db | mysql -u root -p wikidb this tells me : "ERROR 1050 at line 11: Table 'archive' already exists"
this is reqally a mysql qeustions. the dump is really a script that creates the databases, the tables and finally the rows. it assumes you are running with an empty DB. if you don't want to assume that you can tell it during the dump to create the sql script with "drop table" before each creation, and thus you won't get stuck with tables that already exist. man mysqldump, this is how I create a daily backup:
mysqldump -A -a -e --add-drop-table --add-locks \ -F -q --password='**********'| \ gzip -c --rsyncable > dailyDump.sql.gz
So my question would be : how do i get my old data back into my new install of mediawiki ?
how about leaving it on the DB untouched and upgrade according to the README?
mediawiki-l@lists.wikimedia.org