System Database
Backup SQL tables, perform DB maintenance, export configurations as text files or other tables as CSV files. By default the complete DB structure including number of records is shown:
- Quickly view (the first 1000) entries of a table by clicking on the
, if shown
- Optimize a table with
or repair with 
- Delete all records with
Execute
- Select a query from the "--DB List-- selectbox. Entries begin with simple SELECT statements to display entire tables, but also contain maintenance tasks towards the bottom
- "Configuration Backup" simply adds a query to select all configs, but creates a downloadable gzip archive as well
- All other select statements list the respective table contents, which can be displayed as CSV (with destination set to "plain")
changes IP addresses and timestamps to a human readable format and adds a timestamp to the archive name, if destination is Gzip or Bzip2
- Bzip2 needs more resources, but generally creates smaller archives.
- Depending on the amount of data you're dealing with, the module requires more memory or time to finish processing!
SQL Dump
- Select (hold down CTRL for multiple) tables to be exported in SQL format
- The resulting file can be imported again via System-Files, if Destination was set to Gzip
NeDi Help