FAQ #690
Artikel editieren
Artikel weiterleiten

How can I restore a backup of my data (*.sql file) through PUTTY/SSH or how can I write my *.sql file to the database?

Through the MySQL Monitor prompt interpreter, you can access your MySQL database through PUTTY.
Here, we describe how you can access a backup of your MySQL database that was created by STRATO:
Beachte auch This is how easily you can access a backup of your MySQL database via SSH
To do this, establish a connection with the internet and start the program PuTTY.
Please enter ssh.strato.de as your host name.

When the connection to the server has been established, your login name and password will be requested.

Enter a domain from your package as the login name, for example desiredname.com. . Confirm the entry by pressing the [ENTER] key. Enter your master password that you assigned in the customer service area as the password. The password is not displayed during input.
Beachte auchWhat is the master password and what is it needed for?

If you received an error message while logging in through SSH or the PuTTY program window simply closes, please check if you entered your access data correctly.

If the data is correct and the login still does not work, please check the SiteGuard settings as well in your password-protected customer service area.


Beachte auchWhat is STRATO SiteGuard and how do I set it up?


The following command line now writes the content of the file.sql file in the database. The file must be on your web space in the main directory.
mysql -h rdbms -u USERNAME -pPASSWORD DBxxxxxx
Please replace USER NAME with your database user name PASSWORD with your password and DBxxxxxx with the name of the database to which you would like to perform the import.
If your password contains special characters like "!, ?, $" or similar, please omit the PASSWOR and execute the command. You will automatically be asked for the password and will be able to enter it here directly. The command then looks like this:
COMMAND: mysql -h rdbms.strato.de -u USER NAME -p DBxxxxxx
OUTPUT: Enter password:

Achtung Please note: If you have a database backup available with the file name file.sql.gz it is necessary to extract this first. Please enter the following command for this:


COMMAND: gunzip file.sql.gz

Please replace file.sql.gz with the file name that is on your web space


Hinweis Note: Of course, you can only restore this backup file (normally file.sql) through PUTTY if you previously performed a data backup. It is possible to restore it via phpMyAdmin, but this is limited by the script runtime starting from a certain number of datasets or file size.