Shulou(Shulou.com)06/01 Report--

Archliun system mysql database

1. Partition and format the new hard disk

1) # fdisk / dev/sdb

2) # mkfs.ext4 / dev/sdb1

2. Stop the MYSQL service

Systemctl stop mysqld

3. Copy the database file

# cp-Rp data/ mnt/data/

4. Delete the original data file

# rm-rf / data

5. Prohibit booting self-starting MYSQL service

# systemctl disable mysqld

6. Mount the self-booting sdb1 partition to data

# vi / etc/fstab

/ dev/sdb1 / data ext4 rw,relatime,data=ordered 0 2

7. Copy the database file back to the original path

# cp-Rp / mnt/data/* / data/

8. Delete / mnt/data database directory

# rm-rf / mnt/data

9. Set / dara permissions

# chown-R mysql:mysql / data

10. Restore mysql service

# systemctl enable mysqld

# systemctl start mysqld

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.