restoring msql dat from webmin backup

[deano]

Hi,

when using webmin to do mysql backups it states at the top of the module page:-

To restore a backup, you can use the Execute SQL form to run the commands in one of the files.

how do i do the above?

 

[Frank_Rizzo]

Use the mysql module page and select a database from the list.

This will list the tables in that database but look near the bottom right for a button 'execute sql'.

Click this and you'll see an option to execute the backup file.

The top part of the screen 'Enter SQL command to run on database....' is for entering your own commands such as selec t * etc.

The middle section is used to restore backup scripts.

The bottom section is used to import csv type files.