MySQL Forums
Forum List  »  Backup

MySQLdump with no comments
Posted by: Sofia Ferreira
Date: October 11, 2017 05:06AM

Hi,

I have a question regarding the dumps on MySQL.
We have MySQL installed on one of our servers, where we are having daily backups from all databases.
The backups (dumps) are working fine except for one part, I can't dump the comments on a db (e.g. I have a db named TESTExample with the following procedure:
BEGIN
#This is a test
SELECT 'test' AS result;
END

The line "#this is a test" is not being backup up, when I restore the dump it shows me this:
BEGIN

SELECT 'test' AS result;
END


How can I solve it?
Thank you very much,
Best Regards,
SF

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQLdump with no comments
494
October 11, 2017 05:06AM


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.