# Mysql database backup and restore by mysqldump ## MySQL: The Go-To Open-Source RDBMS **MySQL** is a premier open-source Relational Database Management System (RDBMS) acclaimed for its ability to efficiently store, manage, and retrieve structured information. It serves as the backbone for a myriad of applications, ranging from modest personal projects to complex, high-traffic internet sites and sophisticated enterprise solutions. Key highlights of MySQL include its high performance, robust reliability, seamless scalability, and user-friendly nature. Moreover, it boasts wide compatibility across leading operating systems such as Linux, macOS, Windows, and Ubuntu, making it a versatile solution for any environment. ## **Prerequisites: -** Require two Ubuntu 22.04 mysql-server-8.0 ### Update && upgrade ``` apt-get update -y && apt-get upgrade -y ``` ### **Install MySQL** Install MySQL by typing the following command: ``` apt-get install mysql-server-8.0 -y ``` To secure the installation, **MySQL** inside-

### Create **MySQL** databas*e:* ``` mysql> create database testing_database; ```

Using testing database- ``` mysql> user tesing_database; ```

Create testing\_table in the testing\_database ``` mysql> create table testing_table (id int, name varchar(50), address varchar(50), primary key (id)); ```

Insert data to testing\_table ``` mysql> insert into testing_table(id, name, address) values("001", "Ubuntu", "Hiroshima"); ```

show testing\_table ``` mysql> select * from testing_table; ```

### TAKE MYSQL BACKUP AND RESTORE ``` mysqldump --lock-all-tables --all-databases --events > mysql_dump.sql ```

Dump all data without locking but with transaction-ensured data integrity by \[--single-transaction] option:-

Dump specific database:- ``` mysqldump test_database --single-transaction --events > mysql_dump.sql ```

### For Restore Database For restoring data from backup on another host, run as follows. Before restoring, transfer dump data to the target host with \[rsync] or \[scp] and so on. Copy these mysql\_dump.sql another machine:

**$ sftp root\@another\_machine\_ip**

Go to another server machine:

``` apt-get install mysql-server-8.0 -y ```

``` mysql testing_database < mysql_dump.sql ```

--- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.neevcloud.com/neevcloud-guide/neevcloud-knowledgebase/how-to-install-mysql-on-ubuntu-22.04/mysql-database-backup-and-restore-by-mysqldump.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.