Topic: affa ibay databse restore

[enchesss]

I have made an affa backup of a SME server set up as a webserver. Is it possible to do a restore of the JOOMLA databse (say JOOMLAWEB) that is installed from an ibay JOOMLAWEB. Usually the backup was done manually by exporting phpmyadmin database but now affa does daily backups. So I need to rsync the databse file from a day ago (daily.1) on the affa server to the website production server. But am unable to find the database file of either server.

[Stefano]

If affa raise the "pre-backup" event, you should find the db dump in /home/e-smith/db/mysql/ dir

[enchesss]

Thank you,

the database files are there as a database_name.dump file/ format.

I copied the database_name.dump file to the local computer and tried to import it using phpmyadmin.

This did not work.

I then renamed it to database_name.sql and this also did not work.

They do not import properly into the phpmyadmin. The database has a lot of missing tables and does not work.

When looking at the database_name.dump file in text editor they are very different from a normal sql export file using phpmyadmin.

So the next step was to try the rsync command but can an explanation of how these .dump files are used differently with rsync than phpmyadmin be available?