User:Wanglong/Mw tools

Start
The 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.

Download
You can down load from here:  http://www.allwiki.com/download/mw_tools.zip

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:



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.