"mysqldump --no-data" should do, I believe. Or use a GUI-tool that has the option to create structure-only dumps. Or do things in one operation (eliminate the need for an intermediate script) with some "Schema Sync" tool such as http://sqlyogkb.webyog.com/article/302-schema-synchronization.
-- Peter -- Webyog On Thu, Nov 30, 2017 at 2:15 PM, Deepak Gupta <[email protected]> wrote: > Hi There, > > I am working on a project where I have some wired requirement for my > project. > > Issue : I am looking for the generic script that I can run with the help > of Admin rights on the data base and I want the return output in such a way > that it will give me the complete data base structure along with the table > relation ship. > > For an example , there is one HR schema , with in that schema there might > be 100 tables example , Employee / Salary / Address / Department etc and > every table has primary and foreign key concept. So I need the script > should be such a way that it will fetch all these information and as soon > as I run the same script in my local system it will replicate the same data > base structure for me in my local system. > > Kindly suggest how can I achieve this requirement ? Any help or > suggestions are more than welcome. > > Looking foreword to here you soon. > > Thanks D > > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-developers > Post to : [email protected] > Unsubscribe : https://launchpad.net/~maria-developers > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
