- Drag this link into your bookmarks bar: [Flexible search CSV export bookmarklet](javascript:function addCsvDownloadLink(){console.log("Adding download link"),$("#queryResultTable_length").append(' <a id="csvDownloadLink" href="#" class="export">Download as CSV</a>'),console.log("Modifying link behaviour"),$("#csvDownloadLink").click(function(){var n=$("#queryResultTable"),o=exportTableToCsvString(n),t="data:application/csv;charset=utf-8,"+encodeURIComponent(o);$(this).attr({download:"flexibleSearch.csv",href:t,target:"_blank"})}),console.log("CSV ready for download")}function exportTableToCsvString(n){var o=tableToData(n);return dataToCsvString(o)}function tableToData(n){var o=n.find("thead").find("tr"),t=n.find("tbody").find("tr"),a=o.map(trRowToArray).get(),r=t.map(trRowToArray).get();return r.unshift(a[0]),r}function trRowToArray(n,o)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
version: '3.7' | |
services: | |
db: | |
image: mysql:5.7 | |
restart: "unless-stopped" | |
ports: | |
- 3306:3306 | |
# uncomment the volume mount to import .sql files | |
# during database initalization | |
# volumes: |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Backup | |
docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql | |
# Restore | |
cat backup.sql | docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE | |