CLI - Database - Revision history

Shin: /* Database Importing */

2022-01-28T01:24:12Z

Database Importing

2022-01-28T01:23:17Z

Database password

2022-01-27T11:37:16Z

2021-06-15T07:35:15Z

2021-05-18T01:15:30Z

2021-05-18T01:14:44Z

2021-05-18T01:08:55Z

Verifying Database

2021-05-18T01:04:14Z

2021-05-18T01:01:54Z

Connect to Database(mysql)

2021-05-18T00:59:46Z

Configuring Database backup

@@ Line 159: / Line 159: @@
 Select backup file number: 2
 </pre>
-{{note|When data is recovered through the command, all current data is deleted and they are replaced with the data in the backup file, so use it only if there is a problem with the database.}}
+{{note|When data is recovered through the command, all current data is deleted and they are replaced with the data in the backup file, so use it only if there are problems with the database.}}
 === Connect to Database(mysql) ===

@@ Line 101: / Line 101: @@
 Local Database                : lyon/*****y@nu24@127.0.0.1:6710
 </pre>
-{{note|If your system is configured the failover, you must change the password of the active database and then change the password of the passive(standby) database to the same password as the active database.}}
+{{note|If your system is configured the failover, you must change the password of the active database and then change the password of the passive(standby) database to the same password as the active database. The method of changing the database password of the active device is the same as mentioned above.}}
 ''Changing password in the passive(standby) database'' <br />
-In an environment where the failover is operated, the password of passive device must be the same as the password of active device,
+In an environment where the failover is operated, the password of the passive device must be the same as the password of the active device,
-so if it is successful after attempting to access active device, it will be changed to that password.
+so if it is successful after attempting to access the active device, it will be changed to that password.
 <pre>
 LYSH@MyHostName# configure

@@ Line 43: / Line 43: @@
       Active: active (running) since Tue 2021-05-11 15:44:07 KST; 6 days ago
 .....
 </pre>
@@ Line 82: / Line 51: @@
 * db_backup_hour=3
 * max_db_backup_file=5
-The above configurations mean that the system backup the database at 3 o'clock every 1 day and remain only a recent 5 backup files. In other words, if there are more than 5 backup files after backup, the oldest one is removing.
+The above configurations mean that the system backup the database at 3 o'clock every 1 day and remain only a recent 5 backup files. In other words, if there are more than 5 backup files after backup, the oldest one is removed.
 <pre>
 LYSH@MyHostName# show system db_backup		// view the current database backup configuration
@@ Line 117: / Line 86: @@
 -rw-r--r-- 1 root root   20 Apr 28 03:30 backup_210428.sql.gz
 </pre>
 === Connect to Database(mysql) ===

@@ Line 120: / Line 120: @@
 === Connect to Database(mysql) ===
 You can access a database directly if necessary by entering the <code>mysql</code> command on user mode.
-If you want to access a database using "root", you must request an One Time Password (OTP)<ref>http://issue.basein.net</ref>.
+If you want to access a database using "root", you must request a One Time Password (OTP)<ref>http://issue.basein.net</ref>.
 You should bear in mind that accessing the Database should be only for the purpose of maintenance or fixing problems.
 === References ===

@@ Line 16: / Line 16: @@
 * HOST: The host the client is connected to.
 * DB: The default database of the process (NULL if no default).
-* COMMAND: The command type.
+* COMMAND: The command type.<ref>https://mariadb.com/kb/en/thread-command-values/</ref>
 * TIME:	The amount of time, in seconds, the process has been in its current state.
 * INFO:	The statement being executed.

@@ Line 31: / Line 31: @@
 |}
-If you run the <code>show system mariadb</code> command, it shows the version of the Database. To check the status of the database, enter the <code>show service mysql</code> or <code>show service status mysql</code>
+If you run the <code>show system mariadb</code> command, it shows the version of the Database. You can also check the status of the database by entering the <code>show service mysql</code> or <code>show service status mysql</code>
 <pre>
 LYSH@MyHostName# show system mariadb

@@ Line 3: / Line 3: @@
 === Verifying Database ===
 If you run the <code>show system mariadb</code> command, it shows the version of the Database. To check the status of the database, enter the <code>show service mysql</code> or <code>show service status mysql</code>
 <pre>
@@ Line 96: / Line 124: @@
 You should bear in mind that accessing the Database should be only for the purpose of maintenance or fixing problems.
-=== Verifying Database ===
 === References ===

@@ Line 76: / Line 76: @@
 <pre>
 LYSH@MyHostName# show database backup
 db_backup                     : enable
 db_backup_interval            : 1