The Ultimate Guide to High Availability with MariaDB

Comments - Create dump and restore all databases

 
2 years, 6 months ago Daniel Black
Re: Create dump and restore all databases [Answer]

mysql --version only shows the version of the mysql client.

What does SELECT VERSION() show on both servers?

Are you importing a mariadb generated mysqldump, from/to a MySQL database?

 
2 years, 6 months ago Ian Gilfillan
Re: Create dump and restore all databases

It's hard to identify the problem without seeing the statement causing the error...

 
2 years, 6 months ago Suresh Kumar
Re: Create dump and restore all databases

The line 1379 is

/*!50003 DROP FUNCTION IF EXISTS `getCostBasisForTickerByAccount2` */;

Here is the part of the sql statements:

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 FUNCTION IF EXISTS `getCostBasisForTickerByAccount2` */;
/*!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  = utf8mb4 */ ;
/*!50003 SET character_set_results = utf8mb4 */ ;
/*!50003 SET collation_connection  = utf8mb4_general_ci */ ;
/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
/*!50003 SET sql_mode              = 'IGNORE_SPACE,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
DELIMITER ;;
 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.