• mysqldump


    数据库的导出

    导出对象说明:

    mysqldump可以针对单个表、多个表、单个数据库、多个数据库、所有数据库进行导出的操作

    shell> mysqldump [options] db_name [tbl_name ...] //导出指定数据库或单个表

    shell> mysqldump [options] --databases db_name ... //导出多个数据库

    shell> mysqldump [options] --all-databases //导出所有

     

    导出完整的数据库的数据不含表结构 

    $ mysqldump -uroot -p -d  -q  t_qipusheng > struct.sql   --- 这种方式导出的表结构会有错误! 有些完全不正确! F×。 是因为带了 -d 吗??

    --no-data, -d:只导出表结构,不含数据

    --add-locks:导出过程中锁定表,完成后回解锁。

    -q:不缓冲查询,直接导出至标准输出 

     

    ·   If your tables are primarily InnoDB tables, or if you have a mix of
               InnoDB and MyISAM tables, consider using the mysqlbackup command of
               the MySQL Enterprise Backup product. (Available as part of the
               Enterprise subscription.) It provides the best performance for
               InnoDB backups with minimal disruption; it can also back up tables
               from MyISAM and other storage engines; and it provides a number of
               convenient options to accommodate different backup scenarios. See
               MySQL Enterprise Backup User's Guide (Version 3.8.2)[1].

           ·   If your tables are primarily MyISAM tables, consider using the
               mysqlhotcopy instead, for better performance than mysqldump of
               backup and restore operations. See mysqlhotcopy(1).

           mysqldump can retrieve and dump table contents row by row, or it can  retrieve the entire content from a table and buffer it in memory before dumping it. Buffering in memory can be a problem if you are dumping    large tables. To dump tables row by row, use the --quick option (or   --opt, which enables --quick). The --opt option (and hence --quick) is enabled by default, so to enable memory buffering, use --skip-quick.


    可参考; http://www.cnblogs.com/zhoujinyi/p/5684903.html

  • 相关阅读:
    Zabbix5 Frame 嵌套
    Zabbix5 对接 SAML 协议 SSO
    CentOS7 安装 Nexus
    CentOS7 安装 SonarQube
    GitLab 后台修改用户密码
    GitLab 查看版本号
    GitLab Admin Area 500 Error
    Linux 安装 PostgreSQL
    Liger ui grid 参数
    vue.js 是一个怪东西
  • 原文地址:https://www.cnblogs.com/bravehunter/p/5660085.html
Copyright © 2020-2023  润新知