Skip to content

MySQL GPLv3 license

wget https://repo.mysql.com/mysql-apt-config_0.8.30-1_all.deb
dpkg -i mysql-apt-config_0.8.30-1_all.deb
apt update
apt install mysql-server
mysql_secure_installation

#check
systemctl status mysql

.my.cnf

[client]
user=root
password=xxxXXXxx
#import
mysql -u username -p new_database < data-dump.sql
mysql -u root -p < alldb.sql

#export
mysqldump -u username -p database_name > data-dump.sql
mysqldump -u root -p --opt --all-databases > alldb.sql
mysqldump -u root -p --all-databases --skip-lock-tables > alldb.sql
mysqldump -h host.com  -u root -pP4$$W0RD --port=3306 --single-transaction --routines --triggers --databases lala00 lala01 --compress  --compact --master-data > db.sql