6.0 has scripts/create_tables_mysql_4_1_2+.sql, which should be used
instead of create_tables.sql for MySQL version 4.1.2 and higher.
Be warned that this script will erase the phpmyadmin database, if it exists,
destroying all metadata about relations.
A possible method to execute this script is to use the technique described in
Chapter 8 (Importing Structure and Data), using the SQL sub-page and the file
selector. For this to work, we must have the create_tables.sql script somewhere
on our workstation. After the creation, the left panel looks like this:
Chapter 11
[ 175 ]
It is now time to adjust all the relational-features related parameters in
config.inc.php. Here we use the default values mentioned in the comments inside
the file; these database and table names are the ones that have just been created:
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['relation'] = 'pma_relation';
$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
$cfg['Servers'][$i]['history'] = 'pma_history';
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
As table names are case sensitive, we must use the same names as the
tables created by the installation script.
Pages:
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174