How run MySQL dump inside mysql console

Sometimes it may be necessary to use the mysqldump command in the mysql command line. As you know, this command is an external command and must be executed separately, but with the method we teach, you can also use it in the mysql command line.

 

For this purpose, it is enough to use the phrase \!at the beginning of the command.

\! mysqldump -u username -p database > database_dump.sql

How to Install Zip and Unzip in Linux

Zip is a command-line utility tool used for compressing files and folders. Compression of files & folders enables faster and more efficient transfer, storage, and emailing of files and folders. On the other hand, unzip is a utility tool that helps you decompress files and folders.

Benefits of zipping files:

  • Compressed/zipped files take up less disk space, leaving you with more space to work with.
  • Zipped files are easy to transfer including uploading, downloading, and attaching them on email.
  • You can easily decompress zipped files on Linux, Windows, and even mac.

In this topic, we focus on how you can install the zip and unzip utilities on various Linux distributions.

Read More