Can i delete ibdata

To deal with the database problem in the production environment, the most important problem is to ensure that the data can not be lost, and ensure the normal service of the application on the premise of data integrity.

Therefore, the first and foremost problem is to restore and back up the data. Unfortunately, the database did not do data backup, but fortunately, there is a binlog log file, which can be used for data recovery. I copy the binlog file locally and import it into the new MySQL library locally. The binary content is stored in the binlog log file, so you need to use the mysqlbinlog command to convert it into a statement that can be executed by mysql, as follows:.

The premise of this method is that your data files. Restart the database successfully, and then log in smoothly. After logging in, it is found that the data is still available and can be accessed normally, so the data backup is carried out quickly. Although the database restart was successful, it's too early to be happy. Because at this time, the database can only query, not add, delete and modify. Large numbers contain the influence of all the previous numbers.

Add a comment. Active Oldest Votes. Great question, and a very common issue. Well, it is certainly a possibility, but there are ways to get rid of it, depending on the server version and your need for availability: One approach, if availability is not a problem, and the database is small, would be to dump the whole database into a.

Very slow, but very easy. If you do not want to suffer such a long process, there are ways to do it fully online, using a slave- you just set it up right from the beginning, and then switch nodes. That would be a way to perform a quick backup, stop and wipe, and restore in binary format way faster than with.

Some tools like Percona XtraBackup may be useful for that. Improve this answer. Hey jynus!!! Hope you don't mind me adding the picture so Mahesh can better visualize ibdata1. RolandoMySQLDBA No problem on inserting it, but my former colleague Vadim's image, that you never credit adequately, is now very old most of the Percona Extensions do not work anymore and it does not reflect the new changes and not very user friendly.

I do not really recommend you using it anymore. I may take some time in the future to create and updated version of it. I look forward to seeing that picture. I got that picture from scribd. Sorry for not crediting it. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Your email address will not be published. Save my name, email, and website in this browser for the next time I comment. Where is the MySQL log file?

Can I delete IBD files? How do I dump a full database? What is dump file in MySQL? What is ibtmp1 file? Why is the ibdata1 file continuously growing in MySQL? Where can I get ibdata1? What is inside var lib MySQL? What is log file in MySQL? How do I open a. How do I use InnoDB? What is InnoDB buffer pool size? Related Posts. Leave a Comment Cancel Reply Your email address will not be published.