SerwerWeb.pl

The following guide describes how to quickly export a database remotely via ssh from a remote server.

A long time ago I described the way to exporting mysql database locally.

Today I will show you how to download the database directly to your server.

The whole thing is not much different.

The command looks like this:

mysqldump -u użytkownik_bazy -p nazwa_bazy -h nazwa zdalnego hosta_bądź IP> nazwapliku.sql

Example:

mysqldump -u pesco -p pesco -h sql.pesco.nazwa.pl> pesco.sql

The name of the database and user in this case is pesco.
The remote host is sql.pesco.nazwa.pl
a file named pesco.sql will be created

If the base is on a non-standard port, e.g. 3307 we can add an appropriate argument, e.g. :

--port=3307

The comment will be as follows:

mysqldump -u użytkownik_bazy -p nazwa_bazy -h nazwa zdalnego hosta_bądź IP --port=3307> nazwapliku.sql

Important note.

In order to be able to download the database in this way, the database must be able to connect remotely!

After such a quick export, we will also very quickly import the database with us, but that's right I described here before.