mysql export & import
export: mysqldump database [table] > /tmp/filename
import: mysql database < /tmp/filename
can add "max_allowed_packet=104857600" under [mysqld] in /etc/my.cnf file to resolve the "Got a packet bigger than 'max_allowed_packet' bytes" problem.
There is some problems with this import method.
If the mysqldump version is low, the triggers and procedure can not be export. You can upgrade the mysqldump or use remote new version mysqldump to export.
trigger is default, procedure need parameter
mysqldump -u -p -h -R(procedure) dbname > file
Note:
1.When the mysql version is upgrated from low version, need to execute the
/usr/bin/mysql_fix_privilege_tables to extend the procedure and other privileges.
2. When the procedure is recursive, need to add 'max_sp_recursion_depth=500000' under [mysqld] section in my.cnf file
[@more@]來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/545828/viewspace-1024092/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- export/importExportImport
- import、require 、export、export default、exports、module exportsImportUIExport
- import,export的支援[nodejs]ImportExportNodeJS
- Import Error: cannot import name ‘export_saved_modelImportErrorExport
- Export/import Datas To/from a Csv FileExportImport
- 新手關於import/export的理解ImportExport
- ES6 module模組 import exportImportExport
- JS/TS 的 import 和 export 用法小結JSImportExport
- node識別es6的 import/exportImportExport
- 詳解es6的export和import命令ExportImport
- ES6規範import和export用法總結ImportExport
- 如何讓瀏覽器支援 import 和export語法瀏覽器ImportExport
- ES6模組化之export和import的用法ExportImport
- react-native 之匯入(import)、匯出(export)深刻解析ReactImportExport
- 完全可傳輸的匯出/匯入(full transportable export/import)ExportImport
- 這幾個概念你可能還是沒搞清require、import和exportUIImportExport
- 通過 babel-node 執行 ES6 import/export 語法BabelImportExport
- 探討ES6的import export default 和CommonJS的require module.exportsImportExportJSUI
- module.exports、exports 、export default之間的差異區別及與require、import的使用ExportUIImport
- export 和 export default 區別Export
- JavaScript中的export、export default、exports和module.exports(export、export default、exports使用詳細)JavaScriptExport
- MySQL Shell import_table資料匯入MySqlImport
- export和export default的區別Export
- ES6:export 與 export default 區別Export
- 6.exports、module.exports、export、export defalutExport
- JavaScript ES6中,export與export defaultJavaScriptExport
- ES6 export 和 export default的區別Export
- ES6 export && export default 差異總結Export
- vSphere export openstackExport
- require()、import、import()有哪些區別?UIImport
- Python import相關內容區別介紹( import *** as 、from***import )PythonImport
- SAP UI5 Gateway Export 和 Client Export 的比較UIGatewayExportclient
- openGauss lo_exportExport
- Linux之export命令LinuxExport
- csdn_export_mdExport
- JavaScript 中的 exportJavaScriptExport
- SCSS @importCSSImport
- CSS @importCSSImport
- eslint-plugin-import 規則之 Import / OrderEsLintPluginImport