{"id":9434,"date":"2022-04-21T13:35:28","date_gmt":"2022-04-21T17:35:28","guid":{"rendered":"https:\/\/kb.n0c.com\/?post_type=ht_kb&p=9434"},"modified":"2026-08-31T12:11:04","modified_gmt":"2026-08-31T16:11:04","slug":"database-import-export-in-command-line-user-mode","status":"publish","type":"ht_kb","link":"https:\/\/kb.n0c.com\/en\/knowledge-base\/database-import-export-in-command-line-user-mode\/","title":{"rendered":"How to Import\/Export Database in Command Line (User Mode)"},"content":{"rendered":"\n

Introduction<\/h2>\n\n\n\n

This article explains how to import\/export database in command line (user mode).<\/p>\n\n\n\n

Before explaining the basic principles of this article, it is necessary to make sure that the reader is familiar with certain notions. We will therefore start by defining the terms we will use, sometimes using English translations of words commonly used in computing. At the same time, we will explain the concepts underlying the principles we are dealing with.<\/p>\n\n\n\n

Then, using examples from MySQL, we will discuss the concrete application of the concepts taught.<\/p>\n\n\n\n

Finally, some references to consult will be proposed.<\/p>\n\n\n\n

Note :<\/strong> <\/strong>The Glossary<\/a> contains explanations on multiple topics and can be consulted to clarify certain terms.<\/p>\n\n\n\n

Terminology and Basic Concepts<\/h2>\n\n\n\n

It is sometimes necessary to recover all of the data contained in a database, either to make a backup or to switch to another database. The term “export” refers precisely to the action of formatting all the information necessary to create a database identical to the first one in an export file, called a dump. The term “import” refers to the opposite operation: creating a new database in a DBMS from an export file.<\/p>\n\n\n\n

It is important to understand what a command line interface (CLI) is. A CLI is a man-machine interface in which the user interacts with a computer system by entering textual instruction lines to ask the computer to perform operations, which are interpreted by a Shell (as opposed to using a Graphic User Interface, or GUI). Figure 1 shows an example of the instruction lines written in MySQL.<\/p>\n\n\n\n

mysqldump -h host -u user\n-ppass -rfile database [tables]<\/pre>\n\n\n\n
Figure 1 \u2013 Textual instruction lines of a command line interface (MySQL)<\/span><\/em><\/p>\n\n\n\n
The diagram in Figure 2 summarizes the basic principle of importing and exporting a database from the command line into a DBMS:<\/p>\n\n\n
\n
\"importing<\/a><\/figure><\/div>\n\n\n
Figure 2 — Importing and exporting a database into a DBMS<\/span><\/em><\/p>\n\n\n\n
The interpretation of the command line by the Shell can be done in two ways: in Kernel mode or in user mode. In the latter mode, which is of interest to us here – that of applications in particular – the executed code does not have direct access to the hardware or to a memory location as is the case in Kernel mode, with all the risks that this entails. On the contrary, in user mode, the code delegates these accesses to the Application Programming Interface (API) of the system.<\/p>\n\n\n\n
To summarize what we have seen so far, our goal is to explain the basic principles of formatting in a file (dump) all the information necessary to create a database identical to the original one – export – and to create a new database from such a file – import – by communicating with the computer by means of textual instructions that do not allow direct access to the hardware or to a location in memory.<\/p>\n\n\n\n
Examples of Command Line Usage<\/h2>\n\n\n\n
In order to illustrate concretely the principles we have explained so far, we will proceed by example. We will deal with the tools that MySQL offers to export its databases to other DBMS or to import them from the command line.<\/p>\n\n\n\n
Complete Export of a MySQL Database<\/h3>\n\n\n\n
The main online command for exporting data is called mysql. This command allows you to export an entire database hosted by MySQL. Here is the syntax:<\/p>\n\n\n\n
mysql -h host -u user -ppass database > file_dump<\/pre>\n\n\n\n
The following notation is also possible:<\/p>\n\n\n\n
mysql --host host --user user\n--passwordpass database > dump_file<\/pre>\n\n\n\n
Here is the definition of each term:<\/p>\n\n\n\n