`
qtlkw
  • 浏览: 309650 次
  • 性别: Icon_minigender_1
  • 来自: 杭州
社区版块
存档分类
最新评论

Mysql export and import usage

MySQLSQLCC++C# 
阅读更多
正规的方法（官方建议）

导出(export sql)
C:\application\MySQL\bin>mysqldump --opt xpdb >backup-file.sql -u root -ppassword
导出的backup-file.sql文件将存储在当前目录下，即C:\application\MySQL\bin文件中

导入(import sql)
首先创建xpdb数据库
C:\application\MySQL\bin>mysqladmin -u root -ppassword create xpdb
再导入
C:\application\MySQL\bin>mysql xpdb < backup-file.sql -u root -ppassword
分享到：
| 在CentOS5.2上安装Oracle10g
评论
发表评论

您还没有登录,请您登录后再发表评论

相关推荐

    MySQL Sybase ASE Import, Export & Convert Software

    MySQL Sybase ASE Import, Export & Convert Software，数库互相转换，导入工具。

    VB.NET Connect MySQL and Import CSV file.zip_MYSQL_connect_csv_h

    这个压缩包文件“VB.NET Connect MySQL and Import CSV file.zip”包含了一个示例项目，教你如何实现这一功能。让我们详细探讨一下这个过程涉及的知识点。 首先，我们需要了解VB.NET的基础。VB.NET（Visual Basic ...

    mysqlexport

    Mysqlexport 给您二进制mysqlexport和ruby类Mysqlexport::Csv将mysql表导出到csv文件中。 安装 将此行添加到您的应用程序的Gemfile中： gem 'mysqlexport' 然后执行： $ bundle install 或自己安装为： $ gem ...

    Devart dbForge Studio for MySQL Professional Edition v7.1.13

    Fill MySQL databases with external data using our export and import tools. They support more than 10 popular data formats and allow customizing the whole process. Templates, automating data import and...

    MySQL™ and JSP™ Web Applications: Data-Driven Programming Using Tomcat and MySQL

    MySQL™ and JSP™ Web Applications: Data-Driven Programming Using Tomcat and MySQL By James Turner Publisher : Sams Publishing Pub Date : March 27, 2002 ISBN : 0-672-32309-5 Pages : 400

    Beginning PHP and MySQL: From Novice to Professional, 5th Edition

    Gain skills in MySQL’s fundamental features, including supported data types, database management syntax, triggers, views, stored routine syntax, and import/export capabilities Work with hundreds of...

    Prometheus、node-export、mysql-export安装包

    Prometheus、node-export、mysql-export安装包

    EMS MySQL Data Import v1.7.0.3

    【EMS MySQL Data Import v1.7.0.3】是一款专为MySQL数据库设计的数据导入工具，旨在帮助用户方便快捷地将各种格式的数据导入到MySQL数据库中。这款应用软件以其高效和用户友好的特性，深受数据库管理员和开发者的...

    PHP.and.MySQL.Web.Development.5th.Edition

    The authors cover important aspects of security and authentication as they relate to building a real-world website and show you how to implement these aspects in PHP and MySQL. They also introduce ...

    mysql-utilities-1.3.6-win32.msi

    Admin Utilities (Clone, Copy, Compare, Diff, Export, Import) Replication Utilities (Setup, Configuration) General Utilities (Disk Usage, Redundant Indexes, Search Meta Data) MySQL Utilities 1.4 ...

    jdbc-mysql-connection

    标题中的"jdbc-mysql-connection"关键词表明我们讨论的主题是关于Java数据库连接（JDBC）与MySQL数据库之间的交互。JDBC是Java平台上的一个标准接口，它允许Java应用程序与各种类型的数据库进行通信，包括MySQL。...

    Mysql Failover and Repication

    Mysql Failover and Repication

    ExportSQLite:MySQLWorkbench的插件，用于导出SQLite文件

    ＃Export-SQLite ExportSQLite是一个从MySQLWorkbench软件导出SQLite文件的插件。 我修改了最初由Thomas Henlich编写的脚本-http: 生成SQLite文件可以直接用于您的iOS或Android项目。 ＃＃版本已使用MySQLWorkbench...

    Navicat 8 for MySQL and Serial Key

    Navicat 8 for MySQL and Serial Key 序列号 Navicat 8 for MySQL and Serial Key 序列号 Navicat 8 for MySQL and Serial Key 序列号

    PHP and MySQL for Dynamic Web Sites (4th edition)

    《PHP和MySQL动态网站开发（第四版）》是一本专注于如何使用PHP和MySQL进行动态网站开发的书籍。书中详细介绍了PHP和MySQL这两种技术在创建数据库驱动的动态网站方面的应用。在IT行业，尤其是网站开发领域，PHP和...

    MySQL Bible.rar

    Coverage of NuSphere MySQL: Due to the growing popularity of the NuSphere MySQL package, this book covers its enhancements and how to install and develop with NuSphere MySQL. Running database ...

    mysql-import:使用NodeJS导入.sql文件

    $ npm install --save-dev mysql-import 通过Github ： git clone https://github.com/Pamblam/mysql-import.git TLDR： const host = 'localhost' ; const user = 'root' ; const password = 'password' ; ...

    MySQL and JSON: A Practical Programming GuideJun 8, 2018

    Written by a MySQL Community Manager for Oracle, MySQL and JSON: A Practical Programming Guide shows how to quickly get started using JSON with MySQL and clearly explains the latest tools and ...

Magicbox
Global site tag (gtag.js) - Google Analytics