Task
Restore (import) a full MariaDb or MySQL backup via terminal command line.
Note:
- Server: myserver.mindwatering.net
- OS login: myadminid
- MariaDb login: abc123EFWPUsr / ReallyGreatPassword
- MariaDb database: abc123EFWP
- SQL Backup location: /home/myadminid/sqlbackup/websitebackup.sql
Steps
1. Login:
$ ssh myadminid@myserver.mindwatering.net
<enter password if not private key-based>
2. Login to MariaDB and the (empty) database:
$ mariadb --user=abc123EFWPUsr --password=ReallyGreatPassword
> use abc123EFWP;
<database changed>
> exit;
3. Import the SQL file:
$ mariadb -u abc123EFWPUsr -p < /home/myadminid/sqlbackup/websitebackup.sql
<enter password - wait for restore>
previous page
|