The web hosting company i'm with now has the ability to upgrade my wiki software, but i'm hesitant to do so because it might kill my content. I would be upgrading from the media wiki 1.6 to 1.16 version. What files would I need to backup on the database and once done do I need to reinsert those files into the database or should the files in the database carry over? Have several pages already created for the wiki site and hate to think about recreating every single page.
On Sat, Oct 23, 2010 at 12:32 PM, Christopher Eicher predx97@gmail.com wrote:
I would be upgrading from the media wiki 1.6 to 1.16 version.
Make sure your host has PHP 5 (rather than PHP 4).
What files would I need to backup on the database and once done do I need to reinsert those files into the database or should the files in the database carry over?
You should back up your entire database.[0] For the sake of simplicity, you should also back up the entire wiki directory. If the upgrade goes smoothly, you will not need to re-import your backup.
Yup I have full control over what version of PHP my database uses currently. Set it to PHP5 after a problem with the media wiki software and left it at PHP5. How would I backup the entire Wiki Directory? Usually i'll just go into the phpadmin code for the database linked to the media wiki and select all the files then create a zip file with all the files to make the wiki work zipped up in it. After that i'll just download the zip file and keep it stored away on my computer.
On Sat, Oct 23, 2010 at 5:23 PM, Benjamin Lees emufarmers@gmail.com wrote:
On Sat, Oct 23, 2010 at 12:32 PM, Christopher Eicher predx97@gmail.com wrote:
I would be upgrading from the media wiki 1.6 to 1.16 version.
Make sure your host has PHP 5 (rather than PHP 4).
What files would I need to backup on the database and once done do I need to
reinsert
those files into the database or should the files in the database carry over?
You should back up your entire database.[0] For the sake of simplicity, you should also back up the entire wiki directory. If the upgrade goes smoothly, you will not need to re-import your backup.
[0] http://www.mediawiki.org/wiki/Manual:Backing_up_a_wiki
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
On Sat, Oct 23, 2010 at 11:11 PM, Christopher Eicher predx97@gmail.com wrote:
How would I backup the entire Wiki Directory?
You should be able to use whichever method you used to upload the wiki files in the first place. That's probably your FTP client, if you have one, or else a file manager Web interface.
Usually i'll just go into the phpadmin code for the database linked to the media wiki and select all the files then create a zip file with all the files to make the wiki work zipped up in it. After that i'll just download the zip file and keep it stored away on my computer.
When you say "files", you're referring to the database tables, right?
Unfortunately it will be a moot point now the upgrade installer the company i'm with kinda...screwed up. Even though I had a small backup area of the 1.6.5 wiki files and backed up the wiki database prior to upgrading it still fouled up some how. Now I get an error stating it has a problem with an unknown column in the user_edits area and can't find the column nor do I know where to go to fix it.
Is there any way to find the wiki pages within the database backup and put them into the new Wiki? What database table are the wiki files stored on so I can delete that file from the test DB then upload to see if I can reclaim what I lost. Only good thing that's come out of this is the software is now up to date being 1.16 so I can use template files atleast.
On Sun, Oct 24, 2010 at 6:38 PM, Benjamin Lees emufarmers@gmail.com wrote:
On Sat, Oct 23, 2010 at 11:11 PM, Christopher Eicher predx97@gmail.com wrote:
How would I backup the entire Wiki Directory?
You should be able to use whichever method you used to upload the wiki files in the first place. That's probably your FTP client, if you have one, or else a file manager Web interface.
Usually i'll just go into the phpadmin code for the database linked to the media wiki and select all the files then create a zip file with all the files
to
make the wiki work zipped up in it. After that i'll just download the
zip
file and keep it stored away on my computer.
When you say "files", you're referring to the database tables, right?
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
On Tue, Oct 26, 2010 at 8:58 AM, Christopher Eicher predx97@gmail.com wrote:
Unfortunately it will be a moot point now the upgrade installer the company i'm with kinda...screwed up. Even though I had a small backup area of the 1.6.5 wiki files and backed up the wiki database prior to upgrading it still fouled up some how. Now I get an error stating it has a problem with an unknown column in the user_edits area and can't find the column nor do I know where to go to fix it.
Have you run the update script yet?
When you press the upgrade button it initiates a command which takes care of everything including the update script. So really there's nothing to do or that can be done unfortunately.
On Mon, Oct 25, 2010 at 7:28 PM, K. Peachey p858snake@yahoo.com.au wrote:
On Tue, Oct 26, 2010 at 8:58 AM, Christopher Eicher predx97@gmail.com wrote:
Unfortunately it will be a moot point now the upgrade installer the
company
i'm with kinda...screwed up. Even though I had a small backup area of
the
1.6.5 wiki files and backed up the wiki database prior to upgrading it
still
fouled up some how. Now I get an error stating it has a problem with an unknown column in the user_edits area and can't find the column nor do I know where to go to fix it.
Have you run the update script yet?
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Hi Christopher,
When you press the upgrade button it initiates a command which takes care of everything including the update script. So really there's nothing to do or that can be done unfortunately.
You could install your old MediaWiki version (http://download.wikimedia.org/mediawiki/) locally, for example using XAMPP (http://www.apachefriends.org/en/xampp.html ).
Then use your saved database, upgrade locally to the current version of MediaWiki, do a database backup of that version (for example with MySQLDumper, http://www.mysqldumper.net) and migrate it to your production site.
hth Frank
Is there any program that can access the wiki page files directly and extract them putting them onto the new wiki site? Would want to save this way as a sort of last resort due to the time and energy involved with it.
On Tue, Oct 26, 2010 at 5:12 AM, Frank Ralf Frank.Ralf@gmx.net wrote:
Hi Christopher,
When you press the upgrade button it initiates a command which takes care
of
everything including the update script. So really there's nothing to do
or
that can be done unfortunately.
You could install your old MediaWiki version ( http://download.wikimedia.org/mediawiki/) locally, for example using XAMPP (http://www.apachefriends.org/en/xampp.html ).
Then use your saved database, upgrade locally to the current version of MediaWiki, do a database backup of that version (for example with MySQLDumper, http://www.mysqldumper.net) and migrate it to your production site.
hth Frank
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Is there any program that can access the wiki page files directly and extract them putting them onto the new wiki site? Would want to save this way as a sort of last resort due to the time and energy involved with it.
If you really want to go this route, see http://www.mediawiki.org/wiki/Manual:Database_layout and http://www.mediawiki.org/wiki/Manual:Page_table
But as this is a relational database with lots of interdependencies this might not be a feasible way to go.
You can use phpMyAdmin (http://www.phpmyadmin.net ) for direct manipulation of database tables.
If I went with phpMyAdmin for direct manipulation of the database tables what table specifically would contain the information I need? Sadly I have a feeling i'm miss understanding what I can do here. I'm thinking that I can open up one of the tables and there will be the coding like page name, with all of the coding for each individual page that I can then extract copying/pasting the information into a text document. After that I could just recreate each page on the wiki copying/pasting the information from the text document. However I doubt that's exactly what I can do and that just isn't possible.
On Tue, Oct 26, 2010 at 9:09 AM, Frank Ralf Frank.Ralf@gmx.net wrote:
Is there any program that can access the wiki page files directly and extract them putting them onto the new wiki site? Would want to save
this
way as a sort of last resort due to the time and energy involved with it.
If you really want to go this route, see http://www.mediawiki.org/wiki/Manual:Database_layout and http://www.mediawiki.org/wiki/Manual:Page_table
But as this is a relational database with lots of interdependencies this might not be a feasible way to go.
You can use phpMyAdmin (http://www.phpmyadmin.net ) for direct manipulation of database tables.
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
If I went with phpMyAdmin for direct manipulation of the database tables what table specifically would contain the information I need?
RTFM (Read the fine manual):
"The page table can be considered the "core of the wiki". Each page in a MediaWiki installation has an entry here which identifies it by title and contains some essential metadata."
"The text of the page itself is stored in the text table. To retrieve the text of an article, MediaWiki first searches for page_title in this table. Then, page_latest is used to search the revision table for rev_id, and rev_text_id is obtained in the process. The value obtained for rev_text_id is used to search for old_id in the text table to retrieve the text." http://www.mediawiki.org/wiki/Manual:Page_table
mediawiki-l@lists.wikimedia.org