Solved

Clean old records from ibdata1 mysql file

Posted on 2013-12-09
1
548 Views
Last Modified: 2013-12-10
I have an ibdata1 file that contains old database records from a truncated table.  I need to clean up the file so those records are no longer stored on the system.

Is there any way for me to do this without taking down the database?

The server OS is Centos 6.4, the application is MariaDB 5.5.

Thank you for your time.
-Andrew
0
Comment
Question by:ninjadrew
1 Comment
 
LVL 28

Accepted Solution

by:
FishMonger earned 500 total points
ID: 39708592
Is there any way for me to do this without taking down the database?
No.

Read the info at this link to learn about the required steps needed to do the cleanup:
Reducing ibdata1 file size
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question