User:Wanglong/Mw tools

Web based management, backup and recovery for mediawiki (unofficial).

This backup and Recover are composed of two parts: Download and safekeeping all the backup.
 * 1) Database Backup: use the mw_tools to backup the Database from your Database Server.
 * 2) Back up the website Program(include the images folder):Use FTP tools download all the folder on your webserver.

MW-TOOL allows anyone full accessed to your wiki database, including private information like email addresses and password hashes, and including the ability to overwrite your database! These is no protection whatsoever. You must yourself take measures to protect MW-TOOL from unauthorized access, e.g. by using http-authentication to password-protect the directory (basic instructions).

This is very dangerous to use unless you know exactly that you can effectively prevent unauthorized access!

Download

 * 1) Download from here:  http://www.allwiki.com/download/mw_tools.zip
 * 2) Make a directory: On your wiki server, you shold make a directory where your Localsettings.php exist. For example, if you have /mw10/Localsettings.php, you should make a directory like /mw10/your-mw-tool(your-mw-tool may be any of you like) 
 * 3) Extract and FTP: extract all files in the zip, FTP them to your tool directory.

Backup
Copy or Upload the mw_tools in your Mediawiki install path.


 * change the 'mw_tools/templates_c' folder permission to '777'
 * change the 'mw_tools/backup/backup_files' folder permission to '777'

And type the URL in your browser like this:

www.xxxwiki.com/wikipath/mw_tools/login.php (The xxxwiki is your domain name, wikipath is the path you install your Mediawiki.) The browser should display like this:



This is choose language, click 'English',you will see:



Click System Tools at the top of the page ,and then click the Backup in the left,you will see the backup function:



Click the 'Start backup' in the bottom, according to the size of database ,about 10MB per second ,every database table will be a file.



you can see the backup is success, download the backup in the prompt path, safekeeping the backup ,use it when need to do the recover.

Recover
attention：
 * 1) Recover process will read the set of Mediawiki`s LocalSettings.php ,and link to the database to recover the database, if there is some table have the same name with the backup tables ,the old table will be dropped.


 * 1) $wgDBprefix in the LocalSettings.php must equal to the backup` table prefix. Otherwise, the recover maybe failed.

Upload the backup to the 'mw_tools\backup\backup_files' on the Webserver. sure about the files and path after you upload is like this mw_tools\backup\backup_files\2008-02-20-16-03-38_grlgos\AllTableStructure.sql

mw_tools\backup\backup_files\2008-02-20-16-03-38_grlgos\allwiki_archive

mw_tools\backup\backup_files\2008-02-20-16-03-38_grlgos\allwiki_blobs

mw_tools\backup\backup_files\2008-02-20-16-03-38_grlgos\allwiki_brokenlinks ...... Click the 'Recover' in the left, the program will read the backup files in 'backup_files' folder and display the information about the backup.display like this:



Choose the backup you want to recover,click the 'import', the recover start. The time recover process cost lie on the size of your database size. On my server, 1M data will cost 0.74 second.

After import the backup, it will display like this:



Other infomation
if you want see more : you can viste http://www.allwiki.com/wiki/Allwiki%27s_Mediawiki_Backup_And_Recover%EF%BC%88EN%EF%BC%89

Programer:--Wanglong 02:06, 11 March 2008 (UTC) ,this is the first program I write for mediawiki! If you have any problems,you can write your question or suggest to my discussion page :User_talk:Wanglong.