Procedure

  1. create new subdirectory under blog to hold the mediawiki software
  2. upload mediawiki to #1
  3. run the mediawiki install by pointing a browser to #1
  4. during install point to the old database.  The install will recognize the database needs updated.  Let it do that.
  5. You will need to regenerate LocalSettings.php. After you download it upload it to #1
  6. Dial a browser up to #1. Your install should be working now.  Remember: it is still using the old database though
  7. download Image folder from old mediawiki install and upload it to the new install – this is to transfer the photos from the old install
  8. New database:  I want a unique database not mixed with others so on dreamhost I am forced to create a new subdomain.  
  9. Using the new subdomain of #8 create a new database.  On Dreamhost tends to look like:  mysql.subdomain.yourdomain.com
  10. make a note of the user associated with new database!
  11. If you are going Dreamhost domain to dreamhost domain all you need to do is use the new database HostName.  The DB username has access to whatever database it has been given regardless of what HostName is used.
  12. If you are changing to a different host continue as #11 does not apply.
  13. Ready for transfer of database.  Using PhpMyAdmin export your database with no compression.  The method of import will use BigDump script if your database is big. And too big is not very big with Dreamhost!  If you are going to import using this do not use the Export > Data > Extended Inserts option when you export your existing database.
  14. Make a directory under your install folder called /dump
  15. Get BigDump.php here.   upload BigDump.php to your /dump directory.   The bigdump.php file has instruction on usage in the comments.
  16. upload your database file to /dump directory
  17. point a browser at the /dump directory and run bigdump.php.     
  18. Use phpMyAdmin to verify tables were created and filled by bigdump.php.
  19. delete your old installation and database.  Do any necessary cleanup now or you(I) am likely to forget!

 

Categories: Computing

0 Comments

Leave a Reply

Avatar placeholder

Your email address will not be published. Required fields are marked *