Option for one file per innodb table

diff --git a/mysql/edit_cnf.cgi b/mysql/edit_cnf.cgi
index 69564fd..9c1dff5 100755 (executable)
--- a/mysql/edit_cnf.cgi
+++ b/mysql/edit_cnf.cgi
@@ -53,6 +53,10 @@ print &ui_table_row($text{'cnf_stor'},
                                 'NDB', 'ARCHIVE', 'CSV',
                                 'BLACKHOLE' ], 1, 0, 1));
 
+$fpt = &find_value("innodb_file_per_table", $mems);
+print &ui_table_row($text{'cnf_fpt'},
+                   &ui_yesno_radio("fpt", $fpt));
+
 # Show set variables
 print &ui_table_hr();
 

diff --git a/mysql/lang/en b/mysql/lang/en
index 30d662c..d8239f1 100644 (file)
--- a/mysql/lang/en
+++ b/mysql/lang/en
@@ -747,6 +747,7 @@ cnf_enet_buffer_length=Missing or invalid network buffer size
 cnf_emyisam_sort_buffer_size=Missing or invalid MyISAM sort buffer size
 cnf_emax_connections=Missing or invalid maximum number of connections
 cnf_restart=Save and Restart MySQL
+cnf_fpt=Separate file for each InnoDB table?
 
 index_title1=Create Index
 index_header1=Index options

diff --git a/mysql/save_cnf.cgi b/mysql/save_cnf.cgi
index abb51b5..54bff53 100755 (executable)
--- a/mysql/save_cnf.cgi
+++ b/mysql/save_cnf.cgi
@@ -51,6 +51,12 @@ else {
 &save_directive($conf, $mysqld, "default-storage-engine",
                $in{'stor'} ? [ $in{'stor'} ] : [ ]);
 
+$fpt = &find_value("innodb_file_per_table", $mems);
+if ($fpt || $in{'fpt'}) {
+       &save_directive($conf, $mysqld, "innodb_file_per_table",
+                       [ $in{'fpt'} ]);
+       }
+
 &save_directive($conf, $mysqld, "skip-locking",
                $in{'skip-locking'} ? [ "" ] : [ ]);