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.
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.
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.
|mysql -h rdbms -u USERNAME -pPASSWORD DBxxxxxx |
|COMMAND: mysql -h rdbms.strato.de -u USER NAME -p DBxxxxxx |
OUTPUT: Enter password:
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