Posted By

hotdiggity on 06/24/09


Tagged

mysql commandline dump ssh terminal


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

umang_nine


MySQL dump using SSH on Mac Terminal


 / Published in: Bash
 

Handy when web hosts limit database upload size. Create folder in home directory call "mysql_dump", upload and extract mysql file into this directory. Ask web host to enable SSH.

  1. ssh username@domain.com.au
  2. mysql -u username_db -p username_db < mysql_dump/db_to_be_imported.sql

Report this snippet  

You need to login to post a comment.