[NCLUG] mysql: backing up database - cannot save relationships

[Stephen Warren]

On 08/09/2013 11:50 AM, phil marsh wrote:
> Hi Chris,
> Thanks to you and the others for your advice and information.
> Looking into this last night, it appears that you're right Chris, when using the MyISAM engine, phpmyadmin appears to store all the database's relations in a special database, the pmadb specified by the configuration command $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
> where the rest is specifed via the /etc/phpmyadmin/config.inc.php entries below:
> $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';
> $cfg['Servers'][$i]['tracking'] = 'pma_tracking';

Are you sure the issue isn't simply that the database containing the
data is saved/restored perfectly well, but the phpmyadmin metadata isn't
saved restored, since it's in a different database? If so, simply
save/restore both databases.