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
4241
May 23, 2011 05:06AM
1546
May 23, 2011 05:50AM
1422
May 23, 2011 07:16AM
Re: MySQL Dump/Import fails
1923
May 23, 2011 09:07AM
1022
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.