- 3,727,956 Users
- 2,245,510 Discussions
- 7,853,209 Comments
Forum Stats
Discussions
Howdy, Stranger!
Categories
- 380.6K All Categories
- 16 Data
- 362.2K Big Data Appliance
- 7 Data Science
- 2.4K Databases
- 690 General Database Discussions
- 3.7K Java and JavaScript in the Database
- 32 Multilingual Engine
- 499 MySQL Community Space
- 10 NoSQL Database
- 7.7K Oracle Database Express Edition (XE)
- 2.8K ORDS, SODA & JSON in the Database
- 424 SQLcl
- 69 SQL Developer Data Modeler
- 185.2K SQL & PL/SQL
- 21.1K SQL Developer
- 2.7K Development
- 3 Developer Projects
- 32 Programming Languages
- 135.9K Development Tools
- 18 DevOps
- 3K QA/Testing
- 388 Java
- 16 Java Learning Subscription
- 14 Database Connectivity
- 72 Java Community Process
- 3 Java 25
- 14 Java APIs
- 141.2K Java Development Tools
- 15 Java EE (Java Enterprise Edition)
- 153K Java Essentials
- 135 Java 8 Questions
- 86.2K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 18 Java SE
- 13.8K Java Security
- 4 Java User Groups
- 22 JavaScript - Nashorn
- 18 Programs
- 157 LiveLabs
- 36 Workshops
- 13 Software
- 7 Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 4 Deutsche Oracle Community
- 18 Español
- 1.9K Japanese
- 4 Portuguese
Is it able to remove data\ibdata1 file from mysql 5.6.30 archive install zip
Hi,
I would like to know why the file ibdata1 is preset in the "data" folder in mysql server archive version 5.6.30 (windows 64 bit, enterprise version).
I removed this file , only keep the folder of "mysql" and "performance_schema", try to start mysqld for the first time, mysqld can still start successfully, and I see a new ibdata1 is generated.
So I have a question, since this file can be generated automatically, why do you need to preset it in data folder?
Best Answer
-
It is the InnoDB table space.
The system tablespace is the storage area for the
InnoDBdata dictionary, the double write buffer, the change buffer, and undo logs. It may also contain table and index data if tables are created in the system table space rather than file-per-table or general tablespaces.The system tablespace can have one or more data files.
Answers
-
It is the InnoDB table space.
The system tablespace is the storage area for the
InnoDBdata dictionary, the double write buffer, the change buffer, and undo logs. It may also contain table and index data if tables are created in the system table space rather than file-per-table or general tablespaces.The system tablespace can have one or more data files.
-
Hi,
I mean the newly downloaded archive version, In the case of mysqld starts for the first time, is ibdata1 file still useful? even without it I can start mysqld without any problem and a new one will be generated.
I just want to know if this file must exists in the nonintall zip archive? For mysqld , when it starts for the first time, it seems this file is not essential and could be generated, so I think probably this file could be removed from nonintall zip archive.
-
Yes, the sever will create the ibdata1 if it does not exist. I am not sure which zip file you are using but the packager may have put it in there to a) save time, b) preload data (example databases), and/or c) just because it was there when they created the zip file.
If it really worries you then delete it.