Warning: Undefined variable $html in /usr/share/nginx/html/lib/plugins/tabinclude/helper.php on line 192

Warning: Cannot modify header information - headers already sent by (output started at /usr/share/nginx/html/lib/plugins/tabinclude/helper.php:192) in /usr/share/nginx/html/inc/Action/Export.php on line 106

Warning: Cannot modify header information - headers already sent by (output started at /usr/share/nginx/html/lib/plugins/tabinclude/helper.php:192) in /usr/share/nginx/html/inc/Action/Export.php on line 106
fileadmin

File Admin

Secure transfer of database to another server (scp)

Once you have taken a mysql dump you may want to transfer this to another server. You can do this using scp (secure copy).

scp [database name].sql [username]@[servername]:path/to/database/

Example:

scp dbdump.sql luke@x.x.x.x:~/

The example above securely copies the db to the server x.x.x.x and places the file in the root directory. (note: you will need to enter the password for the destination user/server)

scp custom port (example 666):

scp -P 666 filename.sql user@x.x.x.x:/