Backup statements are the same, STD backup ready soon, but the test has to stay in the backup interface does not end, statements run after a few seconds under the condition of forced termination of backup, STD there will be a certain size, for example, 1 m, but the test, no matter how long it will take to run is terminated, only have 1 k, open the test SQL file backup, is no exception,
Test the backup after termination statements:
10.17 Distrib - MariaDB dump 10.4.1 - MariaDB, for Win64 (AMD64)
-
- Host: * * * * * * * * * * Database: * * *
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
- Server version 10.4.12 - MariaDB
/*! 40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*! 40101 SET @ OLD_CHARACTER_SET_RESULTS=@ @ CHARACTER_SET_RESULTS */.
/*! 40101 SET @ OLD_COLLATION_CONNECTION=@ @ COLLATION_CONNECTION */.
/*! 40101 SET GBK NAMES */;
/*! 40103 SET @ OLD_TIME_ZONE=@ @ TIME_ZONE */.
/*! 40103 SET TIME_ZONE='+ 00:00 */.
/*! 40014 SET @ OLD_UNIQUE_CHECKS=@ @ UNIQUE_CHECKS, UNIQUE_CHECKS=0 */.
/*! 40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*! 40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*! 40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
And backup running on the weekend, only from Monday to Friday will appear this kind of circumstance, bosses, please help see why?
CodePudding user response:
Back up statements made by, the estimate is a task with lock, and the task does not work over the weekend,