473,473 Members | 2,015 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

How recover a deleted MySQL function

1 New Member
I have functions saved under proc.

I am using MySQL Workbench. I just tried to alter a function which resulted in an error (something about it being unsafe and binary logging); however, when I clicked "Apply", it dropped my function... and then as I was searching for the relevant option setting, Workbench crashed!

What's the easiest way to recover this function from a file-based backup?
Jul 3 '15 #1
3 1886
computerfox
276 Contributor
Since you're using WorkBench, I would assume you have an easy way to import the dump file if you have that dump file.
Jul 3 '15 #2
Luuk
1,047 Recognized Expert Top Contributor
The 'easiest' way is, of course, to restore a backup.....
Jul 4 '15 #3
computerfox
276 Contributor
Isn't that what I said?
Jul 6 '15 #4

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

Similar topics

5
by: Grant | last post by:
Hi Is there a way to recover deleted records from a table. A mass deletion has occurred and Access has been closed since it happened Louis
2
by: Snonck | last post by:
Is is possible to recover deleted rows from a table from archive logs? For example, say you have a database with archive logging turned off. You create a table and populate it with records. You...
1
by: Astlik | last post by:
Hi, I was using phpmyadmin when, by mistake I deleted some rows from a table I didn't wanted to. I would like to know if anyone could help me recovering those records I deleted. I don't have any...
1
by: dbquest | last post by:
Hi, Is there a way to recover the deleted rows? We do have a backup but not for all the rows that got deleted. Appreciate some quick help on this. Thanks.
2
by: Jason7899 | last post by:
hi, there is any way to recover deleted records from a acess database? thanks a lot for your help )
1
by: manmadhan | last post by:
i refer lots of website for "timediff mysql function not working in gridview" , its working mysql tool but in asp.net gridview its not working.... please any one help me for this problem
1
by: art2873 | last post by:
I want to recover deleted rows from my db2 database. I have save the log file before delete row. Is there any way to recover back deleted row from log file. My log file is like this S0000001.log
5
by: Dharmasiri | last post by:
I entered around 45000 records in a database. The database designed in MS access 2003. I deleted records most of them but accidentally I want to retrieve those records. Please guide me how to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
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
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...
1
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...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

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.