"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 <deepak241084@gmail.com> 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 : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp