|
|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
05-13-2010, 11:39 AM
|
#1 |
|
Confirmed User
Industry Role:
Join Date: Feb 2005
Location: Los Angeles
Posts: 1,531
|
Difference between MySQL databases
Does anyone have ideas on how to do a difference between databases?
For example, I have 50 tables in a database on some software that I bought. I want to take a snapshot of the database, upload a photo, edit a gallery, then take another snapshot of the database to see what changed. Any ideas on how I can do that? > mysql databaseB - databaseA I am thinking to do a dump of the database, make a new DB, then source it. Make my changes on the site... But then how do I do a "difference of everything in all tables" dump?
__________________
www.gimmiegirlproductions.com |
|
|
|
05-13-2010, 11:43 AM
|
#2 |
|
Now choke yourself!
Industry Role:
Join Date: Apr 2006
Posts: 12,085
|
So just do two dumps or setup a master-slave relationship with binlogs and setup query logging on the slave; when done just drop the slave association/etc.
__________________
|
|
|
|
|
05-13-2010, 11:56 AM
|
#3 |
|
ICQ:649699063
Industry Role:
Join Date: Mar 2003
Posts: 27,763
|
Good luck.
__________________
Send me an email: [email protected] |
|
|
|
|
05-13-2010, 11:59 AM
|
#4 |
|
Confirmed User
Join Date: Mar 2009
Posts: 193
|
The last post says how you would do it. But what are you ultimately trying to do? Reverse engineer? Have 2 versions of a site with an admin on one and not the live server?
__________________
Adult Software Solutions (ICQ 559884738) PHP, MySQL, Flash, Actionscript, Java, Wowza, CMS, Tube, VOD, CRM, Dating, Social Networks, Paysites, TGPs, Directories and more. If you can think it I can build it. |
|
|
|
|
05-13-2010, 12:06 PM
|
#5 |
|
Beer Money Baron
Industry Role:
Join Date: Jan 2001
Location: brujah / gmail
Posts: 22,157
|
show table status; -- should tell you which tables have changed, and then you can look in the table.. if that's not enough you could...
mysql -e 'select * from table' > before.txt .. do your stuff here .. mysql -e 'select * from table' > after.txt then; diff before.txt after.txt
__________________
|
|
|
|
|
05-13-2010, 12:11 PM
|
#6 | |
|
Confirmed User
Join Date: Jun 2009
Location: Asheville, NC
Posts: 2,277
|
Quote:
__________________
ICQ: 258-202-811 | Email: eric{at}bestxxxporn.com |
|
|
|
|
|
05-13-2010, 12:18 PM
|
#7 |
|
So Fucking Banned
Join Date: Aug 2008
Location: Just Blow Me
Posts: 10,551
|
bump 4 answers
|
|
|
|
|
05-13-2010, 12:34 PM
|
#8 |
|
Confirmed User
Join Date: Aug 2007
Posts: 128
|
Why not just enable the query log and see what queries were executed?
- http://dev.mysql.com/doc/refman/5.1/en/query-log.html
__________________
230-699 |
|
|
|
|
05-13-2010, 02:04 PM
|
#9 | |
|
Confirmed User
Industry Role:
Join Date: Feb 2005
Location: Los Angeles
Posts: 1,531
|
Quote:
Yes, I am trying to reverse engineer a table. I have software to populate with data, and don't want to manually do it. So I'm hoping I can write a little php script that populates data automatically.
__________________
www.gimmiegirlproductions.com |
|
|
|
|
AIM: GrouchyGfy
