Category: Linux Terminal

Added: 15th of December 2015

Viewed: 2002 times

Import - Export MySQL / MariaDB database using the terminal in Ubuntu Linux

To Export your database using the terminal, in Ubuntu enter the following command:-

mysqldump -u {database_username} -p {database_name} > mysqlbackup.sql

You will be prompted for your MySQL password. Your database will then be downloaded.

To Import your database using the terminal in Ubuntu enter the following command:-
mysql -u {database_username} -p {database_name} < mysqlbackup.sql

You will be prompted for your MySQL password. Your database will then be imported.

Other ways to import and export MySQL:-
There are other ways to Import and Export your database using PHPMyAdmin.
This is fine for small imports and exports but most webhosts impose a 2MB limit on imports.

Using PHPMyAdmin on a live busy site, may also lock all the tables whilst importing or exporting the databases. It also takes longer to import and export using this method.

PHPMyAdmin's strengths are it's ease of use when creating new databases, tables and fields. This can be done directly through your webbrowser, without the need to use the terminal.

Other Tips & Tutorials

Linux Terminal

Create a simple cronjob in Linux

Posted: 20th of October 2020

Views: 82

Linux Terminal

Create a new folder and file using the mkdir and touch commands using the terminal in Linux

Posted: 16th of August 2020

Views: 155

Linux Terminal

Convert a PDF document to text or html using pdftotext, pdftohtml in Linux using the terminal

Posted: 3rd of August 2020

Views: 189

Linux Terminal

List files in a directory using the ls command

Posted: 22nd of July 2020

Views: 184

Linux Terminal

How to access HP Linux Imaging and Printing System set up on Ubuntu using the terminal

Posted: 13th of November 2019

Views: 510

Linux Terminal

Where are the log files located in Linux

Posted: 16th of October 2019

Views: 578

Linux Terminal

Oracle VirtualBox, Unable to insert virtual optical disk

Posted: 11th of October 2019

Views: 1942

Linux Terminal

Oracle VirtualBox only displaying 32-bit version(s), when setting up new Virtual Machine on Linux

Posted: 11th of October 2019

Views: 671

Linux Terminal

The Linux uptime command

Posted: 3rd of October 2019

Views: 715

Linux Terminal

Using GParted in Linux to format a hard drive, flash drive, SD Card

Posted: 17th of September 2019

Views: 1053