C# WINDOWS APP: Getting sql dump of database?

[pechar]

Hi all,

I am planning to create a windows application, which is meant to retrieve the sql dump of a mysql database. What I need is the structure and the data as well.

You might ask why create this myself with the available software around, but I need this implemented with some extra custom features.

All I need is a text file with the dump in it... just as the dump you get when using:

mysqldump –-user [user name] –-password=[password] [database name] > [dump file]

Is there any Sql command that returns this dump?

Thanks

[pechar]

Hi all,

I am planning to create a windows application, which is meant to retrieve the sql dump of a mysql database. What I need is the structure and the data as well.

You might ask why create this myself with the available software around, but I need this implemented with some extra custom features.

All I need is a text file with the dump in it... just as the dump you get when using:

mysqldump –-user [user name] –-password=[password] [database name] > [dump file]

Is there any Sql command that returns this dump?

Thanks

Anyone have an idea on how to do this? Thanks

[mgpsivan]

Anyone have an idea on how to do this? Thanks

Sorry just now i came across u r post.Hope u'd have found out if not then try this out..
mysql -u[username] -p[password] Newdatabasename <DumpFile

[pechar]

Sorry just now i came across u r post.Hope u'd have found out if not then try this out..
mysql -u[username] -p[password] Newdatabasename <DumpFile

Thanks for the help much appreciated, will have a look into it :)