Mysql backup

mysqldump --ignore-table=exifweb.Image --databases exifweb --skip-comments -u root --password > 2014-08-28\ exifweb.sql
mysqldump -u root --password exifweb Image > 2014-08-28\ exifweb\ Image\ only.sql
mysqldump -u root --password --databases exifweb > 2014-08-28\ exifweb.sql
mysqldump -u root --password exifweb | gzip > exifweb.sql.gz
mysqldump -u root --password wordpress | gzip > wordpress.sql.gz

sau backup al fisierelor de date:
cp -uiv /ffp/opt/srv/mysql/innodb/* /e-data/3ebe05e9-b9db-8dd1-a9c7-69017484513c/MySqlBackup/

SET unique_checks = 0;
SET foreign_key_checks = 0;
delete from Album;
INSERT INTO `Album` ...
SET foreign_key_checks = 0;
SET unique_checks = 0;

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.