Click here to Skip to main content
14,838,196 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Dear All,

how to generate database script in MySQL.
Posted
Comments
Storxstar 17-Oct-12 2:57am
   
Very Vague Question....

Hi :),

One way to generate a database script in MySQL is using the mysqldump feature. Another option is creating a backup of MySQL:

1. Log on to MySQL Administrator
2. Click Backup on the Left Panel
3. In the Backup Project insert the name of the backup and in Select Schema the name of the DB from which you want to generate the script
4. Click > (next)and then click Execute Backup Now

I hope these is what you were looking for...
Diana
   
You can use MySqlBackup.NET to help you to generate database script of MySQL:
C#
void GenerateScript()
{
    string constr = "server=localhost;user=root;pwd=qwerty;database=test;";
    string file = "C:\\MyDumpFile.sql";
    MySqlBackup mb = new MySqlBackup(constr);
    mb.ExportInfo.FileName = file;
    mb.Export();
}

Read more at: MySqlBackup.NET - MySQL Backup Solution for C#, VB.NET, ASP.NET[^]
   
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900