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

[Jesse Griffin]

If you are trying to backup all the databases, then I would use the
--all-databases (-A) option.  Try something like this:

    mysqldump -u $USER -p$PASS --opt -A -E >mysql-dump.sql

Then bzip it if space is an issue: `bzip2 mysql-dump.sql`


Thank you,
Jesse Griffin
tummy.com, ltd.

On 08/09/2013 01:12 PM, Stephen Warren wrote:
> 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.
> _______________________________________________
> NCLUG mailing list       NCLUG at lists.nclug.org
> 
> To unsubscribe, subscribe, or modify
> your settings, go to:
> http://lists.nclug.org/mailman/listinfo/nclug
>