Difference between revisions of "BackupInstructions"

From PLplotWiki
Jump to: navigation, search
m
Line 1: Line 1:
* Go to [http://mysql.miscdebris.net], login and choose the plplot_wiki database.
+
* Go to http://mysql.miscdebris.net, login and choose the plplot_wiki database.
  
 
== Settings ==
 
== Settings ==
Line 13: Line 13:
 
* For now, select 'None' for compression.
 
* For now, select 'None' for compression.
 
* Now click 'Go' and you should be prompted for a file to download.
 
* Now click 'Go' and you should be prompted for a file to download.
 +
 +
These instructions are taken from these two sources:
 +
* http://codex.wordpress.org/Backing_up_your_database
 +
* http://meta.wikimedia.org/wiki/How_to_move_a_MediaWiki_Database

Revision as of 05:42, 3 October 2006

Settings

Mediawiki backup.png

  • Click the 'Export' tab on the top set of tabs.
  • Look at the left box at the top of the Export section. Choose only those tables that correspond to the plplot_wiki database (i.e. all tables with a "plwiki" prefix.
  • Ensure that the SQL button is selected too.
  • Tick the following boxes in the SQL section: Structure, 'Add DROP TABLE', 'Add AUTO_INCREMENT' and 'Enclose table and field names with backquotes'
  • Also tick the Data box and in the Data section 'Use hexadecimal for binary fields'.
  • Tick the 'Save as file' option, and leave the template name alone.
  • For now, select 'None' for compression.
  • Now click 'Go' and you should be prompted for a file to download.

These instructions are taken from these two sources: