MySQL

When restoring MySQL, you need to select specific databases. The restore process has several options:

Restore to disk as .sql files

With this option, you need to enter a restore path. When entering this path, the specified databases will be restored to it. For example, if you specify the restore path /tmp and you have selected a sample database database.sql for restoration, then the database will be restored to /tmp/database.sql.

Restore as program input

With this method, you can restore the content to a program that expects the content as its input.

Restore as compressed archive

If you wish, you can restore the selected .sql files as an archive. You need to specify a path and name for the output file, as well as the format. The supported formats are tar, tar.gz, and zip.

Direct restore to the MySQL server

With this option you can restore directly to a MySQL server. You need to provide a username, password, server (host), and port. Using this option, if the database exists on the MySQL server, it will be replaced with the one from the backup. If it does not exist, it will be created anew.