Click here to Skip to main content
15,940,271 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....

 
Share this answer
 
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
 
Share this answer
 
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[^]
 
Share this answer
 
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