473,322 Members | 1,510 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

version control for mysql database

Hi,

That's my first time to send mail to this address for asking help.
Sorry for my poor english firstly.

My case is like this:
Many guys are using a mysql database, each guy has a database copy in
his own PC, they need to do some changes in their local database from
time to time. then all guys need submit the changes to the central
database for sharing.

Is there a good tool or good way to do version control of a database?
I'm thinking a very stupid way whicy is by mysqldump, but I suspect it
maybe will lost data in some special cases.

The stupid mysqldump idea is: I can use mysqldump to dump local
database to a txt file, then using subversion to do version control of
the txt file. After changing local database, each guy can run mysqldump
to dump his local database to a txt file, then commit it to a central
dump file repository, also they need update local dump file from
central dump file repository to get somebody else's changes. then they
can restore local database by updated dump file.

Maybe you will ask me why don't let all guys to share a central
database, the reason is it seems like very hard to do security control,
because all guys need to change same table in same database(only
different records), our current application does not have any security
control for the database. on the other hand, to do version control of
database, we can record all guy's change in an easy way, and we can
arrange a manager to review changing patch, it seems like a better way.

Another small question is : if two guys add some different records at
the same time, those different records will have same primary key(which
is INTEGER auto-incremented), althrough I can merge those new added
records into one file and try to restore all of them to database, but,
database will claim "duplicate id" error. So I'm thinking if there is a
switch which can control mysql to change the duplicated id to a
auto-incremented value and insert it to database automatically?

Thanks in advance!

Sep 29 '06 #1
0 5721

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: JStrummer | last post by:
I currently have an ASP website that utilizes an Access database, which I administrate through the web via aspaccess. I really would like to have a better database, but I can't afford to own SQL...
0
by: dcp | last post by:
I just installed the 4.1.0-alpha-max-nt version of MySql and have just started playing around with it. My first test was to try to create a couple of tables, one with a foreign key constraint. ...
0
by: Murray | last post by:
I am trying to develop a web based database application to manage a Scout group. I need to control the level of access different visitors to the site are allowed to different parts of the...
0
by: Campbell's List | last post by:
Hi, I'm completely new to MySql and need help importing tables from Access or Dbase. I am using Dreamweaver MX to create a data-driven web site. With the VPS hosting plan we're on, our remote...
2
by: Brian | last post by:
Hello I am using version 4.0.12-nt of MySQL and when I hit the enter key rapidly I can't connect to the database. The result is a message is returned to me from mysql that says I can't connect...
2
by: uli2003wien | last post by:
Dear group, we are dealing with some very specific problems with ODBC, where a connection from SQL-Server to Mysql works with ODBC-driver 3.51.10.00 and does NOT work with ODBC-driver...
0
by: uli2003wien | last post by:
Dear MS-SQL-Server-group maybe my message for MySQL is also for you of interest, since the MS-SQL-Server and it's binary_checksum function is involved...
5
by: B1ackwater | last post by:
We've fooled around with Access a bit, but only using the single-user store-bought version. It seems to be a good database - versatile and infinitely programmable - and can apparently be used as a...
12
by: lawpoop | last post by:
I'm developing a php website that I have under subversion version control. I'm working on an image upload functionality, and in the middle of it I realized that any files that a user uploads will...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.