{"id":18531,"date":"2026-07-13T15:39:03","date_gmt":"2026-07-13T12:09:03","guid":{"rendered":"https:\/\/maralhost.com\/kb\/docs\/backup\/%d8%a8%da%a9%d8%a7%d9%be-%d8%af%db%8c%d8%aa%d8%a7%d8%a8%db%8c%d8%b3-mysql\/"},"modified":"2026-11-03T16:36:07","modified_gmt":"2026-11-03T13:06:07","slug":"backup-mysql","status":"publish","type":"docs","link":"https:\/\/maralhost.com\/kb\/articles\/backup\/backup-mysql\/","title":{"rendered":"\u0628\u06a9\u0627\u067e \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 MySQL"},"content":{"rendered":"\n

\u0645\u0642\u062f\u0645\u0647<\/h2>\n\n\n\n

\u062a\u0647\u06cc\u0647 \u0646\u0633\u062e\u0647 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646 \u0627\u0632 Database \u06cc\u06a9\u06cc \u0627\u0632 \u0645\u0647\u0645\u200c\u062a\u0631\u06cc\u0646 \u0648\u0638\u0627\u06cc\u0641 \u0645\u062f\u06cc\u0631 \u0633\u0631\u0648\u0631 \u0648 \u0645\u062f\u06cc\u0631 Database \u0627\u0633\u062a. \u062e\u0631\u0627\u0628\u06cc Storage\u060c \u062d\u0630\u0641 \u0627\u0634\u062a\u0628\u0627\u0647 \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u060c \u062e\u0637\u0627\u06cc Application\u060c \u062d\u0645\u0644\u0627\u062a \u0628\u0627\u062c\u200c\u0627\u0641\u0632\u0627\u0631\u06cc\u060c Upgrade \u0646\u0627\u0645\u0648\u0641\u0642 \u06cc\u0627 \u062e\u0631\u0627\u0628 \u0634\u062f\u0646 Server \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0628\u0627\u0639\u062b \u0627\u0632 \u062f\u0633\u062a \u0631\u0641\u062a\u0646 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0634\u0648\u062f.<\/p>\n\n\n\n

\u062f\u0631 MySQL \u0631\u0648\u0634\u200c\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641\u06cc \u0628\u0631\u0627\u06cc Backup \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f. \u0633\u0627\u062f\u0647\u200c\u062a\u0631\u06cc\u0646 \u0648 \u0645\u062a\u062f\u0627\u0648\u0644\u200c\u062a\u0631\u06cc\u0646 \u0631\u0648\u0634 \u0628\u0631\u0627\u06cc \u0628\u0633\u06cc\u0627\u0631\u06cc \u0627\u0632 Database\u0647\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u0628\u0632\u0627\u0631 mysqldump<\/code> \u0627\u0633\u062a. \u0627\u06cc\u0646 \u0627\u0628\u0632\u0627\u0631 \u06cc\u06a9 Logical Backup<\/strong> \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc\u200c\u06a9\u0646\u062f\u061b \u06cc\u0639\u0646\u06cc \u0633\u0627\u062e\u062a\u0627\u0631 Database \u0648 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0622\u0646 \u0631\u0627 \u0628\u0647 \u0645\u062c\u0645\u0648\u0639\u0647\u200c\u0627\u06cc \u0627\u0632 \u062f\u0633\u062a\u0648\u0631\u0627\u062a SQL \u062a\u0628\u062f\u06cc\u0644 \u0645\u06cc\u200c\u06a9\u0646\u062f \u06a9\u0647 \u0628\u0639\u062f\u0627\u064b \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0622\u0646\u200c\u0647\u0627 \u0631\u0627 \u0631\u0648\u06cc MySQL Server \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u06a9\u0631\u062f.<\/p>\n\n\n\n

\u0633\u0627\u062e\u062a\u0627\u0631 \u0633\u0627\u062f\u0647 \u0641\u0631\u0622\u06cc\u0646\u062f \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/p>\n\n\n\n

MySQL Database\n\u2193\nBackup\n\u2193\nSQL Dump File\n\u2193\nBackup Storage\n\u2193\nRestore\n\u2193\nMySQL Database<\/code><\/pre>\n\n\n\n
\u0628\u0631\u0627\u06cc Database\u0647\u0627\u06cc \u0628\u0632\u0631\u06af\u200c\u062a\u0631 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0627\u0632 \u0631\u0648\u0634\u200c\u0647\u0627\u06cc Physical Backup \u06cc\u0627 \u0642\u0627\u0628\u0644\u06cc\u062a\u200c\u0647\u0627\u06cc MySQL Shell \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f. \u0627\u0628\u0632\u0627\u0631\u0647\u0627\u06cc Dump \u062f\u0631 MySQL Shell \u0627\u0645\u06a9\u0627\u0646 \u067e\u0631\u062f\u0627\u0632\u0634 \u0645\u0648\u0627\u0632\u06cc\u060c Compression \u0648 \u0646\u0645\u0627\u06cc\u0634 Progress \u0631\u0627 \u0646\u06cc\u0632 \u0641\u0631\u0627\u0647\u0645 \u0645\u06cc\u200c\u06a9\u0646\u0646\u062f.<\/p>\n\n\n\n
\n\n\n\n
\u0627\u0646\u0648\u0627\u0639 Backup \u062f\u0631 MySQL<\/h1>\n\n\n\n
Backup\u0647\u0627\u06cc MySQL \u0631\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0627\u0632 \u0686\u0646\u062f \u062f\u06cc\u062f\u06af\u0627\u0647 \u062f\u0633\u062a\u0647\u200c\u0628\u0646\u062f\u06cc \u06a9\u0631\u062f.<\/p>\n\n\n\n
\u0646\u0648\u0639<\/th>\u062a\u0648\u0636\u06cc\u062d<\/th><\/tr>
Logical Backup<\/td>\u0630\u062e\u06cc\u0631\u0647 \u0633\u0627\u062e\u062a\u0627\u0631 \u0648 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0628\u0647\u200c\u0635\u0648\u0631\u062a SQL \u06cc\u0627 \u062f\u0627\u062f\u0647 \u0645\u0646\u0637\u0642\u06cc<\/td><\/tr>
Physical Backup<\/td>\u06a9\u067e\u06cc \u0641\u0627\u06cc\u0644\u200c\u0647\u0627\u06cc \u0648\u0627\u0642\u0639\u06cc Database<\/td><\/tr>
Full Backup<\/td>Backup \u06a9\u0627\u0645\u0644 \u0627\u0637\u0644\u0627\u0639\u0627\u062a<\/td><\/tr>
Incremental Backup<\/td>\u0630\u062e\u06cc\u0631\u0647 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u0628\u0639\u062f \u0627\u0632 Backup \u0642\u0628\u0644\u06cc<\/td><\/tr>
Online Backup<\/td>Backup \u062f\u0631 \u062d\u0627\u0644\u06cc \u06a9\u0647 MySQL \u0641\u0639\u0627\u0644 \u0627\u0633\u062a<\/td><\/tr>
Offline Backup<\/td>Backup \u062f\u0631 \u062d\u0627\u0644\u06cc \u06a9\u0647 MySQL \u0645\u062a\u0648\u0642\u0641 \u0627\u0633\u062a<\/td><\/tr>
Local Backup<\/td>\u0630\u062e\u06cc\u0631\u0647 Backup \u0631\u0648\u06cc \u0647\u0645\u0627\u0646 Server<\/td><\/tr>
Remote Backup<\/td>\u0630\u062e\u06cc\u0631\u0647 Backup \u0631\u0648\u06cc Server \u06cc\u0627 Storage \u062f\u06cc\u06af\u0631<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
MySQL \u0645\u06cc\u0627\u0646 Logical \u0648 Physical Backup \u062a\u0641\u0627\u0648\u062a \u0642\u0627\u0626\u0644 \u0645\u06cc\u200c\u0634\u0648\u062f. Logical Backup \u0645\u0639\u0645\u0648\u0644\u0627\u064b Portability \u0628\u06cc\u0634\u062a\u0631\u06cc \u062f\u0627\u0631\u062f\u060c \u062f\u0631 \u062d\u0627\u0644\u06cc \u06a9\u0647 Physical Backup \u0628\u0631\u0627\u06cc Database\u0647\u0627\u06cc \u0628\u0633\u06cc\u0627\u0631 \u0628\u0632\u0631\u06af \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0633\u0631\u0639\u062a Backup \u0648 Restore \u0628\u0627\u0644\u0627\u062a\u0631\u06cc \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u062f.<\/p>\n\n\n\n
\n\n\n\n
mysqldump \u0686\u06cc\u0633\u062a\u061f<\/h1>\n\n\n\n
mysqldump<\/code> \u06cc\u06a9\u06cc \u0627\u0632 \u0627\u0628\u0632\u0627\u0631\u0647\u0627\u06cc \u0627\u0635\u0644\u06cc MySQL \u0628\u0631\u0627\u06cc \u062a\u0647\u06cc\u0647 Logical Backup \u0627\u0633\u062a.<\/p>\n\n\n\n
\u0627\u06cc\u0646 \u0627\u0628\u0632\u0627\u0631 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0627\u0632 \u0645\u0648\u0627\u0631\u062f \u0632\u06cc\u0631 Backup \u062a\u0647\u06cc\u0647 \u06a9\u0646\u062f:<\/p>\n\n\n\n
Single Database\nMultiple Databases\nAll Databases\nSingle Table\nMultiple Tables\nSchema Only\nData Only\nStored Routines\nEvents\nTriggers<\/code><\/pre>\n\n\n\n
\u062e\u0631\u0648\u062c\u06cc \u0645\u0639\u0645\u0648\u0644\u0627\u064b \u06cc\u06a9 \u0641\u0627\u06cc\u0644 SQL \u0627\u0633\u062a.<\/p>\n\n\n\n
\u0645\u062b\u0627\u0644:<\/p>\n\n\n\n
database.sql<\/code><\/pre>\n\n\n\n
\u062f\u0627\u062e\u0644 \u0627\u06cc\u0646 \u0641\u0627\u06cc\u0644 \u062f\u0633\u062a\u0648\u0631\u0647\u0627\u06cc\u06cc \u0645\u0627\u0646\u0646\u062f \u0645\u0648\u0627\u0631\u062f \u0632\u06cc\u0631 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u0646\u062f:<\/p>\n\n\n\n
CREATE TABLE ...\nINSERT INTO ...\nCREATE TRIGGER ...\nCREATE PROCEDURE ...<\/code><\/pre>\n\n\n\n
\n\n\n\n
\u0628\u0631\u0631\u0633\u06cc \u0646\u0635\u0628 \u0628\u0648\u062f\u0646 mysqldump<\/h1>\n\n\n\n
\u062f\u0631 Linux:<\/p>\n\n\n\n
mysqldump --version<\/code><\/pre>\n\n\n\n
\u062f\u0631 Windows:<\/p>\n\n\n\n
mysqldump.exe --version<\/code><\/pre>\n\n\n\n
\u062e\u0631\u0648\u062c\u06cc \u0645\u0639\u0645\u0648\u0644\u0627\u064b Version \u0627\u0628\u0632\u0627\u0631 MySQL Client \u0631\u0627 \u0646\u0645\u0627\u06cc\u0634 \u0645\u06cc\u200c\u062f\u0647\u062f.<\/p>\n\n\n\n
\n\n\n\n
\u06af\u0631\u0641\u062a\u0646 Backup \u0627\u0632 \u06cc\u06a9 Database<\/h1>\n\n\n\n
\u0633\u0627\u062f\u0647\u200c\u062a\u0631\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631:<\/p>\n\n\n\n
mysqldump -u root -p database_name > database_name.sql<\/code><\/pre>\n\n\n\n
\u067e\u0633 \u0627\u0632 \u0627\u062c\u0631\u0627 Password \u062f\u0631\u062e\u0648\u0627\u0633\u062a \u0645\u06cc\u200c\u0634\u0648\u062f:<\/p>\n\n\n\n
Enter password:<\/code><\/pre>\n\n\n\n
\u062f\u0631 \u0635\u0648\u0631\u062a \u0645\u0648\u0641\u0642\u06cc\u062a \u0641\u0627\u06cc\u0644 \u0632\u06cc\u0631 \u0627\u06cc\u062c\u0627\u062f \u062e\u0648\u0627\u0647\u062f \u0634\u062f:<\/p>\n\n\n\n
database_name.sql<\/code><\/pre>\n\n\n\n
\n\n\n\n
\u06af\u0631\u0641\u062a\u0646 Backup \u0627\u0633\u062a\u0627\u0646\u062f\u0627\u0631\u062f \u0627\u0632 Database\u0647\u0627\u06cc InnoDB<\/h1>\n\n\n\n
\u0628\u0631\u0627\u06cc Database\u0647\u0627\u06cc \u0645\u0639\u0645\u0648\u0644\u06cc \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 InnoDB \u0628\u0647\u062a\u0631 \u0627\u0633\u062a Backup \u0628\u0627 \u06af\u0632\u06cc\u0646\u0647\u200c\u0647\u0627\u06cc \u0645\u0646\u0627\u0633\u0628\u200c\u062a\u0631\u06cc \u062a\u0647\u06cc\u0647 \u0634\u0648\u062f.<\/p>\n\n\n\n
mysqldump \\\n  --single-transaction \\\n  --quick \\\n  --routines \\\n  --events \\\n  --triggers \\\n  --no-tablespaces \\\n  -u root \\\n  -p \\\n  database_name \\\n  > database_name.sql<\/code><\/pre>\n\n\n\n
\u06af\u0632\u06cc\u0646\u0647 --single-transaction<\/code> \u0628\u0631\u0627\u06cc Table\u0647\u0627\u06cc Transactional \u0645\u0627\u0646\u0646\u062f InnoDB \u06cc\u06a9 Snapshot \u0633\u0627\u0632\u06af\u0627\u0631 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc\u200c\u06a9\u0646\u062f \u0648 \u0645\u0639\u0645\u0648\u0644\u0627\u064b \u0646\u06cc\u0627\u0632 \u0628\u0647 Lock \u0637\u0648\u0644\u0627\u0646\u06cc Table\u0647\u0627 \u0631\u0627 \u06a9\u0627\u0647\u0634 \u0645\u06cc\u200c\u062f\u0647\u062f.<\/p>\n\n\n\n
\u0627\u06cc\u0646 \u06af\u0632\u06cc\u0646\u0647 \u0641\u0642\u0637 \u0628\u0631\u0627\u06cc Storage Engine\u0647\u0627\u06cc Transactional \u0645\u0627\u0646\u0646\u062f InnoDB Consistency \u06a9\u0627\u0645\u0644 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc\u200c\u06a9\u0646\u062f \u0648 \u0628\u0631\u0627\u06cc Table\u0647\u0627\u06cc MyISAM \u06cc\u0627 MEMORY \u0647\u0645\u0627\u0646 \u062a\u0636\u0645\u06cc\u0646 \u0631\u0627 \u0646\u062f\u0627\u0631\u062f. \u0647\u0645\u0686\u0646\u06cc\u0646 \u0628\u0647\u062a\u0631 \u0627\u0633\u062a \u0647\u0646\u06af\u0627\u0645 Dump \u0639\u0645\u0644\u06cc\u0627\u062a DDL \u0645\u0627\u0646\u0646\u062f ALTER TABLE<\/code> \u06cc\u0627 DROP TABLE<\/code> \u0631\u0648\u06cc Table\u0647\u0627\u06cc \u062f\u0631 \u062d\u0627\u0644 Backup \u0627\u0646\u062c\u0627\u0645 \u0646\u0634\u0648\u062f.<\/p>\n\n\n\n
\n\n\n\n
\u06a9\u0627\u0631\u0628\u0631\u062f \u06af\u0632\u06cc\u0646\u0647 –quick<\/h1>\n\n\n\n
\u06af\u0632\u06cc\u0646\u0647 \u0632\u06cc\u0631:<\/p>\n\n\n\n
--quick<\/code><\/pre>\n\n\n\n
\u0628\u0627\u0639\u062b \u0645\u06cc\u200c\u0634\u0648\u062f Row\u0647\u0627 \u0628\u0647\u200c\u062a\u062f\u0631\u06cc\u062c \u062e\u0648\u0627\u0646\u062f\u0647 \u0648 \u062f\u0631 \u062e\u0631\u0648\u062c\u06cc \u0646\u0648\u0634\u062a\u0647 \u0634\u0648\u0646\u062f.<\/p>\n\n\n\n
\u0628\u0631\u0627\u06cc Table\u0647\u0627\u06cc \u0628\u0632\u0631\u06af \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062a\u0631\u06a9\u06cc\u0628 \u0632\u06cc\u0631 \u062a\u0648\u0635\u06cc\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f:<\/p>\n\n\n\n
--single-transaction\n--quick<\/code><\/pre>\n\n\n\n
\u062a\u0627 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u0646\u06af\u0647\u062f\u0627\u0631\u06cc \u062d\u062c\u0645 \u0632\u06cc\u0627\u062f Data \u062f\u0631 Memory \u06a9\u0627\u0647\u0634 \u06cc\u0627\u0628\u062f.<\/p>\n\n\n\n
\n\n\n\n
Backup \u0627\u0632 Stored Procedure \u0648 Function<\/h1>\n\n\n\n
\u0628\u0631\u0627\u06cc Backup \u06af\u0631\u0641\u062a\u0646 \u0627\u0632 Stored Routine\u0647\u0627:<\/p>\n\n\n\n
--routines<\/code><\/pre>\n\n\n\n
\u0631\u0627 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n
\u0645\u062b\u0627\u0644:<\/p>\n\n\n\n
mysqldump \\\n  --single-transaction \\\n  --routines \\\n  -u root \\\n  -p \\\n  database_name \\\n  > database_name.sql<\/code><\/pre>\n\n\n\n
\n\n\n\n
Backup \u0627\u0632 Event\u0647\u0627\u06cc MySQL<\/h1>\n\n\n\n
\u0628\u0631\u0627\u06cc Backup \u06af\u0631\u0641\u062a\u0646 \u0627\u0632 Event Scheduler:<\/p>\n\n\n\n
--events<\/code><\/pre>\n\n\n\n
\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/p>\n\n\n\n
\u0645\u062b\u0627\u0644:<\/p>\n\n\n\n
mysqldump \\\n  --single-transaction \\\n  --events \\\n  -u root \\\n  -p \\\n  database_name \\\n  > database_name.sql<\/code><\/pre>\n\n\n\n
\n\n\n\n
Backup \u0627\u0632 Trigger\u0647\u0627<\/h1>\n\n\n\n
Trigger\u0647\u0627 \u0628\u0647\u200c\u0635\u0648\u0631\u062a \u067e\u06cc\u0634\u200c\u0641\u0631\u0636 \u062a\u0648\u0633\u0637 mysqldump<\/code> Dump \u0645\u06cc\u200c\u0634\u0648\u0646\u062f\u061b \u0628\u0627 \u0627\u06cc\u0646 \u062d\u0627\u0644 \u0628\u0631\u0627\u06cc \u0634\u0641\u0627\u0641 \u0628\u0648\u062f\u0646 Backup Policy \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u06af\u0632\u06cc\u0646\u0647 \u0632\u06cc\u0631 \u0631\u0627 \u0646\u06cc\u0632 \u0635\u0631\u0627\u062d\u062a\u0627\u064b \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f:<\/p>\n\n\n\n
--triggers<\/code><\/pre>\n\n\n\n
\u0628\u0631\u0627\u06cc Stored Routine \u0648 Event \u0628\u0627\u06cc\u062f \u06af\u0632\u06cc\u0646\u0647\u200c\u0647\u0627\u06cc \u0645\u0631\u0628\u0648\u0637\u0647 \u0628\u0647\u200c\u0635\u0648\u0631\u062a \u0635\u0631\u06cc\u062d \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u0648\u0646\u062f. \u062f\u0631 MySQL\u0647\u0627\u06cc \u062c\u062f\u06cc\u062f\u060c \u0627\u06cc\u0646 \u0645\u0648\u0636\u0648\u0639 \u062d\u062a\u06cc \u0647\u0646\u06af\u0627\u0645 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 --all-databases<\/code> \u0627\u0647\u0645\u06cc\u062a \u062f\u0627\u0631\u062f.<\/p>\n\n\n\n
\n\n\n\n
\u062f\u0633\u062a\u0648\u0631 \u067e\u06cc\u0634\u0646\u0647\u0627\u062f\u06cc \u0628\u0631\u0627\u06cc Backup \u06a9\u0627\u0645\u0644 \u06cc\u06a9 Database<\/h1>\n\n\n\n
\u0628\u0631\u0627\u06cc \u0627\u06a9\u062b\u0631 Database\u0647\u0627\u06cc InnoDB \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0627\u0632 \u0633\u0627\u062e\u062a\u0627\u0631 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f:<\/p>\n\n\n\n
mysqldump \\\n  --single-transaction \\\n  --quick \\\n  --routines \\\n  --events \\\n  --triggers \\\n  --hex-blob \\\n  --no-tablespaces \\\n  -u root \\\n  -p \\\n  database_name \\\n  > database_name.sql<\/code><\/pre>\n\n\n\n
\u06af\u0632\u06cc\u0646\u0647:<\/p>\n\n\n\n
--hex-blob<\/code><\/pre>\n\n\n\n
\u0628\u0631\u0627\u06cc Dump \u06a9\u0631\u062f\u0646 Binary Column\u0647\u0627 \u062f\u0631 \u0642\u0627\u0644\u0628 Hexadecimal \u0645\u0641\u06cc\u062f \u0627\u0633\u062a.<\/p>\n\n\n\n
\n\n\n\n
Backup \u0627\u0632 \u0647\u0645\u0647 Database\u0647\u0627<\/h1>\n\n\n\n
\u0628\u0631\u0627\u06cc Backup \u06a9\u0627\u0645\u0644 Database\u0647\u0627\u06cc MySQL Server:<\/p>\n\n\n\n
mysqldump \\\n  --all-databases \\\n  --single-transaction \\\n  --quick \\\n  --routines \\\n  --events \\\n  --triggers \\\n  --no-tablespaces \\\n  -u root \\\n  -p \\\n  > all_databases.sql<\/code><\/pre>\n\n\n\n
\u06af\u0632\u06cc\u0646\u0647:<\/p>\n\n\n\n
--all-databases<\/code><\/pre>\n\n\n\n
\u062a\u0645\u0627\u0645 Database\u0647\u0627\u06cc \u0642\u0627\u0628\u0644 Dump \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u0645\u06cc\u200c\u06a9\u0646\u062f.<\/p>\n\n\n\n
\u062f\u0631 Migration \u0628\u06cc\u0646 Version\u0647\u0627\u06cc Major \u0645\u062e\u062a\u0644\u0641 \u0628\u0647\u062a\u0631 \u0627\u0633\u062a System Database\u0647\u0627 \u0628\u062f\u0648\u0646 \u0628\u0631\u0631\u0633\u06cc \u0645\u0633\u062a\u0642\u06cc\u0645 Restore \u0646\u0634\u0648\u0646\u062f\u061b Database\u0647\u0627\u06cc \u0633\u06cc\u0633\u062a\u0645\u06cc\u060c User\u0647\u0627 \u0648 Privilege\u0647\u0627 \u0628\u0627\u06cc\u062f \u0645\u062a\u0646\u0627\u0633\u0628 \u0628\u0627 Version \u0645\u0642\u0635\u062f \u0645\u062f\u06cc\u0631\u06cc\u062a \u0634\u0648\u0646\u062f.<\/p>\n\n\n\n
\n\n\n\n
Backup \u0627\u0632 \u0686\u0646\u062f Database \u0645\u0634\u062e\u0635<\/h1>\n\n\n\n
\u0628\u0631\u0627\u06cc \u0645\u062b\u0627\u0644:<\/p>\n\n\n\n
mysqldump \\\n  --databases wordpress shop crm \\\n  --single-transaction \\\n  --quick \\\n  --routines \\\n  --events \\\n  --triggers \\\n  --no-tablespaces \\\n  -u root \\\n  -p \\\n  > selected_databases.sql<\/code><\/pre>\n\n\n\n
\u062f\u0631 \u0627\u06cc\u0646 \u0631\u0648\u0634 CREATE DATABASE<\/code> \u0648 USE<\/code> \u0646\u06cc\u0632 \u0628\u0631\u0627\u06cc Database\u0647\u0627\u06cc \u0627\u0646\u062a\u062e\u0627\u0628\u200c\u0634\u062f\u0647 \u062f\u0631 Dump \u0642\u0631\u0627\u0631 \u0645\u06cc\u200c\u06af\u06cc\u0631\u0646\u062f.<\/p>\n\n\n\n
\n\n\n\n
Backup \u0627\u0632 \u06cc\u06a9 Table<\/h1>\n\n\n\n
\u0628\u0631\u0627\u06cc Backup \u06cc\u06a9 Table:<\/p>\n\n\n\n
mysqldump \\\n  -u root \\\n  -p \\\n  database_name \\\n  table_name \\\n  > table_name.sql<\/code><\/pre>\n\n\n\n
\u0645\u062b\u0627\u0644:<\/p>\n\n\n\n
mysqldump \\\n  -u root \\\n  -p \\\n  wordpress \\\n  wp_options \\\n  > wp_options.sql<\/code><\/pre>\n\n\n\n
\n\n\n\n
Backup \u0686\u0646\u062f Table<\/h1>\n\n\n\n
mysqldump \\\n  -u root \\\n  -p \\\n  wordpress \\\n  wp_posts \\\n  wp_postmeta \\\n  wp_options \\\n  > wordpress_tables.sql<\/code><\/pre>\n\n\n\n
\n\n\n\n
Backup \u0641\u0642\u0637 \u0633\u0627\u062e\u062a\u0627\u0631 Database<\/h1>\n\n\n\n
\u0627\u06af\u0631 \u0641\u0642\u0637 Schema \u0648 \u0633\u0627\u062e\u062a\u0627\u0631 Table\u0647\u0627 \u0645\u0648\u0631\u062f\u0646\u06cc\u0627\u0632 \u0627\u0633\u062a:<\/p>\n\n\n\n
mysqldump \\\n  --no-data \\\n  -u root \\\n  -p \\\n  database_name \\\n  > database_schema.sql<\/code><\/pre>\n\n\n\n
\u0627\u06cc\u0646 Backup \u0634\u0627\u0645\u0644 Data \u0646\u0645\u06cc\u200c\u0634\u0648\u062f.<\/p>\n\n\n\n
\n\n\n\n
Backup \u0641\u0642\u0637 Data<\/h1>\n\n\n\n
\u0627\u06af\u0631 \u0641\u0642\u0637 \u0627\u0637\u0644\u0627\u0639\u0627\u062a Table\u0647\u0627 \u0645\u0648\u0631\u062f\u0646\u06cc\u0627\u0632 \u0628\u0627\u0634\u062f:<\/p>\n\n\n\n
mysqldump \\\n  --no-create-info \\\n  -u root \\\n  -p \\\n  database_name \\\n  > database_data.sql<\/code><\/pre>\n\n\n\n
\u062f\u0633\u062a\u0648\u0631\u0647\u0627\u06cc CREATE TABLE<\/code> \u062f\u0631 \u0627\u06cc\u0646 \u062d\u0627\u0644\u062a \u062f\u0631 Dump \u0642\u0631\u0627\u0631 \u0646\u0645\u06cc\u200c\u06af\u06cc\u0631\u0646\u062f.<\/p>\n\n\n\n
\n\n\n\n
Backup \u0628\u062e\u0634\u06cc \u0627\u0632 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u06cc\u06a9 Table<\/h1>\n\n\n\n
mysqldump<\/code> \u0627\u0645\u06a9\u0627\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0634\u0631\u0637 WHERE<\/code> \u0631\u0627 \u0646\u06cc\u0632 \u062f\u0627\u0631\u062f.<\/p>\n\n\n\n
\u0645\u062b\u0627\u0644:<\/p>\n\n\n\n
mysqldump \\\n  -u root \\\n  -p \\\n  database_name \\\n  orders \\\n  --where=\"created_at >= '2026-01-01'\" \\\n  > orders_2026.sql<\/code><\/pre>\n\n\n\n
\u0627\u06cc\u0646 \u0642\u0627\u0628\u0644\u06cc\u062a \u0628\u0631\u0627\u06cc Export \u06a9\u0631\u062f\u0646 \u0628\u062e\u0634\u06cc \u0627\u0632 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0628\u0633\u06cc\u0627\u0631 \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u0627\u0633\u062a.<\/p>\n\n\n\n
\n\n\n\n
\u062d\u0630\u0641 \u06cc\u06a9 Table \u0627\u0632 Backup<\/h1>\n\n\n\n
\u0645\u062b\u0644\u0627\u064b \u0628\u0631\u0627\u06cc \u062d\u0630\u0641 Table \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 Log:<\/p>\n\n\n\n
mysqldump \\\n  --single-transaction \\\n  --ignore-table=database_name.logs \\\n  -u root \\\n  -p \\\n  database_name \\\n  > database_without_logs.sql<\/code><\/pre>\n\n\n\n
\u0628\u0631\u0627\u06cc \u0686\u0646\u062f Table \u06af\u0632\u06cc\u0646\u0647 \u0631\u0627 \u0686\u0646\u062f \u0628\u0627\u0631 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f:<\/p>\n\n\n\n
mysqldump \\\n  --single-transaction \\\n  --ignore-table=database_name.logs \\\n  --ignore-table=database_name.sessions \\\n  -u root \\\n  -p \\\n  database_name \\\n  > database_backup.sql<\/code><\/pre>\n\n\n\n
\n\n\n\n
Backup \u0641\u0634\u0631\u062f\u0647 \u0628\u0627 gzip<\/h1>\n\n\n\n
\u0628\u0631\u0627\u06cc Database\u0647\u0627\u06cc \u0628\u0632\u0631\u06af \u0645\u0639\u0645\u0648\u0644\u0627\u064b \u0628\u0647\u062a\u0631 \u0627\u0633\u062a \u062e\u0631\u0648\u062c\u06cc \u0641\u0634\u0631\u062f\u0647 \u0634\u0648\u062f.<\/p>\n\n\n\n
mysqldump \\\n  --single-transaction \\\n  --quick \\\n  --routines \\\n  --events \\\n  --triggers \\\n  --no-tablespaces \\\n  -u root \\\n  -p \\\n  database_name \\\n  | gzip > database_name.sql.gz<\/code><\/pre>\n\n\n\n
\u0628\u0631\u0627\u06cc \u0645\u0634\u0627\u0647\u062f\u0647 \u062d\u062c\u0645 \u0641\u0627\u06cc\u0644:<\/p>\n\n\n\n
ls -lh database_name.sql.gz<\/code><\/pre>\n\n\n\n
\n\n\n\n
\u0646\u0627\u0645\u200c\u06af\u0630\u0627\u0631\u06cc Backup \u0628\u0627 \u062a\u0627\u0631\u06cc\u062e<\/h1>\n\n\n\n
\u0628\u0631\u0627\u06cc \u062c\u0644\u0648\u06af\u06cc\u0631\u06cc \u0627\u0632 Overwrite \u0634\u062f\u0646 Backup\u0647\u0627:<\/p>\n\n\n\n
mysqldump \\\n  --single-transaction \\\n  --quick \\\n  --routines \\\n  --events \\\n  --triggers \\\n  --no-tablespaces \\\n  -u root \\\n  -p \\\n  database_name \\\n  | gzip > \"database_name_$(date +%F_%H-%M-%S).sql.gz\"<\/code><\/pre>\n\n\n\n
\u062e\u0631\u0648\u062c\u06cc \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0645\u0634\u0627\u0628\u0647 \u0632\u06cc\u0631 \u0628\u0627\u0634\u062f:<\/p>\n\n\n\n
database_name_2026-11-03_02-00-00.sql.gz<\/code><\/pre>\n\n\n\n
\n\n\n\n
\u0627\u06cc\u062c\u0627\u062f Directory \u0645\u062e\u0635\u0648\u0635 Backup<\/h1>\n\n\n\n
mkdir -p \/backup\/mysql<\/code><\/pre>\n\n\n\n
Permission \u0645\u0646\u0627\u0633\u0628:<\/p>\n\n\n\n
chmod 700 \/backup\/mysql<\/code><\/pre>\n\n\n\n
\u0633\u067e\u0633:<\/p>\n\n\n\n
mysqldump \\\n  --single-transaction \\\n  --quick \\\n  --routines \\\n  --events \\\n  --triggers \\\n  --no-tablespaces \\\n  -u root \\\n  -p \\\n  database_name \\\n  | gzip > \"\/backup\/mysql\/database_name_$(date +%F_%H-%M-%S).sql.gz\"<\/code><\/pre>\n\n\n\n
\n\n\n\n
Backup \u0627\u0632 MySQL Remote Server<\/h1>\n\n\n\n
\u0628\u0631\u0627\u06cc Database \u0631\u0648\u06cc Server \u062f\u06cc\u06af\u0631:<\/p>\n\n\n\n
mysqldump \\\n  -h db.example.com \\\n  -P 3306 \\\n  --single-transaction \\\n  --quick \\\n  --routines \\\n  --events \\\n  --triggers \\\n  --no-tablespaces \\\n  -u backupuser \\\n  -p \\\n  database_name \\\n  > database_name.sql<\/code><\/pre>\n\n\n\n
\u062f\u0631 \u0627\u06cc\u0646 \u062d\u0627\u0644\u062a \u0641\u0627\u06cc\u0644 Backup \u0631\u0648\u06cc \u0633\u06cc\u0633\u062a\u0645\u06cc \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc\u200c\u0634\u0648\u062f \u06a9\u0647 \u062f\u0633\u062a\u0648\u0631 mysqldump<\/code> \u0631\u0648\u06cc \u0622\u0646 \u0627\u062c\u0631\u0627 \u0634\u062f\u0647 \u0627\u0633\u062a.<\/p>\n\n\n\n
\n\n\n\n
Backup \u0628\u0627 \u0627\u062a\u0635\u0627\u0644 TLS<\/h1>\n\n\n\n
\u0628\u0631\u0627\u06cc \u0627\u0631\u062a\u0628\u0627\u0637 Remote \u0631\u0648\u06cc \u0634\u0628\u06a9\u0647 \u063a\u06cc\u0631\u0642\u0627\u0628\u0644\u200c\u0627\u0639\u062a\u0645\u0627\u062f \u0628\u0647\u062a\u0631 \u0627\u0633\u062a TLS \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u0648\u062f.<\/p>\n\n\n\n
\u0646\u0645\u0648\u0646\u0647:<\/p>\n\n\n\n
mysqldump \\\n  -h db.example.com \\\n  -P 3306 \\\n  --ssl-mode=REQUIRED \\\n  --single-transaction \\\n  --quick \\\n  -u backupuser \\\n  -p \\\n  database_name \\\n  > database_name.sql<\/code><\/pre>\n\n\n\n
\u062f\u0631 \u0645\u062d\u06cc\u0637\u200c\u0647\u0627\u06cc \u062d\u0633\u0627\u0633\u200c\u062a\u0631 \u0628\u0627\u06cc\u062f Certificate Validation \u0646\u06cc\u0632 \u0645\u0637\u0627\u0628\u0642 \u0632\u06cc\u0631\u0633\u0627\u062e\u062a TLS \u0633\u0627\u0632\u0645\u0627\u0646 \u062a\u0646\u0638\u06cc\u0645 \u0634\u0648\u062f.<\/p>\n\n\n\n
\n\n\n\n
\u0628\u0631\u0631\u0633\u06cc \u0633\u0644\u0627\u0645\u062a \u0641\u0627\u06cc\u0644 Backup<\/h1>\n\n\n\n
\u067e\u0633 \u0627\u0632 Backup \u0641\u0642\u0637 \u0648\u062c\u0648\u062f \u0641\u0627\u06cc\u0644 \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u0646\u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n
\u0627\u0628\u062a\u062f\u0627 \u062d\u062c\u0645:<\/p>\n\n\n\n
ls -lh \/backup\/mysql\/<\/code><\/pre>\n\n\n\n
\u0628\u0631\u0627\u06cc \u0641\u0627\u06cc\u0644 \u0641\u0634\u0631\u062f\u0647:<\/p>\n\n\n\n
gzip -t database_name.sql.gz<\/code><\/pre>\n\n\n\n
\u0627\u06af\u0631 \u0641\u0627\u06cc\u0644 gzip \u0633\u0627\u0644\u0645 \u0628\u0627\u0634\u062f\u060c \u0645\u0639\u0645\u0648\u0644\u0627\u064b \u062f\u0633\u062a\u0648\u0631 \u0628\u062f\u0648\u0646 Error \u067e\u0627\u06cc\u0627\u0646 \u0645\u06cc\u200c\u06cc\u0627\u0628\u062f.<\/p>\n\n\n\n
\n\n\n\n
\u0628\u0631\u0631\u0633\u06cc \u0627\u0628\u062a\u062f\u0627\u06cc Dump<\/h1>\n\n\n\n
head -n 30 database_name.sql<\/code><\/pre>\n\n\n\n
\u0628\u0631\u0627\u06cc \u0641\u0627\u06cc\u0644 \u0641\u0634\u0631\u062f\u0647:<\/p>\n\n\n\n
zcat database_name.sql.gz | head -n 30<\/code><\/pre>\n\n\n\n
\n\n\n\n
\u0628\u0631\u0631\u0633\u06cc \u0648\u062c\u0648\u062f CREATE TABLE<\/h1>\n\n\n\n
grep -n \"CREATE TABLE\" database_name.sql | head<\/code><\/pre>\n\n\n\n
\u0628\u0631\u0627\u06cc \u0641\u0627\u06cc\u0644 \u0641\u0634\u0631\u062f\u0647:<\/p>\n\n\n\n
zgrep -n \"CREATE TABLE\" database_name.sql.gz | head<\/code><\/pre>\n\n\n\n
\n\n\n\n
\u0645\u062d\u0627\u0633\u0628\u0647 Hash<\/h1>\n\n\n\n
\u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f SHA256:<\/p>\n\n\n\n
sha256sum database_name.sql.gz<\/code><\/pre>\n\n\n\n
\u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0646\u062a\u06cc\u062c\u0647 \u0631\u0627 \u062f\u0631 \u0641\u0627\u06cc\u0644 \u0630\u062e\u06cc\u0631\u0647 \u06a9\u0631\u062f:<\/p>\n\n\n\n
sha256sum database_name.sql.gz > database_name.sql.gz.sha256<\/code><\/pre>\n\n\n\n
\u0628\u0631\u0631\u0633\u06cc \u0628\u0639\u062f\u06cc:<\/p>\n\n\n\n
sha256sum -c database_name.sql.gz.sha256<\/code><\/pre>\n\n\n\n
\u062e\u0631\u0648\u062c\u06cc \u0645\u0648\u0641\u0642:<\/p>\n\n\n\n
database_name.sql.gz: OK<\/code><\/pre>\n\n\n\n
\n\n\n\n
\u062a\u0633\u062a \u0648\u0627\u0642\u0639\u06cc Backup<\/h1>\n\n\n\n
\u0645\u0647\u0645\u200c\u062a\u0631\u06cc\u0646 \u062a\u0633\u062a Backup\u060c Restore \u0648\u0627\u0642\u0639\u06cc \u0622\u0646 \u0631\u0648\u06cc \u06cc\u06a9 Database \u0622\u0632\u0645\u0627\u06cc\u0634\u06cc \u0627\u0633\u062a.<\/p>\n\n\n\n
\u0627\u0628\u062a\u062f\u0627 Database Test \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f:<\/p>\n\n\n\n
CREATE DATABASE restore_test;<\/code><\/pre>\n\n\n\n
\u0633\u067e\u0633 Backup \u0631\u0627 Restore \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n
mysql -u root -p restore_test < database_name.sql<\/code><\/pre>\n\n\n\n
\u0628\u0639\u062f:<\/p>\n\n\n\n
USE restore_test;\nSHOW TABLES;<\/code><\/pre>\n\n\n\n
\u0648 Table\u0647\u0627\u06cc \u0645\u0647\u0645 \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n
SELECT COUNT(*) FROM important_table;<\/code><\/pre>\n\n\n\n
\u0627\u0635\u0644 \u0645\u0647\u0645:<\/p>\n\n\n\n
Backup Success\n\u2260\nRestore Success<\/code><\/pre>\n\n\n\n
\u06cc\u06a9 Backup \u0632\u0645\u0627\u0646\u06cc \u0642\u0627\u0628\u0644 \u0627\u062a\u06a9\u0627 \u0627\u0633\u062a \u06a9\u0647 Restore \u0622\u0646 \u0646\u06cc\u0632 \u062a\u0633\u062a \u0634\u062f\u0647 \u0628\u0627\u0634\u062f.<\/p>\n\n\n\n
\n\n\n\n
Restore \u06cc\u06a9 Database<\/h1>\n\n\n\n
\u0627\u06af\u0631 Dump \u0641\u0642\u0637 \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u06cc\u06a9 Database \u0627\u0633\u062a \u0648 CREATE DATABASE<\/code> \u062f\u0627\u062e\u0644 \u0622\u0646 \u0648\u062c\u0648\u062f \u0646\u062f\u0627\u0631\u062f\u060c \u0627\u0628\u062a\u062f\u0627 Database \u0645\u0642\u0635\u062f \u0631\u0627 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f:<\/p>\n\n\n\n
CREATE DATABASE database_name;<\/code><\/pre>\n\n\n\n
\u0633\u067e\u0633:<\/p>\n\n\n\n
mysql \\\n  -u root \\\n  -p \\\n  database_name \\\n  < database_name.sql<\/code><\/pre>\n\n\n\n
\n\n\n\n
Restore \u0641\u0627\u06cc\u0644 \u0641\u0634\u0631\u062f\u0647<\/h1>\n\n\n\n
\u0628\u0631\u0627\u06cc Backup \u0641\u0634\u0631\u062f\u0647:<\/p>\n\n\n\n
gunzip -c database_name.sql.gz \\\n  | mysql -u root -p database_name<\/code><\/pre>\n\n\n\n
\u06cc\u0627:<\/p>\n\n\n\n
zcat database_name.sql.gz \\\n  | mysql -u root -p database_name<\/code><\/pre>\n\n\n\n
\n\n\n\n
Restore Backup \u0686\u0646\u062f Database<\/h1>\n\n\n\n
\u0627\u06af\u0631 Backup \u0628\u0627 \u06af\u0632\u06cc\u0646\u0647:<\/p>\n\n\n\n
--databases<\/code><\/pre>\n\n\n\n
\u06cc\u0627:<\/p>\n\n\n\n
--all-databases<\/code><\/pre>\n\n\n\n
\u0627\u06cc\u062c\u0627\u062f \u0634\u062f\u0647 \u0628\u0627\u0634\u062f\u060c \u0645\u0639\u0645\u0648\u0644\u0627\u064b \u0641\u0627\u06cc\u0644 \u0634\u0627\u0645\u0644 CREATE DATABASE<\/code> \u0648 USE<\/code> \u0627\u0633\u062a.<\/p>\n\n\n\n
Restore:<\/p>\n\n\n\n
mysql -u root -p < all_databases.sql<\/code><\/pre>\n\n\n\n
MySQL \u0646\u06cc\u0632 \u0647\u0645\u06cc\u0646 \u0631\u0648\u0634 \u0631\u0627 \u0628\u0631\u0627\u06cc Reload \u06a9\u0631\u062f\u0646 Dump\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0634\u0627\u0645\u0644 Database Definition \u0647\u0633\u062a\u0646\u062f \u0645\u0633\u062a\u0646\u062f \u06a9\u0631\u062f\u0647 \u0627\u0633\u062a.<\/p>\n\n\n\n
\n\n\n\n
\u0628\u0631\u0631\u0633\u06cc Restore<\/h1>\n\n\n\n
\u067e\u0633 \u0627\u0632 Restore:<\/p>\n\n\n\n
SHOW DATABASES;<\/code><\/pre>\n\n\n\n
\u0633\u067e\u0633:<\/p>\n\n\n\n
USE database_name;<\/code><\/pre>\n\n\n\n
\u0648:<\/p>\n\n\n\n
SHOW TABLES;<\/code><\/pre>\n\n\n\n
\u0628\u0631\u0627\u06cc \u0628\u0631\u0631\u0633\u06cc \u062a\u0639\u062f\u0627\u062f Table\u0647\u0627:<\/p>\n\n\n\n
SELECT COUNT(*)\nFROM information_schema.tables\nWHERE table_schema = 'database_name';<\/code><\/pre>\n\n\n\n
\n\n\n\n
\u0628\u0631\u0631\u0633\u06cc Row Count<\/h1>\n\n\n\n
\u0628\u0631\u0627\u06cc Table\u0647\u0627\u06cc Critical:<\/p>\n\n\n\n
SELECT COUNT(*) FROM users;<\/code><\/pre>\n\n\n\n
\u06cc\u0627:<\/p>\n\n\n\n
SELECT COUNT(*) FROM orders;<\/code><\/pre>\n\n\n\n
\u0628\u0647\u062a\u0631 \u0627\u0633\u062a Row Count \u0648 \u0628\u0631\u062e\u06cc Business Data\u0647\u0627\u06cc \u0645\u0647\u0645 \u0628\u0627 Source \u0645\u0642\u0627\u06cc\u0633\u0647 \u0634\u0648\u0646\u062f.<\/p>\n\n\n\n
\n\n\n\n
\u0628\u0631\u0631\u0633\u06cc View\u0647\u0627<\/h1>\n\n\n\n
SHOW FULL TABLES\nWHERE TABLE_TYPE = 'VIEW';<\/code><\/pre>\n\n\n\n
\n\n\n\n
\u0628\u0631\u0631\u0633\u06cc Procedure\u0647\u0627<\/h1>\n\n\n\n
SHOW PROCEDURE STATUS\nWHERE Db = 'database_name';<\/code><\/pre>\n\n\n\n
\n\n\n\n
\u0628\u0631\u0631\u0633\u06cc Function\u0647\u0627<\/h1>\n\n\n\n
SHOW FUNCTION STATUS\nWHERE Db = 'database_name';<\/code><\/pre>\n\n\n\n
\n\n\n\n
\u0628\u0631\u0631\u0633\u06cc Event\u0647\u0627<\/h1>\n\n\n\n
SHOW EVENTS FROM database_name;<\/code><\/pre>\n\n\n\n
\n\n\n\n
\u0628\u0631\u0631\u0633\u06cc Trigger\u0647\u0627<\/h1>\n\n\n\n
SHOW TRIGGERS FROM database_name;<\/code><\/pre>\n\n\n\n
\u0627\u06cc\u0646 \u0628\u0631\u0631\u0633\u06cc \u0627\u0647\u0645\u06cc\u062a \u062f\u0627\u0631\u062f\u060c \u0632\u06cc\u0631\u0627 Backup \u0641\u0642\u0637 Table \u0648 Data \u0646\u06cc\u0633\u062a \u0648 Stored Object\u0647\u0627 \u0646\u06cc\u0632 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u0628\u062e\u0634\u06cc \u0627\u0632 Application \u0628\u0627\u0634\u0646\u062f.<\/p>\n\n\n\n
\n\n\n\n
Backup \u062f\u0631 Windows Server<\/h1>\n\n\n\n
\u062f\u0631 Windows Server \u0646\u06cc\u0632 mysqldump.exe<\/code> \u0642\u0627\u0628\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0633\u062a.<\/p>\n\n\n\n
\u0646\u0645\u0648\u0646\u0647:<\/p>\n\n\n\n
mysqldump.exe -u root -p database_name --result-file=C:\\Backup\\database_name.sql<\/code><\/pre>\n\n\n\n
\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 --result-file<\/code> \u062f\u0631 PowerShell \u0627\u0647\u0645\u06cc\u062a \u062f\u0627\u0631\u062f.<\/p>\n\n\n\n
\u0645\u0633\u062a\u0646\u062f\u0627\u062a \u0631\u0633\u0645\u06cc MySQL \u0647\u0634\u062f\u0627\u0631 \u0645\u06cc\u200c\u062f\u0647\u0646\u062f \u06a9\u0647 Redirect \u0628\u0627 ><\/code> \u062f\u0631 Windows PowerShell \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0641\u0627\u06cc\u0644 Dump \u0631\u0627 \u0628\u0627 UTF-16 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u062f\u061b \u0686\u0646\u06cc\u0646 \u0641\u0627\u06cc\u0644\u06cc \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0628\u0639\u062f\u0627\u064b \u0628\u0647\u200c\u062f\u0631\u0633\u062a\u06cc \u062a\u0648\u0633\u0637 MySQL Client Load \u0646\u0634\u0648\u062f. \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 --result-file<\/code> \u0627\u06cc\u0646 \u0645\u0634\u06a9\u0644 \u0631\u0627 \u0628\u0631\u0637\u0631\u0641 \u0645\u06cc\u200c\u06a9\u0646\u062f.<\/p>\n\n\n\n
\n\n\n\n
Backup \u06a9\u0627\u0645\u0644 \u062f\u0631 Windows Server<\/h1>\n\n\n\n
mysqldump.exe `\n  --single-transaction `\n  --quick `\n  --routines `\n  --events `\n  --triggers `\n  --no-tablespaces `\n  -u root `\n  -p `\n  database_name `\n  --result-file=C:\\Backup\\database_name.sql<\/code><\/pre>\n\n\n\n
\n\n\n\n
Restore \u062f\u0631 Windows Server<\/h1>\n\n\n\n
\u062f\u0631 Command Prompt:<\/p>\n\n\n\n
mysql.exe -u root -p database_name < C:\\Backup\\database_name.sql<\/code><\/pre>\n\n\n\n
\u062f\u0631 PowerShell \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 Command Prompt \u0631\u0627 \u0641\u0631\u0627\u062e\u0648\u0627\u0646\u06cc \u06a9\u0631\u062f:<\/p>\n\n\n\n
cmd.exe \/c \"mysql.exe -u root -p database_name < C:\\Backup\\database_name.sql\"<\/code><\/pre>\n\n\n\n
\u0627\u06cc\u0646 \u0631\u0648\u0634 \u0646\u06cc\u0632 \u062f\u0631 \u0645\u0633\u062a\u0646\u062f\u0627\u062a \u0631\u0633\u0645\u06cc MySQL \u0628\u0631\u0627\u06cc Reload \u06a9\u0631\u062f\u0646 Dump \u062f\u0631 PowerShell \u067e\u06cc\u0634\u0646\u0647\u0627\u062f \u0634\u062f\u0647 \u0627\u0633\u062a.<\/p>\n\n\n\n
\n\n\n\n
\u0628\u0631\u0631\u0633\u06cc Hash \u062f\u0631 Windows Server<\/h1>\n\n\n\n
Get-FileHash \"C:\\Backup\\database_name.sql\" -Algorithm SHA256<\/code><\/pre>\n\n\n\n
\u0628\u0631\u0627\u06cc \u0641\u0627\u06cc\u0644\u200c\u0647\u0627\u06cc Backup \u0645\u0647\u0645 \u0628\u0647\u062a\u0631 \u0627\u0633\u062a Hash \u0647\u0645\u0631\u0627\u0647 Backup \u0630\u062e\u06cc\u0631\u0647 \u0634\u0648\u062f.<\/p>\n\n\n\n
\n\n\n\n
Backup \u0628\u062f\u0648\u0646 \u0642\u0631\u0627\u0631 \u062f\u0627\u062f\u0646 Password \u062f\u0631 Command<\/h1>\n\n\n\n
\u0627\u0632 \u0646\u0648\u0634\u062a\u0646 Password \u0645\u0633\u062a\u0642\u06cc\u0645 \u062f\u0627\u062e\u0644 Command \u062e\u0648\u062f\u062f\u0627\u0631\u06cc \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n
\u0646\u0645\u0648\u0646\u0647 \u0646\u0627\u0645\u0646\u0627\u0633\u0628:<\/p>\n\n\n\n
mysqldump -u root -pMyPassword database_name<\/code><\/pre>\n\n\n\n
\u0632\u06cc\u0631\u0627 Password \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u062f\u0631 Shell History \u06cc\u0627 Process List \u0642\u0627\u0628\u0644 \u0645\u0634\u0627\u0647\u062f\u0647 \u0628\u0627\u0634\u062f.<\/p>\n\n\n\n
\u0631\u0648\u0634 \u0645\u0639\u0645\u0648\u0644:<\/p>\n\n\n\n
mysqldump -u root -p database_name > database_name.sql<\/code><\/pre>\n\n\n\n
\u0633\u067e\u0633 Password \u0628\u0647\u200c\u0635\u0648\u0631\u062a Interactive \u0648\u0627\u0631\u062f \u0634\u0648\u062f.<\/p>\n\n\n\n
\n\n\n\n
\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 mysql_config_editor<\/h1>\n\n\n\n
\u0628\u0631\u0627\u06cc Automation \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0627\u0632 Login Path \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f.<\/p>\n\n\n\n
\u0627\u0628\u062a\u062f\u0627:<\/p>\n\n\n\n
mysql_config_editor set \\\n  --login-path=backup \\\n  --host=localhost \\\n  --user=backupuser \\\n  --password<\/code><\/pre>\n\n\n\n
\u0633\u067e\u0633:<\/p>\n\n\n\n
mysqldump \\\n  --login-path=backup \\\n  --single-transaction \\\n  --quick \\\n  --routines \\\n  --events \\\n  --triggers \\\n  --no-tablespaces \\\n  database_name \\\n  > database_name.sql<\/code><\/pre>\n\n\n\n
\u0628\u0647 \u0627\u06cc\u0646 \u062a\u0631\u062a\u06cc\u0628 Password \u0645\u0633\u062a\u0642\u06cc\u0645\u0627\u064b \u062f\u0627\u062e\u0644 Script \u0642\u0631\u0627\u0631 \u0646\u0645\u06cc\u200c\u06af\u06cc\u0631\u062f.<\/p>\n\n\n\n
\n\n\n\n
\u0627\u06cc\u062c\u0627\u062f User \u0645\u062e\u0635\u0648\u0635 Backup<\/h1>\n\n\n\n
\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u062f\u0627\u0626\u0645\u06cc \u0627\u0632 root<\/code> \u0628\u0631\u0627\u06cc Backup Automation \u0627\u0646\u062a\u062e\u0627\u0628 \u0645\u0646\u0627\u0633\u0628\u06cc \u0646\u06cc\u0633\u062a.<\/p>\n\n\n\n
\u0645\u06cc\u200c\u062a\u0648\u0627\u0646 User \u062c\u062f\u0627\u06af\u0627\u0646\u0647 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0631\u062f.<\/p>\n\n\n\n
CREATE USER 'backupuser'@'localhost'\nIDENTIFIED BY 'StrongPassword';<\/code><\/pre>\n\n\n\n
\u0633\u067e\u0633 Permission\u0647\u0627\u06cc \u0644\u0627\u0632\u0645 \u0645\u062a\u0646\u0627\u0633\u0628 \u0628\u0627 Backup Policy \u0627\u062e\u062a\u0635\u0627\u0635 \u062f\u0627\u062f\u0647 \u0634\u0648\u0646\u062f.<\/p>\n\n\n\n
\u062d\u062f\u0627\u0642\u0644 Permission \u0645\u0648\u0631\u062f\u0646\u06cc\u0627\u0632 \u0628\u0647 Object\u0647\u0627\u06cc\u06cc \u06a9\u0647 Dump \u0645\u06cc\u200c\u0634\u0648\u0646\u062f \u0648 Option\u0647\u0627\u06cc mysqldump<\/code> \u0628\u0633\u062a\u06af\u06cc \u062f\u0627\u0631\u062f. \u0628\u0631\u0627\u06cc \u0645\u062b\u0627\u0644 SELECT<\/code> \u0628\u0631\u0627\u06cc Table\u0647\u0627\u060c SHOW VIEW<\/code> \u0628\u0631\u0627\u06cc View\u0647\u0627 \u0648 TRIGGER<\/code> \u0628\u0631\u0627\u06cc Trigger\u0647\u0627 \u0645\u0648\u0631\u062f\u0646\u06cc\u0627\u0632 \u0627\u0633\u062a. \u0627\u06af\u0631 --no-tablespaces<\/code> \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0646\u0634\u0648\u062f\u060c \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a PROCESS<\/code> \u0646\u06cc\u0632 \u0645\u0648\u0631\u062f\u0646\u06cc\u0627\u0632 \u0628\u0627\u0634\u062f.<\/p>\n\n\n\n
\u0627\u0635\u0644 \u06a9\u0644\u06cc \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 User \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 Backup \u0641\u0642\u0637 Permission\u0647\u0627\u06cc \u0645\u0648\u0631\u062f\u0646\u06cc\u0627\u0632 \u0631\u0627 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u062f.<\/p>\n\n\n\n
\n\n\n\n
Automation \u0628\u06a9\u0627\u067e \u0628\u0627 Cron<\/h1>\n\n\n\n
\u0627\u0628\u062a\u062f\u0627 Script \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f:<\/p>\n\n\n\n
nano \/usr\/local\/sbin\/mysql-backup.sh<\/code><\/pre>\n\n\n\n
\u0646\u0645\u0648\u0646\u0647:<\/p>\n\n\n\n
#!\/bin\/bash\n\nBACKUP_DIR=\"\/backup\/mysql\"\nDATABASE=\"database_name\"\nDATE=\"$(date +%F_%H-%M-%S)\"\nBACKUP_FILE=\"${BACKUP_DIR}\/${DATABASE}_${DATE}.sql.gz\"\n\nmkdir -p \"$BACKUP_DIR\"\n\nmysqldump \\\n  --login-path=backup \\\n  --single-transaction \\\n  --quick \\\n  --routines \\\n  --events \\\n  --triggers \\\n  --no-tablespaces \\\n  \"$DATABASE\" \\\n  | gzip > \"$BACKUP_FILE\"\n\nif gzip -t \"$BACKUP_FILE\"; then\n    sha256sum \"$BACKUP_FILE\" > \"${BACKUP_FILE}.sha256\"\n    echo \"Backup completed successfully: $BACKUP_FILE\"\nelse\n    echo \"Backup verification failed: $BACKUP_FILE\"\n    exit 1\nfi<\/code><\/pre>\n\n\n\n
Permission:<\/p>\n\n\n\n
chmod 700 \/usr\/local\/sbin\/mysql-backup.sh<\/code><\/pre>\n\n\n\n
\u062a\u0633\u062a:<\/p>\n\n\n\n
\/usr\/local\/sbin\/mysql-backup.sh<\/code><\/pre>\n\n\n\n
\n\n\n\n
\u0627\u062c\u0631\u0627\u06cc Cron<\/h1>\n\n\n\n
\u0628\u0631\u0627\u06cc \u0645\u062b\u0627\u0644 Backup \u0631\u0648\u0632\u0627\u0646\u0647 \u0633\u0627\u0639\u062a 02:00:<\/p>\n\n\n\n
0 2 * * * \/usr\/local\/sbin\/mysql-backup.sh >> \/var\/log\/mysql-backup.log 2>&1<\/code><\/pre>\n\n\n\n
\u062f\u0631 crontab<\/code>:<\/p>\n\n\n\n
crontab -e<\/code><\/pre>\n\n\n\n
\u0648 \u0633\u067e\u0633 \u0647\u0645\u0627\u0646 Job \u0631\u0627 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n
\n\n\n\n
\u062d\u0630\u0641 Backup\u0647\u0627\u06cc \u0642\u062f\u06cc\u0645\u06cc<\/h1>\n\n\n\n
\u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f Retention \u0628\u0631\u0627\u0628\u0631 30 \u0631\u0648\u0632 \u0628\u0627\u0634\u062f:<\/p>\n\n\n\n
find \/backup\/mysql \\\n  -type f \\\n  -name \"*.sql.gz\" \\\n  -mtime +30 \\\n  -delete<\/code><\/pre>\n\n\n\n
\u0628\u0631\u0627\u06cc \u0641\u0627\u06cc\u0644 Hash:<\/p>\n\n\n\n
find \/backup\/mysql \\\n  -type f \\\n  -name \"*.sha256\" \\\n  -mtime +30 \\\n  -delete<\/code><\/pre>\n\n\n\n
\u0642\u0628\u0644 \u0627\u0632 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u062f\u0631 Production\u060c \u062f\u0633\u062a\u0648\u0631 find<\/code> \u0631\u0627 \u0628\u062f\u0648\u0646 -delete<\/code> \u062a\u0633\u062a \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n
\n\n\n\n
Backup \u0645\u062d\u0644\u06cc \u0628\u0647\u200c\u062a\u0646\u0647\u0627\u06cc\u06cc \u06a9\u0627\u0641\u06cc \u0646\u06cc\u0633\u062a<\/h1>\n\n\n\n
\u0633\u0627\u062e\u062a\u0627\u0631 \u0632\u06cc\u0631 \u0631\u06cc\u0633\u06a9 \u0628\u0627\u0644\u0627\u06cc\u06cc \u062f\u0627\u0631\u062f:<\/p>\n\n\n\n
MySQL Server\n\u2193\n\/backup\/mysql<\/code><\/pre>\n\n\n\n
\u0627\u06af\u0631 Server\u060c Disk \u06cc\u0627 File System \u0627\u0632 \u0628\u06cc\u0646 \u0628\u0631\u0648\u062f\u060c \u0647\u0645 Database \u0648 \u0647\u0645 Backup \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0627\u0632 \u062f\u0633\u062a \u0628\u0631\u0648\u0646\u062f.<\/p>\n\n\n\n
\u0645\u0639\u0645\u0627\u0631\u06cc \u0628\u0647\u062a\u0631:<\/p>\n\n\n\n
MySQL Server\n\u2193\nLocal Backup\n\u2193\nRemote Backup\n\u2193\nOff-Site \/ Immutable Storage<\/code><\/pre>\n\n\n\n
\u0628\u0647\u062a\u0631 \u0627\u0633\u062a Backup Strategy \u0628\u0627 \u0645\u062f\u0644\u200c\u0647\u0627\u06cc\u06cc \u0645\u0627\u0646\u0646\u062f 3-2-1 Backup<\/code> \u0637\u0631\u0627\u062d\u06cc \u0634\u0648\u062f.<\/p>\n\n\n\n
\n\n\n\n
\u0627\u0646\u062a\u0642\u0627\u0644 Backup \u0628\u0647 Server \u062f\u06cc\u06af\u0631<\/h1>\n\n\n\n
\u0628\u0627 scp<\/code>:<\/p>\n\n\n\n
scp \\\n  database_name.sql.gz \\\n  backupuser@backup.example.com:\/backup\/mysql\/<\/code><\/pre>\n\n\n\n
\u06cc\u0627 \u0628\u0627 rsync<\/code>:<\/p>\n\n\n\n
rsync \\\n  -av \\\n  database_name.sql.gz \\\n  backupuser@backup.example.com:\/backup\/mysql\/<\/code><\/pre>\n\n\n\n
\n\n\n\n
Point-in-Time Recovery \u0686\u06cc\u0633\u062a\u061f<\/h1>\n\n\n\n
Full Backup \u0641\u0642\u0637 Database \u0631\u0627 \u0628\u0647 \u0632\u0645\u0627\u0646 Backup \u0628\u0631\u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f.<\/p>\n\n\n\n
\u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f Full Backup \u0633\u0627\u0639\u062a \u0632\u06cc\u0631 \u0627\u06cc\u062c\u0627\u062f \u0634\u062f\u0647 \u0627\u0633\u062a:<\/p>\n\n\n\n
02:00<\/code><\/pre>\n\n\n\n
\u0648 \u0645\u0634\u06a9\u0644 \u0633\u0627\u0639\u062a \u0632\u06cc\u0631 \u0631\u062e \u062f\u0627\u062f\u0647 \u0627\u0633\u062a:<\/p>\n\n\n\n
15:30<\/code><\/pre>\n\n\n\n
\u0627\u06af\u0631 \u0641\u0642\u0637 Full Backup \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f\u060c \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u0628\u06cc\u0646 \u0627\u06cc\u0646 \u062f\u0648 \u0632\u0645\u0627\u0646 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0627\u0632 \u062f\u0633\u062a \u0628\u0631\u0648\u0646\u062f.<\/p>\n\n\n\n
\u0628\u0631\u0627\u06cc Recovery \u062f\u0642\u06cc\u0642\u200c\u062a\u0631 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0627\u0632 Binary Log \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f.<\/p>\n\n\n\n
\u0633\u0627\u062e\u062a\u0627\u0631:<\/p>\n\n\n\n
Full Backup\n\u2193\nRestore\n\u2193\nBinary Logs\n\u2193\nReplay Transactions\n\u2193\nTarget Recovery Point<\/code><\/pre>\n\n\n\n
MySQL \u0627\u06cc\u0646 \u0631\u0648\u0634 \u0631\u0627 Point-in-Time Recovery \u0645\u06cc\u200c\u0646\u0627\u0645\u062f.<\/p>\n\n\n\n
\n\n\n\n
\u0628\u0631\u0631\u0633\u06cc \u0641\u0639\u0627\u0644 \u0628\u0648\u062f\u0646 Binary Log<\/h1>\n\n\n\n
SHOW VARIABLES LIKE 'log_bin';<\/code><\/pre>\n\n\n\n
\u062e\u0631\u0648\u062c\u06cc \u0645\u0648\u0631\u062f \u0627\u0646\u062a\u0638\u0627\u0631:<\/p>\n\n\n\n
log_bin    ON<\/code><\/pre>\n\n\n\n
\u0628\u0631\u0627\u06cc \u0645\u0634\u0627\u0647\u062f\u0647 Binary Log\u0647\u0627:<\/p>\n\n\n\n
SHOW BINARY LOGS;<\/code><\/pre>\n\n\n\n
\n\n\n\n
\u0645\u0634\u0627\u0647\u062f\u0647 Binary Log<\/h1>\n\n\n\n
mysqlbinlog binlog.000001<\/code><\/pre>\n\n\n\n
\n\n\n\n
\u0627\u0639\u0645\u0627\u0644 Binary Log<\/h1>\n\n\n\n
mysqlbinlog \\\n  binlog.000001 \\\n  binlog.000002 \\\n  | mysql -u root -p<\/code><\/pre>\n\n\n\n
MySQL \u0628\u0631\u0627\u06cc Point-in-Time Recovery \u0627\u0628\u062a\u062f\u0627 Restore \u06a9\u0631\u062f\u0646 Full Backup \u0648 \u0633\u067e\u0633 \u0627\u0639\u0645\u0627\u0644 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a Binary Log \u0631\u0627 \u0645\u0633\u062a\u0646\u062f \u06a9\u0631\u062f\u0647 \u0627\u0633\u062a.<\/p>\n\n\n\n
\n\n\n\n
Backup \u0628\u0627 MySQL Shell<\/h1>\n\n\n\n
\u0628\u0631\u0627\u06cc Database\u0647\u0627\u06cc \u0628\u0632\u0631\u06af\u060c mysqldump<\/code> \u0647\u0645\u06cc\u0634\u0647 \u0628\u0647\u062a\u0631\u06cc\u0646 \u06af\u0632\u06cc\u0646\u0647 \u0646\u06cc\u0633\u062a.<\/p>\n\n\n\n
MySQL Shell \u0627\u0628\u0632\u0627\u0631\u0647\u0627\u06cc \u0632\u06cc\u0631 \u0631\u0627 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc\u200c\u06a9\u0646\u062f:<\/p>\n\n\n\n
util.dumpInstance()\nutil.dumpSchemas()\nutil.dumpTables()\nutil.loadDump()<\/code><\/pre>\n\n\n\n
\u0627\u06cc\u0646 \u0627\u0628\u0632\u0627\u0631\u0647\u0627 \u0627\u0645\u06a9\u0627\u0646\u0627\u062a\u06cc \u0645\u0627\u0646\u0646\u062f Parallel Dump\u060c Compression\u060c Progress Tracking \u0648 Parallel Restore \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc\u200c\u06a9\u0646\u0646\u062f.<\/p>\n\n\n\n
\n\n\n\n
Backup \u06cc\u06a9 Schema \u0628\u0627 MySQL Shell<\/h1>\n\n\n\n
\u0645\u062b\u0627\u0644 CLI:<\/p>\n\n\n\n
mysqlsh \\\n  root@localhost \\\n  -- \\\n  util dump-schemas \\\n  database_name \\\n  --outputUrl=\/backup\/mysql\/database_dump<\/code><\/pre>\n\n\n\n
\n\n\n\n
Backup \u0686\u0646\u062f Schema<\/h1>\n\n\n\n
mysqlsh \\\n  root@localhost \\\n  -- \\\n  util dump-schemas \\\n  wordpress \\\n  shop \\\n  crm \\\n  --outputUrl=\/backup\/mysql\/selected_databases<\/code><\/pre>\n\n\n\n
Syntax \u0631\u0633\u0645\u06cc MySQL Shell \u0628\u0631\u0627\u06cc dump-schemas<\/code> \u0627\u062c\u0627\u0632\u0647 \u0627\u0646\u062a\u062e\u0627\u0628 \u0686\u0646\u062f Schema \u0648 \u0645\u0634\u062e\u0635 \u06a9\u0631\u062f\u0646 outputUrl<\/code> \u0631\u0627 \u0641\u0631\u0627\u0647\u0645 \u0645\u06cc\u200c\u06a9\u0646\u062f.<\/p>\n\n\n\n
\n\n\n\n
Backup \u06a9\u0627\u0645\u0644 Instance \u0628\u0627 MySQL Shell<\/h1>\n\n\n\n
mysqlsh \\\n  root@localhost \\\n  -- \\\n  util dump-instance \\\n  --outputUrl=\/backup\/mysql\/full_instance<\/code><\/pre>\n\n\n\n
\n\n\n\n
Restore Dump \u0633\u0627\u062e\u062a\u0647\u200c\u0634\u062f\u0647 \u0628\u0627 MySQL Shell<\/h1>\n\n\n\n
Dump\u0647\u0627\u06cc MySQL Shell \u062a\u0648\u0633\u0637 util.loadDump()<\/code> \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0645\u06cc\u200c\u0634\u0648\u0646\u062f.<\/p>\n\n\n\n
\u0633\u0627\u062e\u062a\u0627\u0631 \u0645\u0641\u0647\u0648\u0645\u06cc:<\/p>\n\n\n\n
MySQL Shell Dump\n\u2193\nutil.loadDump()\n\u2193\nParallel Restore\n\u2193\nMySQL Server<\/code><\/pre>\n\n\n\n
MySQL Shell \u0639\u0644\u0627\u0648\u0647 \u0628\u0631 Load \u0645\u0648\u0627\u0632\u06cc\u060c \u0627\u0645\u06a9\u0627\u0646 Track \u06a9\u0631\u062f\u0646 Progress \u0648 Resume \u0639\u0645\u0644\u06cc\u0627\u062a \u0631\u0627 \u0646\u06cc\u0632 \u0641\u0631\u0627\u0647\u0645 \u0645\u06cc\u200c\u06a9\u0646\u062f.<\/p>\n\n\n\n
\n\n\n\n
\u0686\u0647 \u0632\u0645\u0627\u0646\u06cc \u0627\u0632 mysqldump \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645\u061f<\/h1>\n\n\n\n
mysqldump<\/code> \u0645\u0639\u0645\u0648\u0644\u0627\u064b \u0628\u0631\u0627\u06cc \u0645\u0648\u0627\u0631\u062f \u0632\u06cc\u0631 \u0645\u0646\u0627\u0633\u0628 \u0627\u0633\u062a:<\/p>\n\n\n\n
Small Databases\nMedium Databases\nPortable Backups\nMigrations\nSingle Database Backup\nTable Backup\nSchema Backup\nSimple Automation<\/code><\/pre>\n\n\n\n
\n\n\n\n
\u0686\u0647 \u0632\u0645\u0627\u0646\u06cc MySQL Shell \u0645\u0646\u0627\u0633\u0628\u200c\u062a\u0631 \u0627\u0633\u062a\u061f<\/h1>\n\n\n\n
MySQL Shell \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0628\u0631\u0627\u06cc \u0645\u0648\u0627\u0631\u062f \u0632\u06cc\u0631 \u0645\u0646\u0627\u0633\u0628\u200c\u062a\u0631 \u0628\u0627\u0634\u062f:<\/p>\n\n\n\n
Large Databases\nParallel Backup\nParallel Restore\nFaster Logical Migration\nMultiple Schemas\nCloud Storage Workflows\nProgress Monitoring<\/code><\/pre>\n\n\n\n
\u0628\u0631\u0627\u06cc Data Set\u0647\u0627\u06cc \u0628\u0632\u0631\u06af\u060c Performance \u0648\u0627\u0642\u0639\u06cc Backup \u0648 Restore \u0628\u0627\u06cc\u062f \u0642\u0628\u0644 \u0627\u0632 \u0637\u0631\u0627\u062d\u06cc Production Benchmark \u0634\u0648\u062f.<\/p>\n\n\n\n
\n\n\n\n
Physical Backup<\/h1>\n\n\n\n
\u062f\u0631 Physical Backup \u0641\u0627\u06cc\u0644\u200c\u0647\u0627\u06cc \u0648\u0627\u0642\u0639\u06cc Database \u06cc\u0627 Data Directory Backup \u0645\u06cc\u200c\u0634\u0648\u0646\u062f.<\/p>\n\n\n\n
\u0633\u0627\u062e\u062a\u0627\u0631:<\/p>\n\n\n\n
MySQL Data Files\n\u2193\nPhysical Backup\n\u2193\nBackup Repository<\/code><\/pre>\n\n\n\n
\u0627\u06cc\u0646 \u0631\u0648\u0634 \u0628\u0631\u0627\u06cc Database\u0647\u0627\u06cc \u0628\u0632\u0631\u06af \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f Recovery \u0633\u0631\u06cc\u0639\u200c\u062a\u0631\u06cc \u0641\u0631\u0627\u0647\u0645 \u06a9\u0646\u062f\u060c \u0627\u0645\u0627 \u0631\u0648\u0634 Backup \u0628\u0627\u06cc\u062f \u06a9\u0627\u0645\u0644\u0627\u064b \u0628\u0627 Storage Engine \u0648 MySQL Version \u0633\u0627\u0632\u06af\u0627\u0631 \u0628\u0627\u0634\u062f.<\/p>\n\n\n\n
\u06a9\u067e\u06cc \u0645\u0633\u062a\u0642\u06cc\u0645 \u0641\u0627\u06cc\u0644\u200c\u0647\u0627\u06cc Data Directory \u062f\u0631 \u062d\u0627\u0644\u06cc \u06a9\u0647 MySQL \u062f\u0631 \u062d\u0627\u0644 \u062a\u063a\u06cc\u06cc\u0631 Data \u0627\u0633\u062a\u060c \u0631\u0648\u0634 Backup \u0642\u0627\u0628\u0644 \u0627\u062a\u06a9\u0627\u06cc\u06cc \u0646\u06cc\u0633\u062a \u0645\u06af\u0631 \u0627\u06cc\u0646\u06a9\u0647 Consistency \u0628\u0647 \u0631\u0648\u0634 \u0635\u062d\u06cc\u062d \u062a\u0636\u0645\u06cc\u0646 \u0634\u0648\u062f.<\/p>\n\n\n\n
\n\n\n\n
\u0627\u0634\u062a\u0628\u0627\u0647\u0627\u062a \u0631\u0627\u06cc\u062c \u062f\u0631 Backup \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 MySQL<\/h1>\n\n\n\n
\u0641\u0642\u0637 \u06af\u0631\u0641\u062a\u0646 Backup \u0648 \u062a\u0633\u062a \u0646\u06a9\u0631\u062f\u0646 Restore<\/h2>\n\n\n\n
\u0648\u062c\u0648\u062f \u0641\u0627\u06cc\u0644 SQL \u0628\u0647 \u0645\u0639\u0646\u06cc \u0642\u0627\u0628\u0644 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0628\u0648\u062f\u0646 \u0622\u0646 \u0646\u06cc\u0633\u062a.<\/p>\n\n\n\n
\u0642\u0631\u0627\u0631 \u062f\u0627\u062f\u0646 Password \u062f\u0627\u062e\u0644 Script<\/h2>\n\n\n\n
\u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f Credential \u0631\u0627 \u062f\u0631 \u0645\u0639\u0631\u0636 \u062e\u0637\u0631 \u0642\u0631\u0627\u0631 \u062f\u0647\u062f.<\/p>\n\n\n\n
Backup \u0641\u0642\u0637 \u0631\u0648\u06cc \u0647\u0645\u0627\u0646 Server<\/h2>\n\n\n\n
\u062e\u0631\u0627\u0628\u06cc Server \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a Backup \u0631\u0627 \u0646\u06cc\u0632 \u0627\u0632 \u0628\u06cc\u0646 \u0628\u0628\u0631\u062f.<\/p>\n\n\n\n
\u0641\u0631\u0627\u0645\u0648\u0634 \u06a9\u0631\u062f\u0646 Routine\u0647\u0627 \u0648 Event\u0647\u0627<\/h2>\n\n\n\n
\u0641\u0642\u0637 Table \u0648 Data \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0628\u0631\u0627\u06cc Recovery \u06a9\u0627\u0645\u0644 Application \u06a9\u0627\u0641\u06cc \u0646\u0628\u0627\u0634\u0646\u062f.<\/p>\n\n\n\n
\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0646\u0627\u062f\u0631\u0633\u062a \u0627\u0632 single-transaction<\/h2>\n\n\n\n
\u0627\u06cc\u0646 \u06af\u0632\u06cc\u0646\u0647 Consistency \u06a9\u0627\u0645\u0644 \u0631\u0627 \u0628\u0631\u0627\u06cc InnoDB \u0641\u0631\u0627\u0647\u0645 \u0645\u06cc\u200c\u06a9\u0646\u062f\u060c \u0646\u0647 \u062a\u0645\u0627\u0645 Storage Engine\u0647\u0627.<\/p>\n\n\n\n
\u0646\u062f\u0627\u0634\u062a\u0646 Retention Policy<\/h2>\n\n\n\n
Backup \u0642\u062f\u06cc\u0645\u06cc \u0628\u0627\u06cc\u062f \u0645\u0637\u0627\u0628\u0642 Policy \u0645\u062f\u06cc\u0631\u06cc\u062a \u0634\u0648\u062f.<\/p>\n\n\n\n
\u0646\u062f\u0627\u0634\u062a\u0646 Monitoring<\/h2>\n\n\n\n
Cron Job \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f Fail \u0634\u0648\u062f \u0628\u062f\u0648\u0646 \u0627\u06cc\u0646\u06a9\u0647 Administrator \u0645\u062a\u0648\u062c\u0647 \u0634\u0648\u062f.<\/p>\n\n\n\n
\u0646\u062f\u0627\u0634\u062a\u0646 Off-Site Backup<\/h2>\n\n\n\n
Backup \u0645\u062d\u0644\u06cc \u0646\u0628\u0627\u06cc\u062f \u062a\u0646\u0647\u0627 Recovery Copy \u0628\u0627\u0634\u062f.<\/p>\n\n\n\n
Restore \u0645\u0633\u062a\u0642\u06cc\u0645 \u0631\u0648\u06cc Production<\/h2>\n\n\n\n
\u0628\u0631\u0627\u06cc Test Backup \u0628\u0647\u062a\u0631 \u0627\u0633\u062a Database \u06cc\u0627 Server \u0622\u0632\u0645\u0627\u06cc\u0634\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u0648\u062f.<\/p>\n\n\n\n
\n\n\n\n
\u0686\u06a9\u200c\u0644\u06cc\u0633\u062a \u0642\u0628\u0644 \u0627\u0632 Backup<\/h1>\n\n\n\n
MySQL Service Running\n\u2193\nDatabase Identified\n\u2193\nStorage Engine Checked\n\u2193\nAvailable Disk Space Checked\n\u2193\nBackup User Verified\n\u2193\nBackup Destination Checked\n\u2193\nRetention Policy Checked\n\u2193\nOff-Site Destination Checked<\/code><\/pre>\n\n\n\n
\n\n\n\n
\u0686\u06a9\u200c\u0644\u06cc\u0633\u062a \u0628\u0639\u062f \u0627\u0632 Backup<\/h1>\n\n\n\n
Backup File Exists\n\u2193\nBackup Size Checked\n\u2193\nCompression Verified\n\u2193\nSHA256 Generated\n\u2193\nBackup Log Checked\n\u2193\nOff-Site Copy Completed\n\u2193\nRestore Test Completed\n\u2193\nBackup Monitoring Confirmed<\/code><\/pre>\n\n\n\n
\n\n\n\n
\u0646\u0645\u0648\u0646\u0647 \u0645\u0639\u0645\u0627\u0631\u06cc \u067e\u06cc\u0634\u0646\u0647\u0627\u062f\u06cc<\/h1>\n\n\n\n
\u0628\u0631\u0627\u06cc \u06cc\u06a9 MySQL Server \u0633\u0627\u0632\u0645\u0627\u0646\u06cc:<\/p>\n\n\n\n
MySQL Production\n        \u2193\nDaily Logical Backup\n        \u2193\nLocal Backup Repository\n        \u2193\nRemote Backup Repository\n        \u2193\nImmutable \/ Off-Site Storage\n        \u2193\nPeriodic Restore Test<\/code><\/pre>\n\n\n\n
\u0628\u0631\u0627\u06cc Database\u0647\u0627\u06cc\u06cc \u06a9\u0647 RPO \u067e\u0627\u06cc\u06cc\u0646 \u062f\u0627\u0631\u0646\u062f:<\/p>\n\n\n\n
Full Backup\n+\nBinary Log Backup\n+\nPoint-in-Time Recovery<\/code><\/pre>\n\n\n\n
\u0646\u06cc\u0632 \u0628\u0627\u06cc\u062f \u0628\u0631\u0631\u0633\u06cc \u0634\u0648\u062f.<\/p>\n\n\n\n
\n\n\n\n
\u067e\u06cc\u0634\u0646\u0647\u0627\u062f Backup Policy<\/h1>\n\n\n\n
\u06cc\u06a9 \u0646\u0645\u0648\u0646\u0647 Policy \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u0628\u0627\u0634\u062f:<\/p>\n\n\n\n
\u0646\u0648\u0639<\/th>\u0632\u0645\u0627\u0646\u200c\u0628\u0646\u062f\u06cc \u0646\u0645\u0648\u0646\u0647<\/th><\/tr>
Full Backup<\/td>\u0631\u0648\u0632\u0627\u0646\u0647<\/td><\/tr>
Binary Log<\/td>\u067e\u06cc\u0648\u0633\u062a\u0647<\/td><\/tr>
Local Retention<\/td>7 \u062a\u0627 30 \u0631\u0648\u0632<\/td><\/tr>
Off-Site Retention<\/td>\u0645\u062a\u0646\u0627\u0633\u0628 \u0628\u0627 Policy \u0633\u0627\u0632\u0645\u0627\u0646<\/td><\/tr>
Hash Verification<\/td>\u067e\u0633 \u0627\u0632 \u0647\u0631 Backup<\/td><\/tr>
Restore Test<\/td>\u062f\u0648\u0631\u0647\u200c\u0627\u06cc<\/td><\/tr>
Recovery Drill<\/td>\u0628\u0631\u0627\u06cc \u0633\u0631\u0648\u06cc\u0633\u200c\u0647\u0627\u06cc Critical<\/td><\/tr>
Monitoring<\/td>\u067e\u0633 \u0627\u0632 \u0647\u0631 Job<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\u0627\u06cc\u0646 \u0632\u0645\u0627\u0646\u200c\u0628\u0646\u062f\u06cc \u0641\u0642\u0637 \u0646\u0645\u0648\u0646\u0647 \u0627\u0633\u062a \u0648 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0648\u0627\u0642\u0639\u06cc \u0628\u0627\u06cc\u062f \u0628\u0631 \u0627\u0633\u0627\u0633 RPO\u060c RTO\u060c \u062d\u062c\u0645 Database\u060c Business Requirement \u0648 \u0638\u0631\u0641\u06cc\u062a Storage \u062a\u0639\u06cc\u06cc\u0646 \u0634\u0648\u0646\u062f.<\/p>\n\n\n\n
\n\n\n\n
\u0645\u0637\u0627\u0644\u0639\u0627\u062a \u0628\u06cc\u0634\u062a\u0631<\/h1>\n\n\n\n
\u0645\u0633\u062a\u0646\u062f\u0627\u062a \u0631\u0633\u0645\u06cc MySQL \u0628\u0631\u0627\u06cc Backup \u0648 Recovery:<\/p>\n\n\n\n
MySQL Backup and Recovery<\/a><\/p>\n\n\n\n
\u0631\u0627\u0647\u0646\u0645\u0627\u06cc \u0631\u0633\u0645\u06cc mysqldump<\/code>:<\/p>\n\n\n\n
mysqldump \u2014 A Database Backup Program<\/a><\/p>\n\n\n\n
\u0631\u0627\u0647\u0646\u0645\u0627\u06cc Restore \u06a9\u0631\u062f\u0646 SQL Dump:<\/p>\n\n\n\n
Reloading SQL-Format Backups<\/a><\/p>\n\n\n\n
\u0631\u0627\u0647\u0646\u0645\u0627\u06cc Point-in-Time Recovery:<\/p>\n\n\n\n
MySQL Point-in-Time Recovery<\/a><\/p>\n\n\n\n
\u0645\u0633\u062a\u0646\u062f\u0627\u062a \u0631\u0633\u0645\u06cc MySQL Shell Dump Utilities:<\/p>\n\n\n\n
MySQL Shell Dump Utilities<\/a><\/p>\n\n\n\n
\n\n\n\n
\u062c\u0645\u0639\u200c\u0628\u0646\u062f\u06cc<\/h1>\n\n\n\n
\u0628\u0631\u0627\u06cc \u0628\u0633\u06cc\u0627\u0631\u06cc \u0627\u0632 MySQL Server\u0647\u0627\u060c mysqldump<\/code> \u0633\u0627\u062f\u0647\u200c\u062a\u0631\u06cc\u0646 \u0631\u0648\u0634 \u062a\u0647\u06cc\u0647 Logical Backup \u0627\u0633\u062a.<\/p>\n\n\n\n
\u06cc\u06a9 \u062f\u0633\u062a\u0648\u0631 \u0645\u0646\u0627\u0633\u0628 \u0628\u0631\u0627\u06cc Database\u0647\u0627\u06cc \u0645\u0639\u0645\u0648\u0644\u06cc InnoDB \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u0628\u0627\u0634\u062f:<\/p>\n\n\n\n
mysqldump \\\n  --single-transaction \\\n  --quick \\\n  --routines \\\n  --events \\\n  --triggers \\\n  --hex-blob \\\n  --no-tablespaces \\\n  -u root \\\n  -p \\\n  database_name \\\n  | gzip > database_name.sql.gz<\/code><\/pre>\n\n\n\n
\u0627\u0645\u0627 Backup Strategy \u062d\u0631\u0641\u0647\u200c\u0627\u06cc \u0646\u0628\u0627\u06cc\u062f \u0641\u0642\u0637 \u0628\u0647 \u0627\u062c\u0631\u0627\u06cc \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u0645\u062d\u062f\u0648\u062f \u0634\u0648\u062f.<\/p>\n\n\n\n
\u06cc\u06a9 \u0641\u0631\u0622\u06cc\u0646\u062f \u0635\u062d\u06cc\u062d \u0628\u0627\u06cc\u062f \u0634\u0627\u0645\u0644 \u0645\u0648\u0627\u0631\u062f \u0632\u06cc\u0631 \u0628\u0627\u0634\u062f:<\/p>\n\n\n\n
Backup\n\u2193\nCompression\n\u2193\nIntegrity Verification\n\u2193\nOff-Site Copy\n\u2193\nRetention\n\u2193\nMonitoring\n\u2193\nRestore Test<\/code><\/pre>\n\n\n\n
\u0628\u0631\u0627\u06cc Database\u0647\u0627\u06cc \u0628\u0632\u0631\u06af \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0627\u0632 MySQL Shell \u06cc\u0627 Physical Backup \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f \u0648 \u0628\u0631\u0627\u06cc \u0633\u0631\u0648\u06cc\u0633\u200c\u0647\u0627\u06cc\u06cc \u0628\u0627 RPO \u067e\u0627\u06cc\u06cc\u0646\u060c Binary Log \u0648 Point-in-Time Recovery \u0646\u06cc\u0632 \u0628\u0627\u06cc\u062f \u062f\u0631 \u0637\u0631\u0627\u062d\u06cc Backup \u0644\u062d\u0627\u0638 \u0634\u0648\u0646\u062f.<\/p>\n\n\n\n
\u0645\u0647\u0645\u200c\u062a\u0631\u06cc\u0646 \u0627\u0635\u0644 \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 Backup \u0645\u0648\u0641\u0642\u060c Backup\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0628\u062a\u0648\u0627\u0646 \u0622\u0646 \u0631\u0627 \u062f\u0631 \u0632\u0645\u0627\u0646 \u0646\u06cc\u0627\u0632 \u0628\u0627 \u0645\u0648\u0641\u0642\u06cc\u062a Restore \u06a9\u0631\u062f<\/strong>. \u0628\u0647 \u0647\u0645\u06cc\u0646 \u062f\u0644\u06cc\u0644 Restore Test \u0628\u0627\u06cc\u062f \u0628\u062e\u0634\u06cc \u0627\u0632 Backup Policy \u0628\u0627\u0634\u062f\u060c \u0646\u0647 \u06cc\u06a9 \u06a9\u0627\u0631 \u0627\u062e\u062a\u06cc\u0627\u0631\u06cc \u067e\u0633 \u0627\u0632 \u0628\u0631\u0648\u0632 Disaster.<\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
\u0645\u0642\u062f\u0645\u0647 \u062a\u0647\u06cc\u0647 \u0646\u0633\u062e\u0647 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646 \u0627\u0632 Database \u06cc\u06a9\u06cc \u0627\u0632 \u0645\u0647\u0645\u200c\u062a\u0631\u06cc\u0646 \u0648\u0638\u0627\u06cc\u0641 \u0645\u062f\u06cc\u0631 \u0633\u0631\u0648\u0631 \u0648 \u0645\u062f\u06cc\u0631 Database \u0627\u0633\u062a. \u062e\u0631\u0627\u0628\u06cc Storage\u060c \u062d\u0630\u0641 \u0627\u0634\u062a\u0628\u0627\u0647 \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u060c \u062e\u0637\u0627\u06cc Application\u060c \u062d\u0645\u0644\u0627\u062a \u0628\u0627\u062c\u200c\u0627\u0641\u0632\u0627\u0631\u06cc\u060c Upgrade \u0646\u0627\u0645\u0648\u0641\u0642 \u06cc\u0627 \u062e\u0631\u0627\u0628 \u0634\u062f\u0646 Server \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0628\u0627\u0639\u062b \u0627\u0632 \u062f\u0633\u062a \u0631\u0641\u062a\u0646 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0634\u0648\u062f. \u062f\u0631 MySQL \u0631\u0648\u0634\u200c\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641\u06cc \u0628\u0631\u0627\u06cc Backup \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f. \u0633\u0627\u062f\u0647\u200c\u062a\u0631\u06cc\u0646 \u0648 \u0645\u062a\u062f\u0627\u0648\u0644\u200c\u062a\u0631\u06cc\u0646 \u0631\u0648\u0634 \u0628\u0631\u0627\u06cc \u0628\u0633\u06cc\u0627\u0631\u06cc \u0627\u0632 Database\u0647\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 […]<\/p>\n","protected":false},"author":4,"featured_media":22786,"parent":18523,"menu_order":4,"comment_status":"open","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","_llm_markdown_disabled":false},"doc_tag":[],"doc_badge":[],"class_list":["post-18531","docs","type-docs","status-publish","has-post-thumbnail","hentry"],"acf":[],"author_avatar":"https:\/\/maralhost.com\/kb\/wp-content\/litespeed\/avatar\/86d527e9d6c721b378b27e18daa8865e.jpg?ver=1793704511","author_name":"Fateme Moayed","_links":{"self":[{"href":"https:\/\/maralhost.com\/kb\/wp-json\/wp\/v2\/docs\/18531","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/maralhost.com\/kb\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/maralhost.com\/kb\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/maralhost.com\/kb\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/maralhost.com\/kb\/wp-json\/wp\/v2\/comments?post=18531"}],"version-history":[{"count":3,"href":"https:\/\/maralhost.com\/kb\/wp-json\/wp\/v2\/docs\/18531\/revisions"}],"predecessor-version":[{"id":22785,"href":"https:\/\/maralhost.com\/kb\/wp-json\/wp\/v2\/docs\/18531\/revisions\/22785"}],"up":[{"embeddable":true,"href":"https:\/\/maralhost.com\/kb\/wp-json\/wp\/v2\/docs\/18523"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/maralhost.com\/kb\/wp-json\/wp\/v2\/media\/22786"}],"wp:attachment":[{"href":"https:\/\/maralhost.com\/kb\/wp-json\/wp\/v2\/media?parent=18531"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/maralhost.com\/kb\/wp-json\/wp\/v2\/doc_tag?post=18531"},{"taxonomy":"doc_badge","embeddable":true,"href":"https:\/\/maralhost.com\/kb\/wp-json\/wp\/v2\/doc_badge?post=18531"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}