如何在mysql中生成数据库脚本 [英] How to generate database script in mysql

问题描述

亲爱的所有人，

如何在MySQL中生成数据库脚本.

Dear All,

how to generate database script in MySQL.

推荐答案

http://database.blogs.webucator.com/2010 /11/05/creating-database-backups-in-mysql-workbench/ [

Hi

http://database.blogs.webucator.com/2010/11/05/creating-database-backups-in-mysql-workbench/[^]

Check this link....

Happy coding...

嗨:)，

在MySQL中生成数据库脚本的一种方法是使用mysqldump功能.另一个选择是创建MySQL的备份:

1.登录到MySQL Administrator
2.单击左侧面板上的备份"
3.在备份项目"中，插入备份的名称，在选择模式"中，输入要从其生成脚本的数据库的名称
4.点击> (下一个)，然后单击立即执行备份

希望这些就是您想要的...
Diana

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

您可以使用MySqlBackup.NET帮助您生成MySQL的数据库脚本:

You can use MySqlBackup.NET to help you to generate database script of MySQL:

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();
}

有关更多信息，请访问: MySqlBackup.NET-适用于C#的MySQL备份解决方案， VB.NET，ASP.NET [

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

这篇关于如何在mysql中生成数据库脚本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！