mysql dump and restore

[elexis_linux]

Code: Alles auswählen

mysqldump –opt -Q -u dbusername -p databasename > /path/to/backupname.sql

Code: Alles auswählen

mysql -u dbusername -p databasename < /path/to/backupname.sql