我用
./mysqldump --opt -h10.2.6.44 -ubackupuser -pbackup -t -n -d -R test > /data/backup/test1.sql
查看了里面居然都是这样的,根本还原不了,郁闷!!! 怎么是这样啊,
例如:
DELIMITER ;
/*!50003 SET sql_mode = @saved_sql_mode */ ;
/*!50003 SET character_set_client = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection = @saved_col_connection */ ;
/*!50003 DROP PROCEDURE IF EXISTS `pr_backuptest` */;
/*!50003 SET @saved_cs_client = @@character_set_client */ ;
/*!50003 SET @saved_cs_results = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client = utf8 */ ;
/*!50003 SET character_set_results = utf8 */ ;
/*!50003 SET collation_connection = utf8_general_ci */ ;
/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
/*!50003 SET sql_mode = '' */ ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50020 DEFINER=`root`@`%`*/ /*!50003 PROCEDURE `pr_backuptest`()
BEGIN
select * from course;
END */;;
./mysqldump --opt -h10.2.6.44 -ubackupuser -pbackup -t -n -d -R test > /data/backup/test1.sql
查看了里面居然都是这样的,根本还原不了,郁闷!!! 怎么是这样啊,
例如:
DELIMITER ;
/*!50003 SET sql_mode = @saved_sql_mode */ ;
/*!50003 SET character_set_client = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection = @saved_col_connection */ ;
/*!50003 DROP PROCEDURE IF EXISTS `pr_backuptest` */;
/*!50003 SET @saved_cs_client = @@character_set_client */ ;
/*!50003 SET @saved_cs_results = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client = utf8 */ ;
/*!50003 SET character_set_results = utf8 */ ;
/*!50003 SET collation_connection = utf8_general_ci */ ;
/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
/*!50003 SET sql_mode = '' */ ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50020 DEFINER=`root`@`%`*/ /*!50003 PROCEDURE `pr_backuptest`()
BEGIN
select * from course;
END */;;
mysql> /*!50003 SET sql_mode = @saved_sql_mode */ ;
ERROR 1231 (42000): Variable 'sql_mode' can't be set to the value of 'NULL'
mysql> /*!50003 SET character_set_client = @saved_cs_client */ ;
ERROR 1231 (42000): Variable 'character_set_client' can't be set to the value of
'NULL'
mysql> /*!50003 SET character_set_results = @saved_cs_results */ ;
Query OK, 0 rows affected (0.00 sec)mysql> /*!50003 SET collation_connection = @saved_col_connection */ ;
ERROR 1231 (42000): Variable 'collation_connection' can't be set to the value of
'NULL'
mysql> /*!50003 DROP PROCEDURE IF EXISTS `pr_backuptest` */;
Query OK, 0 rows affected, 1 warning (0.22 sec)mysql> /*!50003 SET @saved_cs_client = @@character_set_client */ ;
Query OK, 0 rows affected (0.00 sec)mysql> /*!50003 SET @saved_cs_results = @@character_set_results */ ;
Query OK, 0 rows affected (0.00 sec)mysql> /*!50003 SET @saved_col_connection = @@collation_connection */ ;
Query OK, 0 rows affected (0.00 sec)mysql> /*!50003 SET character_set_client = utf8 */ ;
Query OK, 0 rows affected (0.00 sec)mysql> /*!50003 SET character_set_results = utf8 */ ;
Query OK, 0 rows affected (0.00 sec)mysql> /*!50003 SET collation_connection = utf8_general_ci */ ;
Query OK, 0 rows affected (0.00 sec)mysql> /*!50003 SET @saved_sql_mode = @@sql_mode */ ;
Query OK, 0 rows affected (0.00 sec)mysql> /*!50003 SET sql_mode = '' */ ;
Query OK, 0 rows affected (0.00 sec)mysql> DELIMITER ;;
mysql> /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`%`*/ /*!50003 PROCEDURE `pr_ba
ckuptest`()
-> BEGIN
-> select * from course;
-> END */;;
Query OK, 0 rows affected, 1 warning (0.02 sec)mysql>