← Back to team overview

maria-developers team mailing list archive

Re: Fwd: Need Help


"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@xxxxxxxxx>

> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-developers
> More help   : https://help.launchpad.net/ListHelp