Debian Codegraph @

mysql-test/suite/innodb/include/tablespace_portability.inc

raw
1 # Remember some variables.
2 LET $MYSQLD_DATADIR = `select @@datadir`;
3 LET $INNODB_PAGE_SIZE = `select @@innodb_page_size`;
4
5 # Create some relative remote directories
6 --mkdir $MYSQLD_DATADIR/../spaces
7 --mkdir $MYSQLD_DATADIR/../remote
8 --mkdir $MYSQL_TMP_DIR/portability
9 --mkdir $MYSQL_TMP_DIR/portability/tables
10 --mkdir $MYSQL_TMP_DIR/portability/spaces
11 --mkdir $MYSQL_TMP_DIR/portability/altogether
12
13 --echo #
14 --echo # Create the sample database to test for portability.
15 --echo #
16
17 CREATE TABLE ibport_t1 (a INT, b varchar(30), c int, key ka(a), key kb(b)) ENGINE=InnoDB;
18 INSERT INTO ibport_t1 VALUES (1, 'One', 11), (2, 'two', 22), (3, 'three', 33), (4, 'four', 44);
19
20 CREATE TABLESPACE ibport_s1 ADD DATAFILE 'ibport_s1_gen.ibd' ENGINE=InnoDB;
21 CREATE TABLE ibport_t5 (a INT, b varchar(30), c int, key ka(a), key kb(b)) ENGINE=InnoDB TABLESPACE ibport_s1;
22 INSERT INTO ibport_t5 VALUES (1, 'One', 11), (2, 'two', 22), (3, 'three', 33), (4, 'four', 44);
23
24 CREATE TABLESPACE ibport_s2 ADD DATAFILE '../spaces/ibport_s2_gen.ibd' ENGINE=InnoDB FILE_BLOCK_SIZE=4k;
25 CREATE TABLE ibport_t6 (a INT, b varchar(30), c int, key ka(a), key kb(b)) ENGINE=InnoDB TABLESPACE ibport_s2
26 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
27 INSERT INTO ibport_t6 VALUES (1, 'One', 11), (2, 'two', 22), (3, 'three', 33), (4, 'four', 44);
28
29 --replace_result #P# #p# #SP# #sp#
30 SELECT s.space_type 'Type', s.name 'Space Name', d.path 'Path'
31 FROM information_schema.innodb_sys_tablespaces s, information_schema.innodb_sys_datafiles d
32 WHERE s.name like '%ibport%' AND s.space = d.space ORDER BY s.space;
33
34 --replace_result #P# #p# #SP# #sp#
35 SELECT s.space_type 'Type', s.name 'Space Name', f.file_name 'Path'
36 FROM information_schema.innodb_sys_tablespaces s, information_schema.files f
37 WHERE s.name like '%ibport%' AND s.space = f.file_id ORDER BY s.space;
38
39 --echo # Directory listing of MYSQLD_DATADIR/test/ ibport*.frm
40 --replace_result #P# #p# #SP# #sp#
41 --list_files $MYSQLD_DATADIR/test/ ibport*.frm
42
43 --echo # Directory listing of MYSQLD_DATADIR/test/ ibport*.isl
44 --replace_result #P# #p# #SP# #sp#
45 --list_files $MYSQLD_DATADIR/test/ ibport*.isl
46
47 --echo # Directory listing of MYSQLD_DATADIR/test/ ibport*.ibd
48 --replace_result #P# #p# #SP# #sp#
49 --list_files $MYSQLD_DATADIR/test/ ibport*.ibd
50
51 --echo # Directory listing of MYSQLD_DATADIR/ ibport*.isl
52 --replace_result #P# #p# #SP# #sp#
53 --list_files $MYSQLD_DATADIR/ ibport*.isl
54
55 --echo # Directory listing of MYSQLD_DATADIR/ ibport*.ibd
56 --replace_result #P# #p# #SP# #sp#
57 --list_files $MYSQLD_DATADIR/ ibport*.ibd
58
59 --echo # Directory listing of ../spaces/ ibport*
60 --replace_result #P# #p# #SP# #sp#
61 --list_files $MYSQLD_DATADIR/../spaces/ ibport*
62
63 --echo # Add some uncommitted records to these tablespaces before clean shutdown
64 INSERT INTO ibport_t1 VALUES (5, 'Five', 55);
65 INSERT INTO ibport_t5 VALUES (5, 'Five', 55);
66 INSERT INTO ibport_t6 VALUES (5, 'Five', 55);
67 BEGIN;
68 UPDATE ibport_t1 SET a = 99, b = 'Uncommitted' WHERE a < 3;
69 UPDATE ibport_t5 SET a = 99, b = 'Uncommitted' WHERE a < 3;
70 UPDATE ibport_t6 SET a = 99, b = 'Uncommitted' WHERE a < 3;
71 DELETE FROM ibport_t1 WHERE a = 3;
72 DELETE FROM ibport_t5 WHERE a = 3;
73 DELETE FROM ibport_t6 WHERE a = 3;
74
75 --echo #
76 --echo # Shutdown the server and replace the relative paths in the ISL files with
77 --echo # full paths to these locations. This makes the SYS_DATAFILES.PATH and the
78 --echo # ISL path look different but point to the same place. InnoDB should
79 --echo # recognize that they point to the same file and update SYS_DATAFILES.PATH.
80 --echo #
81 --source include/shutdown_mysqld.inc
82
83 --echo # Put the full path to the *.ibd files into *.isl files.
84 --exec echo $MYSQLD_DATADIR/ibport_s1_gen.ibd > $MYSQLD_DATADIR/ibport_s1_gen.isl
85 --exec echo $MYSQLD_DATADIR\\..spaces\\ibport_s2_gen.ibd > $MYSQLD_DATADIR/ibport_s2_gen.isl
86 --exec echo $MYSQLD_DATADIR/test\\ibport_t1.ibd > $MYSQLD_DATADIR/test/ibport_t1.isl
87
88 --echo # Restart the DB server.
89 --echo # Show that the tables are open and the full paths are in SYS_DATAFILES.
90 --source include/start_mysqld.inc
91
92 --echo # Directory listing of MYSQLD_DATADIR/test/ ibport*.frm
93 --replace_result #P# #p# #SP# #sp#
94 --list_files $MYSQLD_DATADIR/test/ ibport*.frm
95
96 --echo # Directory listing of MYSQLD_DATADIR/test/ ibport*.isl
97 --replace_result #P# #p# #SP# #sp#
98 --list_files $MYSQLD_DATADIR/test/ ibport*.isl
99
100 --echo # Directory listing of MYSQLD_DATADIR/test/ ibport*.ibd
101 --replace_result #P# #p# #SP# #sp#
102 --list_files $MYSQLD_DATADIR/test/ ibport*.ibd
103
104 --echo # Directory listing of MYSQLD_DATADIR/ ibport*.isl
105 --replace_result #P# #p# #SP# #sp#
106 --list_files $MYSQLD_DATADIR/ ibport*.isl
107
108 --echo # Directory listing of MYSQLD_DATADIR/ ibport*.ibd
109 --replace_result #P# #p# #SP# #sp#
110 --list_files $MYSQLD_DATADIR/ ibport*.ibd
111
112 --echo # Directory listing of ../spaces/ ibport*
113 --replace_result #P# #p# #SP# #sp#
114 --list_files $MYSQLD_DATADIR/../spaces/ ibport*
115
116 SELECT * FROM ibport_t1 ORDER BY a;
117 SELECT * FROM ibport_t5 ORDER BY a;
118 SELECT * FROM ibport_t6 ORDER BY a;
119
120 --replace_result #P# #p# #SP# #sp# $MYSQLD_DATADIR MYSQLD_DATADIR
121 SELECT s.space_type 'Type', s.name 'Space Name', d.path 'Path'
122 FROM information_schema.innodb_sys_tablespaces s, information_schema.innodb_sys_datafiles d
123 WHERE s.name like '%ibport%' AND s.space = d.space ORDER BY s.space;
124
125 --replace_result #P# #p# #SP# #sp# $MYSQLD_DATADIR MYSQLD_DATADIR
126 SELECT s.space_type 'Type', s.name 'Space Name', f.file_name 'Path'
127 FROM information_schema.innodb_sys_tablespaces s, information_schema.files f
128 WHERE s.name like '%ibport%' AND s.space = f.file_id ORDER BY s.space;
129
130 SHOW CREATE TABLE ibport_t1;
131 SHOW CREATE TABLE ibport_t5;
132 SHOW CREATE TABLE ibport_t6;
133
134 --echo # Add some uncommitted records to these tablespaces before clean shutdown
135 INSERT INTO ibport_t1 VALUES (6, 'Six', 66);
136 INSERT INTO ibport_t5 VALUES (6, 'Six', 66);
137 INSERT INTO ibport_t6 VALUES (6, 'Six', 66);
138 BEGIN;
139 UPDATE ibport_t1 SET a = 99, b = 'Uncommitted' WHERE a < 3;
140 UPDATE ibport_t5 SET a = 99, b = 'Uncommitted' WHERE a < 3;
141 UPDATE ibport_t6 SET a = 99, b = 'Uncommitted' WHERE a < 3;
142 DELETE FROM ibport_t1 WHERE a = 3;
143 DELETE FROM ibport_t5 WHERE a = 3;
144 DELETE FROM ibport_t6 WHERE a = 3;
145
146 --echo # Stop server
147 --source include/shutdown_mysqld.inc
148
149 --echo #
150 --echo # Move all the datafiles to a new location and update the isl files.
151 --echo #
152
153 --move_file $MYSQLD_DATADIR/test/ibport_t1.ibd $MYSQL_TMP_DIR/portability/tables/ibport_t1.ibd
154 --move_file $MYSQLD_DATADIR/ibport_s1_gen.ibd $MYSQL_TMP_DIR/portability/spaces/ibport_s1_gen.ibd
155 --move_file $MYSQLD_DATADIR/../spaces/ibport_s2_gen.ibd $MYSQL_TMP_DIR/portability/spaces/ibport_s2_gen.ibd
156
157 --echo # Replace the *.isl files with the full path to the *.ibd files
158 --exec echo $MYSQL_TMP_DIR/portability/tables\\ibport_t1.ibd > $MYSQLD_DATADIR/test/ibport_t1.isl
159 --exec echo $MYSQL_TMP_DIR/portability\\spaces/ibport_s1_gen.ibd > $MYSQLD_DATADIR/ibport_s1_gen.isl
160 --exec echo $MYSQL_TMP_DIR\\portability/spaces\\ibport_s2_gen.ibd > $MYSQLD_DATADIR/ibport_s2_gen.isl
161
162 --echo # Directory listing of MYSQLD_DATADIR/ ibport*
163 --list_files $MYSQLD_DATADIR/ ibport*
164 --echo # Directory listing of MYSQLD_DATADIR/test/ ibport*.frm
165 --list_files $MYSQLD_DATADIR/test/ ibport*.frm
166 --echo # Directory listing of MYSQLD_DATADIR/test/ ibport*.isl
167 --list_files $MYSQLD_DATADIR/test/ ibport*.isl
168 --echo # Directory listing of MYSQLD_DATADIR/test/ ibport*.ibd
169 --list_files $MYSQLD_DATADIR/test/ ibport*.ibd
170 --echo # Directory listing of MYSQL_TMP_DIR/portability/tables/ ibport*
171 --list_files $MYSQL_TMP_DIR/portability/tables/ ibport*
172 --echo # Directory listing of MYSQL_TMP_DIR/portability/spaces/ ibport*
173 --list_files $MYSQL_TMP_DIR/portability/spaces/ ibport*
174
175 --echo # Start the DB server
176 --source include/start_mysqld.inc
177
178 SELECT * FROM ibport_t1 ORDER BY a;
179 SELECT * FROM ibport_t5 ORDER BY a;
180 SELECT * FROM ibport_t6 ORDER BY a;
181
182 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
183 SELECT s.space_type 'Type', s.name 'Space Name', d.path 'Path'
184 FROM information_schema.innodb_sys_tablespaces s, information_schema.innodb_sys_datafiles d
185 WHERE s.name like '%ibport%' AND s.space = d.space ORDER BY s.space;
186
187 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
188 SELECT s.space_type 'Type', s.name 'Space Name', f.file_name 'Path'
189 FROM information_schema.innodb_sys_tablespaces s, information_schema.files f
190 WHERE s.name like '%ibport%' AND s.space = f.file_id ORDER BY s.space;
191
192 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
193 SHOW CREATE TABLE ibport_t1;
194 SHOW CREATE TABLE ibport_t5;
195 SHOW CREATE TABLE ibport_t6;
196
197 --echo # Add some uncommitted records to these tablespaces before clean shutdown
198 INSERT INTO ibport_t1 VALUES (7, 'Seven', 77);
199 INSERT INTO ibport_t5 VALUES (7, 'Seven', 77);
200 INSERT INTO ibport_t6 VALUES (7, 'Seven', 77);
201 BEGIN;
202 UPDATE ibport_t1 SET a = 99, b = 'Uncommitted' WHERE a < 3;
203 UPDATE ibport_t5 SET a = 99, b = 'Uncommitted' WHERE a < 3;
204 UPDATE ibport_t6 SET a = 99, b = 'Uncommitted' WHERE a < 3;
205 DELETE FROM ibport_t1 WHERE a = 3;
206 DELETE FROM ibport_t5 WHERE a = 3;
207 DELETE FROM ibport_t6 WHERE a = 3;
208
209 --echo #
210 --echo # Shutdown the server again and move each of the tablespaces to
211 --echo # a common location and update the ISL files accordingly.
212 --echo #
213 --source include/shutdown_mysqld.inc
214
215 --move_file $MYSQL_TMP_DIR/portability/tables/ibport_t1.ibd $MYSQL_TMP_DIR/portability/altogether/ibport_t1.ibd
216 --move_file $MYSQL_TMP_DIR/portability/spaces/ibport_s1_gen.ibd $MYSQL_TMP_DIR/portability/altogether/ibport_s1_gen.ibd
217 --move_file $MYSQL_TMP_DIR/portability/spaces/ibport_s2_gen.ibd $MYSQL_TMP_DIR/portability/altogether/ibport_s2_gen.ibd
218
219 --exec echo $MYSQL_TMP_DIR\\portability/altogether/ibport_t1.ibd > $MYSQLD_DATADIR/test/ibport_t1.isl
220 --exec echo $MYSQL_TMP_DIR\\portability/altogether\\ibport_s1_gen.ibd > $MYSQLD_DATADIR/ibport_s1_gen.isl
221 --exec echo $MYSQL_TMP_DIR/portability/altogether\\ibport_s2_gen.ibd > $MYSQLD_DATADIR/ibport_s2_gen.isl
222
223 --echo # Directory listing of MYSQLD_DATADIR/test/ ibport*.frm
224 --list_files $MYSQLD_DATADIR/test/ ibport*.frm
225 --echo # Directory listing of MYSQLD_DATADIR/test/ ibport*.isl
226 --list_files $MYSQLD_DATADIR/test/ ibport*.isl
227 --echo # Directory listing of MYSQLD_DATADIR/test/ ibport*.ibd
228 --list_files $MYSQLD_DATADIR/test/ ibport*.ibd
229 --echo # Directory listing of MYSQL_TMP_DIR/portability/altogether/
230 --list_files $MYSQL_TMP_DIR/portability/altogether/
231
232 --echo # Start the DB server
233 --source include/start_mysqld.inc
234
235 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
236 SELECT s.space_type 'Type', s.name 'Space Name', d.path 'Path'
237 FROM information_schema.innodb_sys_tablespaces s, information_schema.innodb_sys_datafiles d
238 WHERE s.name like '%ibport%' AND s.space = d.space ORDER BY s.space;
239
240 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
241 SELECT s.space_type 'Type', s.name 'Space Name', f.file_name 'Path'
242 FROM information_schema.innodb_sys_tablespaces s, information_schema.files f
243 WHERE s.name like '%ibport%' AND s.space = f.file_id ORDER BY s.space;
244
245 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
246 SHOW CREATE TABLE ibport_t1;
247 SHOW CREATE TABLE ibport_t5;
248 SHOW CREATE TABLE ibport_t6;
249
250 SELECT * FROM ibport_t1 ORDER BY a;
251 SELECT * FROM ibport_t5 ORDER BY a;
252 SELECT * FROM ibport_t6 ORDER BY a;
253
254 --echo # Add some uncommitted records to these tablespaces before clean shutdown
255 INSERT INTO ibport_t1 VALUES (8, 'Eight', 88);
256 INSERT INTO ibport_t5 VALUES (8, 'Eight', 88);
257 INSERT INTO ibport_t6 VALUES (8, 'Eight', 88);
258 BEGIN;
259 UPDATE ibport_t1 SET a = 99, b = 'Uncommitted' WHERE a < 3;
260 UPDATE ibport_t5 SET a = 99, b = 'Uncommitted' WHERE a < 3;
261 UPDATE ibport_t6 SET a = 99, b = 'Uncommitted' WHERE a < 3;
262 DELETE FROM ibport_t1 WHERE a = 3;
263 DELETE FROM ibport_t5 WHERE a = 3;
264 DELETE FROM ibport_t6 WHERE a = 3;
265
266 --echo #
267 --echo # Shutdown the server again and move each of the tablespaces to their
268 --echo # default locations. Leave the ISL files and the dictionary pointing to
269 --echo # the MYSQL_TMP_DIR/portability/altogether location. The dictionary
270 --echo # will be adjusted when the files are found in the default locations.
271 --echo # The ISL files will be ignored.
272 --echo #
273 --source include/shutdown_mysqld.inc
274
275 --move_file $MYSQL_TMP_DIR/portability/altogether/ibport_t1.ibd $MYSQLD_DATADIR/test/ibport_t1.ibd
276 --move_file $MYSQL_TMP_DIR/portability/altogether/ibport_s1_gen.ibd $MYSQLD_DATADIR/ibport_s1_gen.ibd
277 --move_file $MYSQL_TMP_DIR/portability/altogether/ibport_s2_gen.ibd $MYSQLD_DATADIR/ibport_s2_gen.ibd
278
279 --echo # Directory listing of MYSQLD_DATADIR/ ibport*.ibd
280 --list_files $MYSQLD_DATADIR/ ibport*.ibd
281
282 --echo # Directory listing of MYSQLD_DATADIR/ ibport*.isl
283 --list_files $MYSQLD_DATADIR/ ibport*.isl
284
285 --echo # Directory listing of MYSQLD_DATADIR/test/ ibport*.frm
286 --list_files $MYSQLD_DATADIR/test/ ibport*.frm
287
288 --echo # Directory listing of MYSQLD_DATADIR/test/ ibport*.isl
289 --list_files $MYSQLD_DATADIR/test/ ibport*.isl
290
291 --echo # Directory listing of MYSQLD_DATADIR/test/ ibport*.ibd
292 --list_files $MYSQLD_DATADIR/test/ ibport*.ibd
293
294 --echo # Directory listing of MYSQL_TMP_DIR/portability/altogether/
295 --list_files $MYSQL_TMP_DIR/portability/altogether/
296
297 --echo # Start the DB server
298 --source include/start_mysqld.inc
299
300 SHOW CREATE TABLE ibport_t1;
301 SHOW CREATE TABLE ibport_t5;
302 SHOW CREATE TABLE ibport_t6;
303
304 SELECT s.space_type 'Type', s.name 'Space Name', d.path 'Path'
305 FROM information_schema.innodb_sys_tablespaces s, information_schema.innodb_sys_datafiles d
306 WHERE s.name like '%ibport%' AND s.space = d.space ORDER BY s.space;
307
308 SELECT s.space_type 'Type', s.name 'Space Name', f.file_name 'Path'
309 FROM information_schema.innodb_sys_tablespaces s, information_schema.files f
310 WHERE s.name like '%ibport%' AND s.space = f.file_id ORDER BY s.space;
311
312 SELECT * FROM ibport_t1 ORDER BY a;
313 SELECT * FROM ibport_t5 ORDER BY a;
314 SELECT * FROM ibport_t6 ORDER BY a;
315
316 --echo # Add some uncommitted records to these tablespaces before clean shutdown
317 INSERT INTO ibport_t1 VALUES (9, 'Nine', 99);
318 INSERT INTO ibport_t5 VALUES (9, 'Nine', 99);
319 INSERT INTO ibport_t6 VALUES (9, 'Nine', 99);
320 BEGIN;
321 UPDATE ibport_t1 SET a = 99, b = 'Uncommitted' WHERE a < 3;
322 UPDATE ibport_t5 SET a = 99, b = 'Uncommitted' WHERE a < 3;
323 UPDATE ibport_t6 SET a = 99, b = 'Uncommitted' WHERE a < 3;
324 DELETE FROM ibport_t1 WHERE a = 3;
325 DELETE FROM ibport_t5 WHERE a = 3;
326 DELETE FROM ibport_t6 WHERE a = 3;
327
328 --echo #
329 --echo # Shutdown the server again and move each of the tablespaces to the
330 --echo # original locations.
331 --echo # Make the ISL files point to these locations. using relative pathnames.
332 --echo # The dictionary is pointing to the default locations and will be adjusted.
333 --echo #
334 --source include/shutdown_mysqld.inc
335
336 --move_file $MYSQLD_DATADIR/ibport_s2_gen.ibd $MYSQLD_DATADIR/../spaces/ibport_s2_gen.ibd
337 --remove_file $MYSQLD_DATADIR/test/ibport_t1.isl
338
339 --exec echo ..\\spaces/ibport_s2_gen.ibd > $MYSQLD_DATADIR/ibport_s2_gen.isl
340
341 --echo # Directory listing of MYSQLD_DATADIR/test/ ibport*.frm
342 --list_files $MYSQLD_DATADIR/test/ ibport*.frm
343
344 --echo # Directory listing of MYSQLD_DATADIR/test/ ibport*.isl
345 --list_files $MYSQLD_DATADIR/test/ ibport*.isl
346
347 --echo # Directory listing of MYSQLD_DATADIR/test/ ibport*.ibd
348 --list_files $MYSQLD_DATADIR/test/ ibport*.ibd
349
350 --echo # Start the DB server
351 --source include/start_mysqld.inc
352
353 SELECT * FROM ibport_t1 ORDER BY a;
354 SELECT * FROM ibport_t5 ORDER BY a;
355 SELECT * FROM ibport_t6 ORDER BY a;
356
357 SHOW CREATE TABLE ibport_t1;
358 SHOW CREATE TABLE ibport_t5;
359 SHOW CREATE TABLE ibport_t6;
360
361 SELECT s.space_type 'Type', s.name 'Space Name', d.path 'Path'
362 FROM information_schema.innodb_sys_tablespaces s, information_schema.innodb_sys_datafiles d
363 WHERE s.name like '%ibport%' AND s.space = d.space ORDER BY s.space;
364
365 SELECT s.space_type 'Type', s.name 'Space Name', f.file_name 'Path'
366 FROM information_schema.innodb_sys_tablespaces s, information_schema.files f
367 WHERE s.name like '%ibport%' AND s.space = f.file_id ORDER BY s.space;
368
369 --echo #
370 --echo # Cleanup
371 --echo #
372
373 DROP TABLE ibport_t1;
374 DROP TABLE ibport_t5;
375 DROP TABLE ibport_t6;
376 DROP TABLESPACE ibport_s1;
377 DROP TABLESPACE ibport_s2;
378 --rmdir $MYSQLD_DATADIR/../spaces
379 --rmdir $MYSQLD_DATADIR/../remote
380 --rmdir $MYSQL_TMP_DIR/portability/altogether
381 --rmdir $MYSQL_TMP_DIR/portability/tables
382 --rmdir $MYSQL_TMP_DIR/portability/spaces
383 --rmdir $MYSQL_TMP_DIR/portability
384
385 --disable_query_log
386 call mtr.add_suppression("\\[ERROR\\] \\[[^]]*\\] InnoDB: Operating system error number [0-9]* in a file operation");
387 call mtr.add_suppression("\\[ERROR\\] \\[[^]]*\\] InnoDB: Cannot open datafile for read-only:");
388 call mtr.add_suppression("\\[ERROR\\] \\[[^]]*\\] InnoDB: A link file was found named '.*isl' but the linked tablespace '.*ibd' could not be opened read-only");
389 call mtr.add_suppression("\\[ERROR\\] \\[[^]]*\\] InnoDB: The error means the system cannot find the path specified");
390 call mtr.add_suppression("\\[ERROR\\] \\[[^]]*\\] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them");
391 --enable_query_log