Skip navigation links

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)
    READS SQL DATA
BEGIN
...

/*!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
http://www.devart.com/dbforge/mysql/

Options: ReplyQuote


Subject Views Written By Posted
MySQL Dump/Import fails 2365 Robin Mannering 05/23/2011 05:06AM
Re: MySQL Dump/Import fails 1105 Devart Team 05/23/2011 05:50AM
Re: MySQL Dump/Import fails 967 Robin Mannering 05/23/2011 07:16AM
Re: MySQL Dump/Import fails 1234 Devart Team 05/23/2011 09:07AM
Re: MySQL Dump/Import fails 585 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.