DB Dump

Import Data use WSL

Export .sql file in Database

• Create an folder for store .sql file
  • Login to the Database find out the database SHOW DATABASES;
  • backup command
  • mysqldump -u your-username -p your-database-name > /home/ec2-user/backups/your_database_backup.sql
• Example : mysqldump -u your-username -p your-database-name > /home/ec2-user/backups/your_database_backup.sql

Go to File Explore Linux Distro \wsl.localhost\Ubuntu-22.04\tmp

login to Database Use this Commands to dump

Pgsql

Switch to Main to over db name

\c db_name

use this Command dump

\i /tmp/bip.sql

mysql

Switch to Main to over db name

USE mydatabase;

use this Command dump

source /tmp/sample.sql;

Export Data use HeidiSQL

website Link

Output : Single SQL File.sql