ali aboos

Tag: ssh

mySQL: How to backup/restore SQL databases through SSH

by on Oct.30, 2008, under Linux, SQL

To backup your database through SSH (create SQL dump):
mysqldump --opt -u user -p dbname > {path}/backup.sql

To restore:
mysql -u user -p dbname < {path}/backup.sql

Leave a Comment :, , more...

Search InsaneLabs.com

Can't find what you're looking for? Drop a comment on a post or email (ali aht insanelabs doht com)

Links

Links open in a new window