razerer
razerer

Reputation: 79

Using mysqldump on windows

I'm trying to do mysqldump using the xampp shell. but when I use gzip it gives me an error it says: 'gzip' is not recognized as amn internal or external command, operable program or batch file.

I'm putting in

mysqldump -u root -p database | gzip -9 > C:\database_bu.sql.gz

Upvotes: 0

Views: 2934

Answers (1)

razerer
razerer

Reputation: 79

Well after the response from tadman I was able to resolve it. I installed gzip by going to this site: http://gnuwin32.sourceforge.net/packages/gzip.htm

I made sure it installed the program on C: and I altered my code to the one below and it worked.

mysqldump -u root -p database | C:\GnuWin32\bin\gzip -9 > C:\database_bu.sql.gz

Upvotes: 3

Related Questions