MySQL Backups

Note: We are working on updating our documentation, this page has been identified as still needing improvement. This notice will be removed once these improvements are complete.

MySQL backups

SourceForge.net provides MySQL database services on an opt-in basis. Project administrators are encouraged to make regular backups. SourceForge.net provides two paths for making backups: phpMyAdmin and mysqldump.

Using mysqldump for backups

The following example assume you are using a UNIX environment. The below may work on Windows but users are advised to use Cygwin for better compatibility.

First determine your method of access to the database and make any required connections.
From SourceForge.net Hosts
From the Internet

Next, run the mysqldump command. The below example also compresses the dump file and adds the date to the filename. Please replace DATABASE with the name of your database and DATABASE_USER with the name of your database user:

mysqldump -h mysql-LETTER.sourceforge.net --user=DATABASE_USER -P 4040 --opt -p DATABASE | gzip > DATABASE.`date +%Y-%m-%d`.sql.gz

When complete, remove any temporary files you may have created.


Related

Documentation: ToC