Note: Before proceeding, make sure you have the necessary permissions to access the MySQL database you want to dump. You should have at least read access to the database.
01. Open Terminal:
Open your Linux terminal. You can usually find it in your applications or use keyboard shortcuts like Ctrl + Alt + T.
02. Login to MySQL:
If your MySQL server requires authentication, you should log in first using the mysql command. Replace username with your MySQL username and password with your password:
mysql -u username -p
You’ll be prompted to enter your password.
03. Choose the Database:
Once logged in, you can select the database you want to dump using the USE command. Replace database_name with the name of your database:
USE database_name;
04. Dump the Database:
To dump the selected database, use the mysqldump command. Replace database_name with the name of your database, and dump_filename.sql with the desired output file name. You can also specify the username and password with the -u and -p options:
mysqldump -u username -p database_name > dump_filename.sql
You’ll be prompted to enter your MySQL password.
For example, to dump a database named “mydatabase” to a file called “mydatabase_dump.sql”:
mysqldump -u username -p mydatabase > mydatabase_dump.sql
05. View the Dumped File:
You can use commands like ls or cat to view or verify the dumped SQL file:
ls -l
cat dump_filename.sql
06. Exit MySQL:
After you’ve successfully dumped the database, you can exit the MySQL session by typing:
exit;
That’s it! You’ve successfully dumped a MySQL database using Linux terminal commands. You can now use this SQL dump to back up your data, migrate it to another server, or for any other purpose you require.