MySQL Forums
Forum List  »  Stored Procedures

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
3383
May 23, 2011 05:06AM
1325
May 23, 2011 05:50AM
1237
May 23, 2011 07:16AM
Re: MySQL Dump/Import fails
1610
May 23, 2011 09:07AM
800
May 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.