User Tools

Site Tools


wackowikir3tor4migration

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
wackowikir3tor4migration [2011/12/28 16:43]
127.0.0.1 external edit
wackowikir3tor4migration [2013/01/30 17:53] (current)
Line 1: Line 1:
-WikiWikiWeb > [[WackoWiki]]+Here is what I did to migrate ​[[WackoWiki]] ​from R3 to R4 (in 2004).
  
-Here is what I did to migrate from R3 to R4. +===== R4 installation ​=====
- +
- +
-== R4 installation ==+
  
 Download R4 at http://​wackowiki.com/​files/​wacko.r4.tar.gz Download R4 at http://​wackowiki.com/​files/​wacko.r4.tar.gz
  
 Then I detarred it in /​var/​www/​wackoR4/​ Then I detarred it in /​var/​www/​wackoR4/​
-I pointed my browser to http://​callendor.zongo.be/​wackR4/​ and followed the instruction for the setup (kept the same database, user, but changed the table prefix to _wakkaR4). 
  
 +I pointed my browser to http://​zongo.be/​wackoR4/​ and followed the instructions for the setup (kept the same database, user, but changed the table prefix to wakkaR4_).
  
-== Data migration ==+ 
 +===== Data migration ​=====
  
 First I dumped all R3-related tables into a .sql text file (make sure you take complete inserts as there are some new rows in a couple of tables). I did this with phpmyadmin. First I dumped all R3-related tables into a .sql text file (make sure you take complete inserts as there are some new rows in a couple of tables). I did this with phpmyadmin.
-Then I replaced all the "_wacko" (might be "_wakka" for you) with "_wakkaR4" ​usinga ​text editor. In (([[vi]])), it is:+ 
 +Then I replaced all the "wacko_" (might be "wakka_" for you) with "wakkaR4_" ​using a text editor. In [[vi]], it is:
 <​code>:​%s/​wacko_/​wakkaR4_/​g</​code>​ <​code>:​%s/​wacko_/​wakkaR4_/​g</​code>​
 and saved as ~/​wackoR4_migration.sql and saved as ~/​wackoR4_migration.sql
 +
 Then I typed the following at the command line interface: Then I typed the following at the command line interface:
 <​code>​mysql -u root -p wakka < ~/​wackoR4_migration.sql</​code>​ <​code>​mysql -u root -p wakka < ~/​wackoR4_migration.sql</​code>​
 So, the Wiki was running ok with old data and new version R4. So, the Wiki was running ok with old data and new version R4.
  
 +===== Webserver configuration =====
  
-== Webserver configuration == +Still, I have to change the URL, but since I am lazy, I put the following rewrite rule in my Apache config file (/​etc/​apache/​httpd.conf) in the ~VirtualHost section concerning zongo.be:
- +
-Still, I have to change the URL, but since I am lazy, I put the following rewrite rule in my Apache config file (/​etc/​apache/​httpd.conf) in the ~VirtualHost section concerning ​callendor.zongo.be:+
 <​code>​RewriteEngine On <​code>​RewriteEngine On
 RewriteRule /wacko/(.+) /wackoR4/$1 [R]</​code>​ RewriteRule /wacko/(.+) /wackoR4/$1 [R]</​code>​
wackowikir3tor4migration.txt · Last modified: 2013/01/30 17:53 (external edit)