Forums

MySQL Dump

When I open bash and enter command :

cd
mysqldump -u matchratings -h matchratings.mysql.pythonanywhere-services.com --set-gtid-purged=OFF --no-tablespaces ‘matchratings$matchratings'  > db-backup.sql

I expect to see the output file in the current directory, or an error message, but I see neither, just ">". THANKS!

That's because you're running it in a MySQL console. Use a bash console.

Just now, I tried again: open bash and enter the command and get the result described above. I'm not using a MySQL console that I know of.

How did you open the Bash console? You shouldn't see ">" as a regular prompt in a Bash console. What do you see when you go to the Consoles page and click on "Bash" in "Other" under "Start a new console" section?

I opened the bash console as you described, which is the same as I had previously. I see: 04:14 ~ $

then I enter commands:

mysqldump -u matchratings -h matchratings.mysql.pythonanywhere-services.com --set-gtid-purged=OFF --no-tablespaces ‘matchratings$matchratings'  > db-backup.sql

then I see the prompt: >

In Bash console you'd get this kind of prompt when you hit new line while having a not closed quote.

I can see something wonky in my apostrophes above. I fixed, and executed the dump successfully. Thank you kindly for your help.

Great, glad to hear you worked it out!