I had a client uninstall MYSQL50 and delete the folder that housed the Data base files. When we recovered the deleted folder, we found that some tables had not been updated. After further investigation, we found that back-ups were not complete because MYSQL was running during the back-up thus not copying all the files to the DB.
Is there a way to recover the files that were held in MYSQL and not copied to the folder were the DB files were located? The client was copying the entire C: drive of the machine in question. Can we restore, and if so, will we have all the files that were being held in Mysql50?
2  1896   bartonc 6,596
Recognized Expert Expert
I had a client uninstall MYSQL50 and delete the folder that housed the Data base files. When we recovered the deleted folder, we found that some tables had not been updated. After further investigation, we found that back-ups were not complete because MYSQL was running during the back-up thus not copying all the files to the DB.
Is there a way to recover the files that were held in MYSQL and not copied to the folder were the DB files were located? The client was copying the entire C: drive of the machine in question. Can we restore, and if so, will we have all the files that were being held in Mysql50?
There are two situations that I can think of that would actually loose data as you describe:
1) Transactions being processed that had not yet been COMMITed
2) Temporary tables in memory, table TYPE = memory.
In both cases, I believe that that data is gone forever.
Otherwise, MySQL will write the tables at the time of the query and the question becomes "When was the backup made?". INSERTs/UPDATEs performed between backups will also be lost.
nomad 664
Recognized Expert Contributor
I had a client uninstall MYSQL50 and delete the folder that housed the Data base files. When we recovered the deleted folder, we found that some tables had not been updated. After further investigation, we found that back-ups were not complete because MYSQL was running during the back-up thus not copying all the files to the DB.
Is there a way to recover the files that were held in MYSQL and not copied to the folder were the DB files were located? The client was copying the entire C: drive of the machine in question. Can we restore, and if so, will we have all the files that were being held in Mysql50?
unless you have backup they are mostly gone.
Alway have 2 backups for that reason.
nomad
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Matt Frame |
last post by:
I wrote a small assembly to test the process of placing it into the Global
Assembly Cache but now I cannot remove it. When I hi-light and click delete
I get the following:
Assembly 'Assembly Name' could not be uninstalled because it is required by
other applications.
I have signed on as the local administrator, I booted into safe mode and I
keep getting this message. Can you only put assemblies into the GAC? I
would assume if you...
|
by: Leslie Lim |
last post by:
I had link my 4 of workstations to server with MySql.
1 pc of my pc can run a software which can update MsSql perfectly but not
others(3 failed).
I tried to add System Dsn data source for Control Panel - Odbc data source
32.
The pc which working fine with the software function but 3 of the rest not.
My pcs running xp and win98 !
Regards.
Thanks.
|
by: Dave A |
last post by:
I have an application that runs in the system tray (taskbar notification
area) and it runs at startup. Occasionally I need to release a new version.
I have created a deployment project in .Net. With the MSI it detects
whether a current version is installed and requests that the user uninstalls
it prior to installing the new version. Also, MSI detects a running instance
of the application during the uninstall and requests that it be closed...
|
by: tuuky |
last post by:
I've created a Windows Service in C# and an installer project for it.
I installed the service using the packaged installer project and the service
was installed correctly and it runs fine.
I've since made some changes to this service.
I then proceded to uninstall it (Add/Remove Programs) to install the new one.
However, the service still shows under Services, but the .exe is gone.
I can't install the new version of the service,...
|
by: Fan Ruo Xin |
last post by:
I installed Stinger in my PC (w2k). I need to do a quick compare between DB2
OLAP server and DB2 Cube Views. And I only found DB2 Cube Views version8.1
trial code from IBM website. I didn't want to spend a lot of time on this.
So I installed the Cube Views 8.1, without uninstall ESE V8.2 code first
last Friday. It looks like everything was OK.
But I failed to start DB2 Information Center and DB2 CC today. I've seen
process - javaw used...
| | |
by: Adam Clauss |
last post by:
I am needing to automate some installation tasks. I first need to determine
if there is already a version of a program installed. The program appears
in the Add/Remove Programs in control panel, and I know this is all stored
in the registry. But short of searching through the entire registry, I
cannot figure out how to locate the program.
I see that in the registry (for .msi) installs, stores something like:...
|
by: david.kao |
last post by:
Hi All: I tried to uninstall a runtime security package from a user's
machine. Based on document I have read, all I need to do is right click on
MSI file, and choose uninstall from menu. After I chose uninstall, the
package seemed to uninstall itself. But when open .NET configuration 1.1, I
did not see the package got remove.
Thanks in advance
DK
|
by: VJ |
last post by:
I am deploying a Package having applications developed using VB.NET and
VS.NET 2003. I am using the Packaging feature provided with the
VisualStudio. I can use the package to creates shortcuts for all my
application executables. Now to Uninstall this package I have to make the
user go to Add/Remove programs everytime. The users are requesting that if
they can have a uninstall option as part of the application menus... How do
I provide...
|
by: Nattydreadlock |
last post by:
Hello,
I'm having some problems installing Visual Studio 2005.
I'll briefly explain what's the history of the problem here.
First I installed VS 2005 beta 2.
I uninstalled it later via the Windows Uninstall Tool you can download.
Then I installed Visual Studio 2005 Team Edition ENU. This was a trial
version for 180 days.
|
by: Luke |
last post by:
Hey all,
i'm currently working on a project for our IT group. what this
program
does is lists all the installed programs on the remote machine for
the
admin. what i'm trying to add is functionality for the admin to
select
a program from the list and click an uninstall button on the program
to uninstall the program remotely. We are rebuilding this program
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
