You are hereDB Uploading from local to remote

DB Uploading from local to remote

By Marko Blažeković - Posted on 16 September 2015

mysqldump -u user -p databasename > dump.sql

Then using SCP transfer the file to the remote server:

scp dump.sql [email protected]:

Then use the mysql client there to import the dump.sql with:

mysql -u user_name -p databasename < dump.sql

Tags