MySQL Forums :: Stored Procedures :: MySQL Dump/Import fails

Advanced Search

Re: MySQL Dump/Import fails
Posted by: Devart Team ()
Date: May 23, 2011 09:07AM

As I know mysqldump generates special comments (see MySQL extensions to standard SQL) which allows to execute statements only on specified versions or higher. For example -

/*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `film_in_stock`(IN p_film_id INT, IN p_store_id INT, OUT p_film_count INT)

/*!50020 DEFINER=`root`@`localhost`*/ - this code will be ignored on MySQL 5.1.19 or lower versions.

Another solution for synchronization - try to use Schema Comparison/Synchronization tool in dbForge Studio for MySQL.

Devart Company,
MySQL management tools

Options: ReplyQuote

Subject Views Written By Posted
MySQL Dump/Import fails 2753 Robin Mannering 05/23/2011 05:06AM
Re: MySQL Dump/Import fails 1229 Devart Team 05/23/2011 05:50AM
Re: MySQL Dump/Import fails 1070 Robin Mannering 05/23/2011 07:16AM
Re: MySQL Dump/Import fails 1387 Devart Team 05/23/2011 09:07AM
Re: MySQL Dump/Import fails 685 Robin Mannering 05/30/2011 07:05AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.