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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- mysql import and exportMySqlImportExport
- export/importExportImport
- import、require 、export、export default、exports、module exportsImportUIExport
- ES6 import exportImportExport
- oracle Export/Import工具使用OracleExportImport
- statistics的export與import!ExportImport
- DB2 export and importDB2ExportImport
- DLL的Export和ImportExportImport
- module.exports 、 exports 和 export 、 export default 、 importExportImport
- Import Error: cannot import name ‘export_saved_modelImportErrorExport
- Export/import Datas To/from a Csv FileExportImport
- import,export的支援[nodejs]ImportExportNodeJS
- full database export and import(實戰)DatabaseExportImport
- DataPump Export/Import Of LOBs Are Not Executed in ParallelExportImportParallel
- oracle Export and Import 簡介(轉)OracleExportImport
- Data Utilities : Export and Import Utilities (57)ExportImport
- Export And Import Between Different Oracle VersionsExportImportOracle
- 新手關於import/export的理解ImportExport
- ES6 module模組 import exportImportExport
- 1nd round export and import errorExportImportError
- Oracle 12c full transportable export & importOracleExportImport
- JS/TS 的 import 和 export 用法小結JSImportExport
- node識別es6的 import/exportImportExport
- DB2 export 與 import 相關操作DB2ExportImport
- 詳解es6的export和import命令ExportImport
- Run Out Of Space On UNDO Tablespace Using DataPump Import/ExportImportExport
- import、require、export、module.exports 混合使用詳解ImportUIExport
- 【metalink】Export/Import DataPump Parameter TRACE (文件 ID 286496.1)ExportImport
- Export and import right application or execute import imp-00010 error solveExportImportAPPError
- ES6模組化之export和import的用法ExportImport
- ES6規範import和export用法總結ImportExport
- 如何讓瀏覽器支援 import 和export語法瀏覽器ImportExport
- 關於 ES6 的 import 與 export 的思考ImportExport
- Sqoop-1.4.4工具import和export使用詳解OOPImportExport
- Oracle 10.2.0.1 exp 之 full database export and import(實戰)OracleDatabaseExportImport
- Export/Import and NLS Considerations (此文章不錯,推薦)ExportImportIDE
- react-native 之匯入(import)、匯出(export)深刻解析ReactImportExport
- 完全可傳輸的匯出/匯入(full transportable export/import)ExportImport