DB backup from .sql file on mac

May 21st, 2009

1. Open terminal application (in applications/utilities)

2. Connect to ssh using : ssh username@server

3. Import database using : mysql -u #username# -p #databasename# -h 127.0.0.1 < #filepath#

where

#username# is name

#databasename# is domain_com_dbname

#filepath# is /var/www/html/folder/filename.sql