search

tomlankhorst / comments

utterances 🔮
0 stars 0 forks source link

import-remote-mysql-db-over-ssh/ #12

Open utterances-bot opened 3 years ago

utterances-bot commented 3 years ago

Import Remote Database Directly over SSH | Tom Lankhorst

Developing, maintaining and debugging web-applications often involves copying a remote database to a local or another remote machine. This post lists a number of methods that I find useful. It acts as a reference for myself which I happily update and improve based on comments and experience. My favourite method:  stream the database dump directly to the target machine. I assume a MySQL or MariaDB database on a Unix or Mac OS machine but by adjusting the appropriate commands most of these methods apply to other databases as well.

https://tomlankhorst.nl/import-remote-mysql-db-over-ssh/

tomlankhorst commented 3 years ago

Original author: Ruslan Akhmyatzanov @ruslanakhmyatzanov
Original date: 2020-02-21T20:48:32Z

Great article! Thanks a lot!

atif089 commented 3 years ago

This saved me from upgrading my disk space just to be able to import a database. Thanks a ton for this!