I have MySQL 3.23.54. I tried several times to understand how to make InnoDB table to be active
by reading MySQL manual but nothing I have yet. I placed these values exactly as shown below inside
my.ini file:
innodb_data_file_path=ibdata:30M
innodb_data_home_dir=
innodb_data_file_path=/ibdata/ibdata1:100M:autoextend
So what's these values means? and how to configur it correctly to make InnoDB table to work.
7.5.2 InnoDB Startup Options
To use InnoDB tables in MySQL-Max-3.23 you MUST specify configuration parameters in the [mysqld] section of the configuration file my.cnf', or on Windows optionally inmy.ini'.
At the minimum, in 3.23 you must specify innodb_data_file_path where you specify the names and the sizes of datafiles.
If you do not mention innodb_data_home_dir in my.cnf' the default is to create these files to the datadir of MySQL.
If you specify innodb_data_home_dir as an empty string, then you can give absolute paths to your data files in innodb_data_file_path.
In MySQL-4.0 you do not need to specify even innodb_data_file_path: the default for it is to create an auto-extending 10 MB fileibdata1' to the datadir of MySQL. (In MySQL-4.0.0 and 4.0.1 the datafile is 64 MB and not auto-extending.)
The following part I copied it from the MySQL manual:
If you don't want to use InnoDB tables, you can add the skip-innodb option to your MySQL option file.
But to get good performance you MUST explicitly set the InnoDB parameters listed in the following examples.
Starting from versions 3.23.50 and 4.0.2 InnoDB allows the last datafile on the innodb_data_file_path line to be specified as auto-extending. The syntax for innodb_data_file_path is then the following:
pathtodatafile:sizespecification;pathtodatafile:sizespecification;...
... ;pathtodatafile:sizespecification[:autoextend[:max:sizespecification]]
So what's this stuff mean?!!!
I need help please🙁 🙁 🙁
