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
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
mysqldumppoints 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
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
mysqldumppoints 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