<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body>
<p dir="auto" style=" text-align: left; margin-top: 25px; margin-bottom: 25px; font-family: sans-serif; font-size: 11pt; color: black; background-color: white ">
Hi all. I recently had an idea that I would like to implement in phpmyadmin. In the development docs it is mentioned that ideas about new features should be discussed on the list before implementing it.
</p>
<p dir="auto" style=" text-align: left; margin-top: 25px; margin-bottom: 25px; font-family: sans-serif; font-size: 11pt; color: black; background-color: white ">
I was working on MySQL (with phpmyadmin) in my last job and I faced some problems. Basically when I entered an incorrect query it led to data loss and there was no way to recover it. I searched online and there were a few people like me who also experienced
similar problems. Recovery is only possible when there is data backup and only to the extent of the frequency of the backups.
</p>
<p dir="auto" style=" text-align: left; margin-top: 25px; margin-bottom: 25px; font-family: sans-serif; font-size: 11pt; color: black; background-color: white ">
Having read about binary logs in MySQL I came up with the idea to implement a solution that is able to recover the database by undoing only the offending queries. However, to implement this it would be necessary to have a web interface to view and select the
statements that need to be undone. I felt that implementing it as a part of phpmyadmin would be better than implementing a standalone solution because it would gel very well with it. Also I want this project to be open source.
</p>
<p dir="auto" style=" text-align: left; margin-top: 25px; margin-bottom: 25px; font-family: sans-serif; font-size: 11pt; color: black; background-color: white ">
I don't have a lot of experience so I don't know if this is a good idea or if there is a better approach to solve this. I would very much like your suggestions on this.
</p>
<p dir="auto" style=" text-align: left; margin-top: 25px; margin-bottom: 25px; font-family: sans-serif; font-size: 11pt; color: black; background-color: white ">
Thanks,<br>
Ashish</p>
<p dir="auto" style=" text-align: left; margin-top: 25px; margin-bottom: 25px; font-family: sans-serif; font-size: 11pt; color: black; background-color: white ">
Get <a href="https://aka.ms/ghei36">Outlook for Android</a><br>
</p>
</body>
</html>