Backup MySQL DB with SVN?

Question

I have a MySQL DB which should be versioned with SVN. I dont want the full DB, only the structure and selected tables. I searched the net and found some information, but nothing seems to really work in a reliable way. Any experience or hints?

Thanks :)

Have a read of this question / answer - suggests possible solutions http://stackoverflow.com/questions/1783834/mysql-version-control-subversion — Manse, Jan 04 '12 at 10:40

Sam Bauers · Answer 1 · 2015-10-12T10:17:59.000

2

Check out this script which automates the process, allowing for specific selection of databases and exclusion of tables [disclaimer I am the author] - http://mysql-svn-backup.redant.com.au/

edited Oct 12 '15 at 10:17

answered Jun 18 '12 at 08:46

Sam Bauers

403
3
5

score 1 · Answer 2 · edited Jun 20 '20 at 09:12

1

Use mysqldump to export the data you want into a file and put this into SVN. Using cron, you can automize this to run in specific timeslots

edited Jun 20 '20 at 09:12

Community

1
1

answered Jan 04 '12 at 10:42

Nico Haase

11,420
35
43
69

score 0 · Answer 3 · answered Jan 04 '12 at 10:42

The question is: what exactly do you want to version, and why?

I propose you version an SQL file that you can import to create your database. Any tool can be used to create this SQL file (basic tool: mysqldump), which you can then save into your SVN repository. You will be able to track new tables being created by comparing revisions of SQL files.

You can automate this process by adding a CRON job to automatically dump and commit the file every 2 hours.

Sounds like something that could work, I will try that. – EOB Jan 04 '12 at 11:42 — EOB, Jan 04 '12 at 11:42

Backup MySQL DB with SVN?

3 Answers3