mysqldump



dump vsech databazi:
mysqldump --add-drop-table -h HOST -u USER -pPASSWORD --all-databases | gzip > all-databases.sql.gz

dump databáze:
mysqldump --compress --add-drop-table -h host -u user -p database > database.sql

nebo:
mysqldump --opt database > backup-file.sql

dump db, pouze struktura:
mysqldump --no-data -h localhost -u user --password database > db_structure.sql

dump jedné tabulky, add drop table:
mysqldump -u user -p --add-drop-table database table > database_table.sql

načíst dump zpět do db:
mysql database < backup-file.sql
Last update:
2008-12-29 13:09
Author:
Daniel
Revision:
1.96
Average rating:0 (0 Votes)

You cannot comment on this entry

Chuck Norris has counted to infinity. Twice.