Re: MySQL Dump/Import fails
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/
Subject
Views
Written By
Posted
4240
May 23, 2011 05:06AM
1544
May 23, 2011 05:50AM
1421
May 23, 2011 07:16AM
Re: MySQL Dump/Import fails
1920
May 23, 2011 09:07AM
1020
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.