Essential MySQL Command-Line Guide: Connect, Backup, Restore & More
This tutorial walks through essential MySQL command-line operations on Linux, covering database connection, creation, deletion, backup strategies, restoration, renaming, and detailed table manipulation such as creating, modifying, and querying data.
1. Database Connection
1.1 Connect to Local Database
1.2 Connect to Remote Database
1.3 Disconnect
2. Database Operations
2.1 Create Database
2.2 Delete Database
2.3 Show Databases
2.4 Connect to a Database
2.5 Backup Database
2.5.1 Backup MySQL database command
2.5.2 Backup MySQL database with DROP TABLE statements
2.5.3 Compressed backup
2.5.4 Backup multiple databases simultaneously
2.5.5 Backup specific tables
2.5.6 Backup only database structure
2.5.7 Backup all data on the server
2.6 Restore Database
2.6.1 Restore MySQL database command
2.6.2 Restore compressed MySQL backup
2.6.3 Transfer database to another server
2.7 Rename Database
3. Table Operations
3.1 Create Table
3.2 Delete Table
3.3 Modify Table
3.4 Add Column
4. Data Manipulation Within Tables
4.1 Insert Data
4.2 Delete Data
4.3 Update Data
4.4 Query Data
Signed-in readers can open the original source through BestHub's protected redirect.
This article has been distilled and summarized from source material, then republished for learning and reference. If you believe it infringes your rights, please contactand we will review it promptly.
MaGe Linux Operations
Founded in 2009, MaGe Education is a top Chinese high‑end IT training brand. Its graduates earn 12K+ RMB salaries, and the school has trained tens of thousands of students. It offers high‑pay courses in Linux cloud operations, Python full‑stack, automation, data analysis, AI, and Go high‑concurrency architecture. Thanks to quality courses and a solid reputation, it has talent partnerships with numerous internet firms.
How this landed with the community
Was this worth your time?
0 Comments
Thoughtful readers leave field notes, pushback, and hard-won operational detail here.