31,029
edits
Backups: Difference between revisions
Jump to navigation
Jump to search
m
→Using mysqldump
Tag: 2017 source edit |
Tag: 2017 source edit |
||
| Line 71: | Line 71: | ||
With Mysql, the command to backup your database into a file is : | With Mysql, the command to backup your database into a file is : | ||
<syntaxHighlight lang="bash"> | <syntaxHighlight lang="bash"> | ||
mysqldump -u user -pyourpass --result-file=mysqldump_databasename_version_date.sql databasename | mysqldump -u user -pyourpass -l --single-transaction -K --add-drop-table=TRUE --tables -c -e --hex-blob --default-character-set=utf8 --result-file=mysqldump_databasename_version_date.sql databasename | ||
</syntaxHighlight> | </syntaxHighlight> | ||
where : | where : | ||