I usually prefer MySQL workbench to take backups and restore them. But sometimes circumstances bring forward a machine that doesn’t contain workbench. Use command line utility in that case. These backups/dumps are nothing but SQL statements.
mysqldump -u[username] -p [database_name]>[filename].sql
To restore a backup.
mysql -u[username] -p [database_name] <[file_name].sql
If database name is not known then log into MySQL and find database using
show databases;
Published by
Ravi Kumar (RK) Yadav
I am machine learning researcher. Currently working on building customer navigation solutions to help customer express intent faster and easier. Such systems are designed to make customer journey faster from search to checkout.
I spend my spare time working on vision projects.
In spring and summer, I spend my time on growing Cayenne pepper.
I graduated from North Carolina State University – Raleigh, with a master’s degree in computer science in the Spring of 2016. Prior to this, I completed my bachelor’s degree in electronics and communication engineering.
Leave a Reply