a small script to export-import fresh mysql data ( could be used for moving dbs )

mysql-makefile

# Define variables
EC2_INSTANCE_IP = <EC2_instance_IP>
RDS_INSTANCE_IP = <RDS_instance_IP>
USERNAME = <username>
PASSWORD = <password>
DATABASE_NAME = <database_name>
DUMP_FILE = dump.sql

# Define the export and import commands
export:
	@mysqldump -h $(EC2_INSTANCE_IP) -u $(USERNAME) -p$(PASSWORD) $(DATABASE_NAME) > $(DUMP_FILE)

import:
	@mysql -h $(RDS_INSTANCE_IP) -u $(USERNAME) -p$(PASSWORD) $(DATABASE_NAME) < $(DUMP_FILE)

drop_and_import:
	@mysql -h $(RDS_INSTANCE_IP) -u $(USERNAME) -p$(PASSWORD) $(DATABASE_NAME) -e "DROP TABLE IF EXISTS \`*\`;"
	@mysql -h $(RDS_INSTANCE_IP) -u $(USERNAME) -p$(PASSWORD) $(DATABASE_NAME) < $(DUMP_FILE)

# Define the default target
default: export import

# Define a clean target to remove the dump file
clean:
	@rm $(DUMP_FILE)