Logo Gray

import/export mysql database from debian to windows

1. Go to the server where you dump the DB.

				
					mysqldump -u root cl > /tmp/DB_NAME.sql
				
			

2. Import the DB into Local MariaDB

use smartTTY to download the file created in /TMP/DB_NAME.sql

				
					"C:\Program Files\MariaDB 11.3\bin\mysql.exe" -u root -p NEW_DB_NAME < "C:\Users\jonas\Downloads\DB_NAME.sql"

				
			

NEEDS TESTING: (hatte das PW nicht)

ssh LOGIN_NAME@IP_ADDRESS „mysqldump -u root DB_NAME > /tmp/DB_NAME.sql“ > C:\Users\jonas\Downloads\NEW_DB_NAME.sql