mysqldump -u root -h localhost -pMyPassword -A | gzip -9 > allmy-db.sql.gz
backup all database from srv to allmy-db.sql.gz file!
———-
To restore compressed backup files you can do the following:
gunzip < allmy-db.sql.gz | mysql -u root -pMyPassword
or uncompress gz file: gunzip allmy-db.sql.gz
and ...
mysqldump -u root -h localhost -pMyPassword -A | gzip -9 > allmy-db.sql.gz
backup all database from srv to allmy-db.sql.gz file!
----------
To restore compressed backup files you can do the following:
gunzip < allmy-db.sql.gz | mysql -u root -pMyPassword
or uncompress gz file: gunzip allmy-db.sql.gz
and ...
Default config file installed by RPM is : /etc/my.cnf
so read /etc/my.cnf
should be like:
[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sock
...
Default databases (datadir) is located in: /var/lib/mysql/
