Hi Sovello, You can use mysql workbench to compare schema for two databases: mysqldiff --server1=user:passwd@localhost db1:db2
The above statement will provide you with table which are in one db and missing in the other. To check amount of columns in each table you can write:- SELECT TABLE_NAME, COUNT(ORDINAL_POSITION) AS qty_of_columns FROM COLUMNS WHERE TABLE_SCHEMA='DB NAME' GROUP BY TABLE_NAME. you can export the result in csv and do the same to the other table. Israel. On Fri, Apr 8, 2016 at 10:22 AM, < care2002-developers-requ...@lists.sourceforge.net> wrote: > Send Care2002-developers mailing list submissions to > care2002-developers@lists.sourceforge.net > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.sourceforge.net/lists/listinfo/care2002-developers > or, via email, send a message with subject or body 'help' to > care2002-developers-requ...@lists.sourceforge.net > > You can reach the person managing the list at > care2002-developers-ow...@lists.sourceforge.net > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Care2002-developers digest..." > > > Today's Topics: > > 1. Re: Updating Care2x database tables (Ap.Muthu) > 2. Re: Updating Care2x database tables (Sovello Hildebrand Mgani) > 3. Re: Updating Care2x database tables (Tim Schofield) > 4. Fw: new important message (tasso...@otenet.gr) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Fri, 25 Mar 2016 22:35:25 +0530 > From: "Ap.Muthu" <apmu...@usa.net> > Subject: Re: [Care2002-developers] Updating Care2x database tables > To: <care2002-developers@lists.sourceforge.net> > Message-ID: <811EEBC814344EB6B5F5661F114624D6@core2quadapm> > Content-Type: text/plain; charset="utf-8" > > Install a new Care2x and then compare the schema between the new and old > one can check for differences in a Schema compare tool like SQLyog and make > changes in the database manually. > ----- Original Message ----- > From: Sovello Hildebrand Mgani > To: care2002-developers@lists.sourceforge.net > Sent: Thursday, March 24, 2016 11:28 AM > Subject: [Care2002-developers] Updating Care2x database tables > > > Hi everyone! > How do we update a Care2x database table when the system is already > installed. > I came to realize that some of the fields though available in the module > class (e.g. class_lab.php) but are missing in the actual tables associated > with the class. > I want to be able to update the tables after the instance has been > installed. > Any pointers will be highly appreciated! > > Cheers > > > > > ------------------------------------------------------------------------------ > > > > ------------------------------------------------------------------------------ > Transform Data into Opportunity. > Accelerate data analysis in your applications with > Intel Data Analytics Acceleration Library. > Click to learn more. > http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140 > > > > ------------------------------------------------------------------------------ > > > _______________________________________________ > Care2002-developers mailing list > Care2002-developers@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/care2002-developers > -------------- next part -------------- > An HTML attachment was scrubbed... > > ------------------------------ > > Message: 2 > Date: Mon, 28 Mar 2016 07:17:10 +0300 > From: Sovello Hildebrand Mgani <sovellohpmg...@gmail.com> > Subject: Re: [Care2002-developers] Updating Care2x database tables > To: care2002-developers@lists.sourceforge.net > Message-ID: > <CAPc02xuk= > adxbpmgjshbo8kjmrydd8qvnfbjdb4c62jowkz...@mail.gmail.com> > Content-Type: text/plain; charset="utf-8" > > Thanks all for the pointers! > I have been working in a place with very limited internet access. > I will make use of the suggestions and send feedback of what I'll have done > then. > > Am thinking this will be one of the functionalities we may need in Care2x > so it's easy to edit the database schema as we are developing. [It will > serve us hours of making comparisons :)] > > Thank you all. > > Cheers > > 2016-03-25 20:05 GMT+03:00 Ap.Muthu <apmu...@usa.net>: > > > Install a new Care2x and then compare the schema between the new and old > > one can check for differences in a Schema compare tool like SQLyog and > make > > changes in the database manually. > > > > ----- Original Message ----- > > *From:* Sovello Hildebrand Mgani > > *To:* care2002-developers@lists.sourceforge.net > > *Sent:* Thursday, March 24, 2016 11:28 AM > > *Subject:* [Care2002-developers] Updating Care2x database tables > > > > Hi everyone! > > How do we update a Care2x database table when the system is already > > installed. > > I came to realize that some of the fields though available in the module > > class (e.g. class_lab.php) but are missing in the actual tables > associated > > with the class. > > I want to be able to update the tables after the instance has been > > installed. > > Any pointers will be highly appreciated! > > > > Cheers > > > > ------------------------------ > > > > > > > ------------------------------------------------------------------------------ > > Transform Data into Opportunity. > > Accelerate data analysis in your applications with > > Intel Data Analytics Acceleration Library. > > Click to learn more. > > http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140 > > > > ------------------------------ > > > > _______________________________________________ > > Care2002-developers mailing list > > Care2002-developers@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/care2002-developers > > > > > > > > > ------------------------------------------------------------------------------ > > Transform Data into Opportunity. > > Accelerate data analysis in your applications with > > Intel Data Analytics Acceleration Library. > > Click to learn more. > > http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140 > > _______________________________________________ > > Care2002-developers mailing list > > Care2002-developers@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/care2002-developers > > > > > > > -- > :: Sovello Hildebrand Mgani :: > > > > --If you teach man to fish, you'll feed him a lifetime-- > -------------- next part -------------- > An HTML attachment was scrubbed... > > ------------------------------ > > Message: 3 > Date: Mon, 28 Mar 2016 10:13:08 +0100 > From: Tim Schofield <tim.schofield1...@gmail.com> > Subject: Re: [Care2002-developers] Updating Care2x database tables > To: Care2x Developers <care2002-developers@lists.sourceforge.net> > Message-ID: > <CABsfisg-gwWFj+dmPVLwQwdHGJ5wt6n= > 33sjfqpaxumd_l5...@mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > I would say we have two distinct issues with the DB structure. > > 1 We need to ensure that we have a structure that works with the code > base that we are using. This needs to be put under the installer/ > directory (which I notice had been omitted from github but I have now > uploaded). > > 2 Then we need a method for adding database updates for any new > features so that users can safely update to newer versions. One > technique I have used in the past is to have a directory with > sequentially numbered update files in, and then when an admin user > logs in the latest numbered applied is compared with the highest > number in that directory and then any new updates can be applied. > > Tim > > ps I have reviewed and merged your pull request. > > On 28 March 2016 at 05:17, Sovello Hildebrand Mgani > <sovellohpmg...@gmail.com> wrote: > > Thanks all for the pointers! > > I have been working in a place with very limited internet access. > > I will make use of the suggestions and send feedback of what I'll have > done > > then. > > > > Am thinking this will be one of the functionalities we may need in > Care2x so > > it's easy to edit the database schema as we are developing. [It will > serve > > us hours of making comparisons :)] > > > > Thank you all. > > > > Cheers > > > > 2016-03-25 20:05 GMT+03:00 Ap.Muthu <apmu...@usa.net>: > >> > >> Install a new Care2x and then compare the schema between the new and old > >> one can check for differences in a Schema compare tool like SQLyog and > make > >> changes in the database manually. > >> > >> ----- Original Message ----- > >> From: Sovello Hildebrand Mgani > >> To: care2002-developers@lists.sourceforge.net > >> Sent: Thursday, March 24, 2016 11:28 AM > >> Subject: [Care2002-developers] Updating Care2x database tables > >> > >> Hi everyone! > >> How do we update a Care2x database table when the system is already > >> installed. > >> I came to realize that some of the fields though available in the module > >> class (e.g. class_lab.php) but are missing in the actual tables > associated > >> with the class. > >> I want to be able to update the tables after the instance has been > >> installed. > >> Any pointers will be highly appreciated! > >> > >> Cheers > >> > >> ________________________________ > >> > >> > >> > ------------------------------------------------------------------------------ > >> Transform Data into Opportunity. > >> Accelerate data analysis in your applications with > >> Intel Data Analytics Acceleration Library. > >> Click to learn more. > >> http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140 > >> > >> ________________________________ > >> > >> _______________________________________________ > >> Care2002-developers mailing list > >> Care2002-developers@lists.sourceforge.net > >> https://lists.sourceforge.net/lists/listinfo/care2002-developers > >> > >> > >> > >> > ------------------------------------------------------------------------------ > >> Transform Data into Opportunity. > >> Accelerate data analysis in your applications with > >> Intel Data Analytics Acceleration Library. > >> Click to learn more. > >> http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140 > >> _______________________________________________ > >> Care2002-developers mailing list > >> Care2002-developers@lists.sourceforge.net > >> https://lists.sourceforge.net/lists/listinfo/care2002-developers > >> > > > > > > > > -- > > :: Sovello Hildebrand Mgani :: > > > > > > > > --If you teach man to fish, you'll feed him a lifetime-- > > > > > ------------------------------------------------------------------------------ > > Transform Data into Opportunity. > > Accelerate data analysis in your applications with > > Intel Data Analytics Acceleration Library. > > Click to learn more. > > http://pubads.g.doubleclick.net/gampad/clk?id=278785471&iu=/4140 > > _______________________________________________ > > Care2002-developers mailing list > > Care2002-developers@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/care2002-developers > > > > > > -- > Course View Towers, > Plot 21 Yusuf Lule Road, > Kampala > T +256 (0) 312 314 418 > M +256 (0) 752 963 325 > www.weberpafrica.com > Twitter: @TimSchofield2 > Blog: http://weberpafrica.blogspot.co.uk/ > > > > ------------------------------ > > Message: 4 > Date: Fri, 8 Apr 2016 10:04:03 +0300 > From: <tasso...@otenet.gr> > Subject: [Care2002-developers] Fw: new important message > To: "care2002-developers" <care2002-developers@lists.sourceforge.net>, > "dailyForecast" <dailyforec...@freemeteo.com>, "devnull" > <crodrig...@projstream.com>, "donnie" <don...@stockton-house.com>, > "drakelalonde.mj_2146335_4972718" > <drakelalonde.mj_2146335_4972...@forces.gc.ca> > Message-ID: <00007717e9db$96aa82f9$4af0b8b8$@otenet.gr> > Content-Type: text/plain; charset="us-ascii" > > Hello! > > > > New message, please read <http://jiguanghoutai.com/of.php?dey3> > > > > tasso...@otenet.gr > > -------------- next part -------------- > An HTML attachment was scrubbed... > > ------------------------------ > > > ------------------------------------------------------------------------------ > > > ------------------------------ > > _______________________________________________ > Care2002-developers mailing list > Care2002-developers@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/care2002-developers > > > End of Care2002-developers Digest, Vol 86, Issue 1 > ************************************************** > -- *ISRAEL PASCAL* *CARE2X CONSULTANT* *MICROSOFT CERTIFIED PROFESSIONAL MCP/DBA* SERENGETI ROAD OPPOSITE OUTPOST LODGE Mob: +255767809660 +255719709660
------------------------------------------------------------------------------
_______________________________________________ Care2002-developers mailing list Care2002-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/care2002-developers
