ISFDB:How To Create a Public Backup File

The following steps will let you create a publicly available ISFDB backup file on a Windows-based development server.

1. Download the latest compressed backup file from the live ISFDB server to your development server. You will need a live server account with sufficient privileges to do this.
2. Unzip the backup file using a standard unzip program.
3. Install MySQL 5.5 on your development server.
4. Start your MySQL instance.
5. Run the following MySQL commands in order to restore the database from the backup:
   • drop database isfdb;
   • create database isfdb;
   • connect isfdb;
   • source C:/ISFDB/Backups/dbdump; [where C:/ISFDB/Backups is the drive/directory where you put the unzipped ISFDB backup file]
6. Run the following commands in order to delete private data:
   • drop table mw_archive;
   • drop table mw_blobs;
   • drop table mw_brokenlinks;
   • drop table mw_categorylinks;
   • drop table mw_cur;
   • drop table mw_externallinks;
   • drop table mw_hitcounter;
   • drop table mw_filearchive;
   • drop table mw_image;
   • drop table mw_imagelinks;
   • drop table mw_interwiki;
   • drop table mw_ipblocks;
   • drop table mw_ipblocks_old;
   • drop table mw_job;
   • drop table mw_langlinks;
   • drop table mw_links;
   • drop table mw_linkscc;
   • drop table mw_logging;
   • drop table mw_math;
   • drop table mw_objectcache;
   • drop table mw_oldimage;
   • drop table mw_page;
   • drop table mw_page_restrictions;
   • drop table mw_pagelinks;
   • drop table mw_protected_titles;
   • drop table mw_querycache_info;
   • drop table mw_querycache;
   • drop table mw_querycachetwo;
   • drop table mw_recentchanges;
   • drop table mw_redirect;
   • drop table mw_revision;
   • drop table mw_searchindex;
   • drop table mw_site_stats;
   • drop table mw_templatelinks;
   • drop table mw_text;
   • drop table mw_trackbacks;
   • drop table mw_transcache;
   • drop table mw_user_newtalk;
   • drop table mw_user_rights;
   • drop table mw_validate;
   • drop table mw_watchlist;
   • delete from license_keys;
   • delete from submissions;
   • update mw_user set user_email=,user_real_name=,user_password=,user_newpassword=,user_options=,user_touched=,user_token=,user_email_authenticated=NULL,user_email_token=NULL,user_email_token_expires=NULL,user_registration=NULL,user_newpass_time=NULL,user_editcount=NULL;
   • delete from mw_user_groups;
   • delete from votes;
   • delete from user_sites;
   • delete from user_preferences;
   • delete from user_languages;
7. Run the following command to create a MySQL 4.0-compatible backup file (substitute the location of your MySQL directory and your MySQL password as needed):
   • "C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqldump" --password=XXX --user=root --compatible=mysql40 isfdb > C:\ISFDB\Backups\backup-MySQL-40-YYYY-MM-DD
8. Run the following command to create a MySQL 5.5-compatible backup file (substitute the location of your MySQL directory and your MySQL password as needed):
   • "C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqldump" --password=XXX --user=root isfdb > C:\ISFDB\Backups\backup-MySQL-55-YYYY-MM-DD
9. Zip up the backup files and upload them to an internet location where they can be accessed