Restoring a Database backed up via a dump com

Help
Al Exhkli
2005-11-06
2012-12-07
  • Al Exhkli
    Al Exhkli
    2005-11-06

    Hi Sir,

    How can you restore the dump image finally?

    Thx.
    Alex

     
  • Markus
    Markus
    2005-11-07

    I personally wouldn't include the mysql-stuff into afbackup configuration files.
    I would do the following instead:

    Do a "mysqldump --user=backup ...--all-databases.. > /path/to/a/directory/mysql_backup.sql
    before running afbackup.  Replace "/path/to/a/directory" with a directory that is backuped up by afbackup.
    This way the mysqldump is just a simple, plain file in your backup.

    You can later restore the database with
    mysql < mysql_backup.sql

    Markus