nixCraft
Linux / UNIX Tech Support Forum
MySQL databse differences
This is a discussion on MySQL databse differences within the Databases servers forums, part of the Mastering Servers category; Hi I have to find out the difference between MySQL databases. let me put the situation I have a db ...
|
|||||||
| Databases servers Discussions of databases of all types - especially MySQL. |
 |
|
|
LinkBack | Thread Tools | Display Modes |
11-06-2009, 01:11 AM
|
|||
|
|||
MySQL databse differences
Hi
I have to find out the difference between MySQL databases. let me put the situation I have a db named abc i took the backup 10 days back as abc.sql today i dumped the db and i have another sql file abc.sql now i want to find difference between these two files... like exactly what has been added to the database in past 10 days....please guide 
|
| Sponsored Links | ||
|
|
|
11-06-2009, 02:12 AM
|
||||
|
||||
|
Have you tried diff command?
Code:
diff old.abc.sql new.abc.sql
__________________
Vivek Gite Linux Evangelist  Be proud RHEL user, and let the world know about your enterprise choices! Join RedHat user group. Always use CODE tags for posting system output and commands! Do you run a Linux? Let's face it, you need help
|
|
11-06-2009, 02:32 AM
|
|||
|
|||
|
yes but it gives me a lot of output and moreover not in redable format
|
|
11-06-2009, 03:38 PM
|
||||
|
||||
|
You've to write your own script to see the diff. diff is standard UNIX command.
__________________
Vivek Gite Linux Evangelist Be proud RHEL user, and let the world know about your enterprise choices! Join RedHat user group. Always use CODE tags for posting system output and commands! Do you run a Linux? Let's face it, you need help
|
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT +5.5. The time now is 07:20 AM.
