1.安装
sudo apt install mysql-server mysql-client
2.检查是否安装成功
sudo service mysql restart
状态显示成功说明安装成功
3. 创建数据库命令
mysql -u root -p
show databases;
CREATE DATABASE us_states;
USE us_states;
CREATE TABLE states (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, state CHAR(25), population INT(9));
INSERT INTO states (id, state, population) VALUES (NULL,'Alabama','4822023');
INSERT INTO states (id, state, population) VALUES (NULL, 'Alaska', '731449'), (NULL, 'Arizona', '6553255'), (NULL, 'Arkansas', '2949131');
select * from states;
quit; //退出
參考网址:
https://jingyan.baidu.com/article/425e69e6bbc6c7be14fc1640.html
https://jingyan.baidu.com/article/1876c8526909cd890b13762d.html
4. 备份
4.1 备份方式1
ubuntu下mysql 的数据库文件保存在/var/lib/mysql中,复制其中的所有文件到另一太服务器的相对应文件夹,删除服务器中原来的同名文件夹,重启mysql即可
sudo service mysql restart; //重启mysql
4.2 备份方式2
利用mysqldump
4.2.1 备份
备份所有数据库
mysqldump -u username -p -all-databases > BackupName.sql
备份多个数据库
mysqldump -u username -p --databases dbname2 dbname2 > Backup.sql
4.2.2 恢复
mysql -u root -p < backup.sql
数据库模式下 mysql> source /路径/backup.sql
drop database dbname 删除数据库