<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                合規國際互聯網加速 OSASE為企業客戶提供高速穩定SD-WAN國際加速解決方案。 廣告
                ## mysql 之 mysqldump導出表結構 1.導出表結構 (-d參數) \* 導出一個庫中的所有表結構 ``` mysqldump -h localhost -u root -p -d db_name > db_name.sql ``` \* 導出一個庫中的一張或多張表的表結構(user表) ``` mysqldump -h localhost -u root -p -d db_name user> user.sql ``` \* 導出多個庫的所有表結構 ``` mysqldump -h localhost -u root -p -d --databases dbname1 dbname2 > db_name.sql ``` \* 導出所有的數據庫表結構 ``` mysqldump -h localhost -u root -p -d --all-databases > all_db.sql ``` 2.導出表結構和數據 (上面的命令去掉 -d 參數) 3.壓縮備份(大概壓縮到四分之一大小) ``` mysqldump -h localhost -u root -p dbname | gzip > db_name.sql.gz ``` 4.導入數據庫 ``` mysql> create database db_name; mysql> source path/db_name.sql; ```
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看