How to backup the wiki

 
Line 1: Line 1:
-
* Go to the [https://sourceforge.net/p/supertuxkart/admin/ext/mysql/ database admin page], and from there you can access the online MySQL interface
 
-
* From the "Export" tab there, download the database (SQL format should be fine)
 
-
 
* Connect to sourceforge to backup the files
* Connect to sourceforge to backup the files
** ssh -t USER,supertuxkart@shell.sourceforge.net create
** ssh -t USER,supertuxkart@shell.sourceforge.net create
Line 9: Line 6:
** rm htdocs.zip
** rm htdocs.zip
** mysqldump --all-databases --user=''(stk database admin username)'' --password=''(stk database admin password)'' --host=mysql-s > database_dump.sql
** mysqldump --all-databases --user=''(stk database admin username)'' --password=''(stk database admin password)'' --host=mysql-s > database_dump.sql
 +
** (See [https://sourceforge.net/p/supertuxkart/admin/ext/mysql/ database admin page] for database access info)
** zip database_dump.sql.zip database_dump.sql
** zip database_dump.sql.zip database_dump.sql
** (in a local terminal) scp USER,supertuxkart@web.sourceforge.net:database_dump.sql.zip ~/Desktop/database_dump.sql.zip
** (in a local terminal) scp USER,supertuxkart@web.sourceforge.net:database_dump.sql.zip ~/Desktop/database_dump.sql.zip

Latest revision as of 01:12, 12 August 2015

(the "persistent" folder is symlinked inside "htdocs" and so should follow)

Retrieved from "http://supertuxkart.sourceforge.net/How_to_backup_the_wiki"

User Tools