Skip to main content

Mysql/MariaDB Recovery.

[DB_NAME]: DB-name to recovery.

/dev/shm Usage: First, check your memory if you can use shm directory.

  For recovery speed, I use /dev/shm/ directory.


Process flow.

01. Stop DB

 service mysqld stop

02. Stop web-service. (If you don't use, block DB-connection by using firewall-cmd.)

 service httpd stop

03. Change DB-mode on server.cnf 

 set innodb_force_recovery = 5 on /etc/my.cnf.d/server.cnf

04. Start DB for recovery.

 service mysqld start

05. Run DB-dump.

 mysqldump -u root -p --databases [DB_NAME] > /dev/shm/[DB_NAME].sql

06. Stop DB

 service mysqld stop

07. Change DB-mode on server.cnf (normal mode)

 set innodb_force_recovery = 0 on /etc/my.cnf.d/server.cnf

08. Backup old DB-files. (Run follows if you necessarily need backup.)

 mkdir /backup/DB_BackupTmp

 mv /backup/DB/ibdata1 /backup/DB_BackupTmp

 mv /backup/DB/ib_logfile0 /backup/DB_BackupTmp

 mv /backup/DB/ib_logfile1 /backup/DB_BackupTmp

 mv /backup/DB/[DB_NAME] /backup/DB_BackupTmp

09. Start DB

 service mysqld start

10. Create Database: [DB_NAME]

 mysql -u root -p

 CREATE DATABASE [DB_NAME];

11. Recover DB-dump

 mysql -uroot -p [DB_NAME] < /dev/shm/[DB_NAME].sql

12. Start web-service. (If you don't use, change DB-connection for allow by using firewall-cmd.)

 service httpd start


-End-


Labels:

Comments

Post a Comment

Popular posts from this blog

[scapy] Linux-Cooked pcap to ethernet

# The pcap file formatted by "Linux cooked" # tcpdump -r myfile.pcap -nn reading from file event1.pcap, link-type LINUX_SLL (Linux cooked) ... ... # step1. read myfile.pcap pkts = rdpcap("myfile.pcap"); # step2. read myfile.pcap pkts = [Ether(src='00:11:22:33:44:55', dst='22:33:44:55:66:77')/pkt[1:] for pkt in pkts] # step3. modify IP address and recalculate chksum for pkt in pkts:  pkt[1].dst='192.168.1.10';  pkt[1].src='192.168.1.1';  del pkt[IP].chksum  del pkt[UDP].chksum # step4. packet send sendp(pkts[0]); # step5. save pcap  wrpcap("output.pcap",pkts); # tcpdump -r output.pcap -nn reading from file output.pcap, link-type EN10MB (Ethernet) ... ... # pkt[1:] : It means IP layer 1) Before: Linux cooked / IP / UDP / UDP-Data 2) After: Ethernet / IP / UDP / UDP-Data
Post a Comment
Read more

[WordPress] Change https redirect in DB.

If you make an https redirect without thinking about SSL configuration: Check DB SELECT * from wp_options where option_name IN ('siteurl', 'home'); Update UPDATE wp_options SET option_value = REPLACE(option_value, 'https://your_domain', 'http://your_domain') WHERE option_name IN ('siteurl', 'home');
Post a Comment
Read more

[bash-script/gcc] check warning of make within git-diff of commit

When you need check "make warning" in specific commits, you can use this script to check just in some commits. This script takes some steps. step1. You must know your commit hash. : like abcd1234 step2. Checkout to your commit.  Like this, git checkout abcd1234. step3. You need output file that run make.  Try to run command "make &> myoutput" step4. Then run this. ./new_warning.sh abcd1234 myoutput You can download this script :  new_warning.sh
Post a Comment
Read more