473,408 Members | 2,402 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,408 software developers and data experts.

comments in sql code disappear when db is restored

When I restore a backup (.sql) file to the same machine where I made the backup, or on any other mySQL server machine, all comments in stored procedures and functions are stripped out. When I open the backup file in a
text editor, I can see the comments are there. Restore the db, same schema, another schema, doesn't matter- the comments are gone. Seems like the restore is where the comments get lost.

I'm using mySQL 5.0 on Windows XP

This is a fairly annoying 'feature', since other's may have to view/modify these
procs and funtions, and there is nothing to explain what's going on in the code.
6 months after I write a complicated proc or function, I won't even remember what my thought process was at the time I wrote the code.

Any insight would be appreciated, thanks.
Mar 22 '10 #1
0 1253

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Jol | last post by:
This is more of a fyi than a question. After restoring a live db backup to our development server there was an identically named login Melb02 on both the db server and in the restored db backup....
10
by: salamol | last post by:
I has a strange question. My company is using a old system with Win NT 4.0 Server + MS SQL 7.0. The system is busy and handle a lot of SELECTs and INSERTs all the time. Sometimes, some...
2
by: Dan | last post by:
Hello, I am just now converting from the world of DOS. Making simple VB.NET apps was easier than I expected. Now I need some control over the window that the app is running in. Can a VB.NET...
2
by: Raymond Du | last post by:
Hi, I am working on a VB.Net window application, the application use System.IO.File.Delete method to delete files, can those deleted files be restored? TIA
10
by: Mitchell Vincent | last post by:
I have a tiny little application that runs, and when minimized it throws itself into the systray until the user double clicks on the systray icon. To accomplish that first part I have this : ...
0
by: Parv | last post by:
hi all can i attach a read only restored database. I restored a database Test in Stand by Mode. After that i detached that database and while restoring i m getting msg "Cannot attach a database...
98
by: tjb | last post by:
I often see code like this: /// <summary> /// Removes a node. /// </summary> /// <param name="node">The node to remove.</param> public void RemoveNode(Node node) { <...> }
9
by: Antonio Ooi | last post by:
Hi, I have the following appSettings in my app.config file: <appSettings> <!-- Some comments here --> <add key="MyKey1" value="1"/>
0
by: ntech | last post by:
hello, when i took the dump and tried to restore the dump in postgresql 7.3.4, the functions are not restored, so can anyone suggest me the solution of the above specified problem. The oids are...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.