Are my Backups wrong

lotiara's profile image lotiara posted 9 months ago in General Permalink

I have been using backup -- one file per object Today i was inspecting my backup and it happens that my Tables have the same name of my stored procedures and thus i have data missing. Renaming all he procedures is not an option, i have a lot and they are called from stored procedures. Is there a possibility to add a prefix for every backup indicating the type to prevent this kind of error ? ie table_Mytable_whatever.sql prcedure_Mytable_whatever.sql trigger_Mytable_whatever.sql I think it should be easy to accomplsh and would prevent the problem. Thank you.

lotiara's profile image lotiara posted 9 months ago Permalink

Sorry for the format. Returns are ignored by the editor and i cant find options to edit the message or delete it. How do I insert a return ?

ansgar's profile image ansgar posted 9 months ago Permalink

Yes, that's indeed an issue! I wonder why there is no complaint about that in the tracker.

grafik.png

ansgar's profile image ansgar posted 9 months ago Permalink

See issue #2212

lotiara's profile image lotiara posted 9 months ago Permalink

Hi.

I suppose that ther is no complain becasue nobody noticed !!

I've been uing it for a long time and didn't notice until todays ?

Glad i did, becasue the recover from a disaster would have failed omg, MYSQl is really stable .

Thank you for opening the ticket.

Please login to leave a reply, or register at first.