backup: # mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql
restore:# mysql -u root -p[root_password] [database_name] < dumpfilename.sql
ou
bunzip2 < db_filename.sql.bz2 | mysql -u root -p target_db_name
Different mysqldump group options:
–skip-add-drop-table –no-set-names –skip-disable-keys –skip-add-locksptions –skip-add-drop-table –no-set-names –skip-disable-keys –skip-add-locks
avec gzip
backup : mysqldump -u -p --quick [database_name] | gzip > database_name.gz
mysql
http://www.thegeekstuff.com/2008/09/backup-and-restore-mysql-database-using-mysqldump/
<iframe width="100%" height="416" src="http://snipet.teknotit.com/index.php?embed=544abbfa04803" type="text/html"></iframe>
Texte seul - Permalink - Snippet public posté le 15/02/2020