MySQL backup and restore from command line

Backup:
mysqldump -u username -p [-h hostname] [database_name] > dumpfilename.sql

Import
mysql -u username -p [-h hostname] [database_name] < path/to/dumpfilename.sql

 

NOTE: One could also type down password in advance -p[password] , but this option is insecure since password will then be visible in shell command history.
 

By Aleksandar Jakovljević

My name is Aleksandar Jakovljević and I am a web developer from Belgrade, Serbia. I was born in Smederevo, in 1980. I started focusing on web development since late 2003. I am mostly focused on open source web technologies. I specialised in PHP, focusing on Symfony framework, with skills in Drupal and WordPress, too. I worked more than 7 years for art_net studio. I work for Computer Rock (former Spoiled Milk) since April 2011. I love the web and everything related to it. The possibility to publish your ideas quickly and make them available to the entire world is what made me decide to pursue a career in web development.

Follow on: Twitter | GitHub | LinkedIn | Facebook | Instagram

Leave a comment

Your email address will not be published. Required fields are marked *