Question

backing mysql db database using mysqldump

I need to back a mysql (version 5.5.46) db running on my droplet linux ubuntu 14,04 using mysqldump none of the command i have googled has worked … somebody help i have so far used this

code mysqldump -u root -p google_test < mybackup.sql

what am I missing 
Subscribe
Share

What I like to do is remember the direction of the bracket as an arrow and what I’m trying to do. For example the “>” bracket for mysqldump points from the database name to the file name. If you were importing the database, the arrow would point from the filename to the database name.

Happy coding,

Jon Schwenn Platform Support Specialist DigitalOcean

mysqldump --user=root --password=yourpassword --host=localhost google_test > mybackup.sql


Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

This question was answered by @jschwenn:

What I like to do is remember the direction of the bracket as an arrow and what I’m trying to do. For example the “>” bracket for mysqldump points from the database name to the file name. If you were importing the database, the arrow would point from the filename to the database name.

Happy coding,

Jon Schwenn Platform Support Specialist DigitalOcean

View the original comment