Difference between revisions of "BackupInstructions"
From PLplotWiki
m |
m |
||
| Line 9: | Line 9: | ||
* Ensure that the SQL button is selected too. | * 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' | * 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 | + | * 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. | * Tick the 'Save as file' option, and leave the template name alone. | ||
* 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. | ||
Revision as of 04:41, 3 October 2006
- Go to [1], login and choose the plplot_wiki database.
Settings
- 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.
