How to install mysqldump in Windows 10?
Download MySQL Community Server
Here you will get the mysqldump command
C:\Users\azureuser\Downloads\mysql-8.0.28-winx64\mysql-8.0.28-winx64\bin
Set environment variable inside path variable
C:\Users\azureuser\Downloads\mysql-8.0.28-winx64\mysql-8.0.28-winx64\bin
Run on command prompt
mysqld — install
mysqld — initialize
Start the mysql service
Press window+r and then type services.msc, find the Mysql service and start it.
If Mysql service does not start then restart system.
And then do same for start the service of mysql (services.msc -> Mysql)
Commands
Download all databases
mysqldump -h mysql.ap-south-1.rds.amazonaws.com -uadmin -pPass — ssl-mode=disabled — column-statistics=0 — all-databases > complete.sql
Download specific database and table
mysqldump -h mysql.ap-south-1.rds.amazonaws.com -uadmin -pPass — ssl-mode=disabled — column-statistics=0 wobot chat_details > chat_details.sql
