Skip to content

TechDirectArchive

Hands-on IT, Cloud, Security, Veeam & DevOps

  • Home
  • About
  • Advertise With US
  • Reviews
  • Contact
  • Toggle search form

How to import a MySQL Database via the command line

Posted on 10/01/201717/08/2026 Christian By Christian No Comments on How to import a MySQL Database via the command line
  1. Home
  2. Oracle/MSSQL/MySQL
  3. How to import a MySQL Database via the command line
MySQL logo with a dolphin, text 'MySQL Server', and graphic of database stacks on a blue background.

MySQL Database (Db) is a fully-managed database service that runs on a Local Server and on the Web. It is ideal for both small and large applications and it uses the standard SQL language. In this article, you will learn how to import a MySQL Database via the command line. Please see How to install PostgreSQL on Ubuntu, How to access MySQL Server from command Prompt, and How to delete a MySQL User Account.

MySQL is free to download and use and has the most comprehensive set of advanced features, management tools, and technical support to achieve the highest levels of MySQL scalability, security, reliability, and uptime. The data in a MySQL database are stored in tables.

See the following guide on MySQL, how to reset Mysql Root password, how to access MySQL Server from command Prompt, and how to migrate Veeam MsSQL Database to a new MsSQL Server.

Import a MySQL Database

root@Plxxrx:~#
root@Plxxrx:~# mysql -u root -p -h localhost cxxp_cxxtao < /var/www/pplxxx.ixxx/mysqlnewdump.sql
or
#mysql -u database_user_name -p my_db < /home/username/my_db_backup.sql

More info: Here it should be almost the same as the export. Also, here is a guide on Standalone Veeam ONE installation: How to set up Veeam ONE 11 Server.

#mysql -u database_user_name -p my_db < /home/kudda/my_db_backup.sql.

Here it is the same as export. After u- you put your database user name and the -p is used for the password option still. See an example of it.

Example: mysql -u root -p my_db < /home/usename/my_db_backup.sql

Here are some related Veeam guides: Fix critical Veeam Backup and Replication 9.5, 10, and 11 vulnerabilities, Veeam Certified Architect: A review of the VMCA Training & Certification, and how to setup Veeam Backup for Microsoft Azure [Part 1].

I hope you found this blog post helpful on How to import a MySQL Database via the command line. If you have any questions, please let me know in the comment session.

Thank you for reading this post. Kindly share it with others.

  • Share on X (Opens in new window) X
  • Share on Reddit (Opens in new window) Reddit
  • Share on LinkedIn (Opens in new window) LinkedIn
  • Share on Facebook (Opens in new window) Facebook
  • Share on Pinterest (Opens in new window) Pinterest
  • Share on Tumblr (Opens in new window) Tumblr
  • Share on Telegram (Opens in new window) Telegram
  • Share on WhatsApp (Opens in new window) WhatsApp
  • Share on Mastodon (Opens in new window) Mastodon
  • Share on Bluesky (Opens in new window) Bluesky
Oracle/MSSQL/MySQL Tags:MySQL, MySQL database

Post navigation

Previous Post: How to mount a USB Drive in Linux
Next Post: Install Minimal Container Templates on Proxmox Server

Related Posts

  • SQL Server Management Studio 1
    How to manually check and update SQL Server Management Studio Oracle/MSSQL/MySQL
  • images 5 1
    How to access MySQL Server from command Prompt Oracle/MSSQL/MySQL
  • Screenshot 2020 06 22 at 23.27.40 1
    Install MSSQL 2019 Developer Edition and SSMS on Windows Oracle/MSSQL/MySQL
  • image 19
    Download your MySQL database from Azure to a local PC with MySQL Workbench AWS/Azure/OpenShift
  • Always on and Veeam plugin setup
    Install SQL Server Always On & Configure Veeam Plug‑in for SQL Backup
  • how to Install SQL Server Management Studio on Windows Server
    Install SQL Server Management Studio 20 on Windows Server Oracle/MSSQL/MySQL

More Related Articles

installer file too long fix Fix long path names to files on SQL Server installation media error Oracle/MSSQL/MySQL
Upgrade the embedded PostgreSQL for Veeam Backup and replication How to upgrade PostgreSQL Engine used by VBR Backup
Encryption How to encrypt Microsoft SQL Server Traffic Oracle/MSSQL/MySQL
Always on and Veeam plugin setup Install SQL Server Always On & Configure Veeam Plug‑in for SQL Backup
SQL Loves Linux 2 Twitter 002 640x358 1 Install Microsoft SQL Server 2019 and MSSQL Command line tools on Ubuntu Linux Oracle/MSSQL/MySQL
Screenshot 2020 06 22 at 23.27.40 How to fix unable to install msodbcsql17 tool on Ubuntu Oracle/MSSQL/MySQL

Leave a Reply Cancel reply

You must be logged in to post a comment.

Microsoft MVP

vexpert-badge-stars-5

Virtual Background

VEEAMLEGEND

Categories

Top 30 Sysadmin blog

veeaam100

Veeam Vanguard

  • veeam backup for aws Processing postgres rds failed
    Veeam backup for aws Processing postgres rds failed: No valid combination of the network settings was found for the worker configuration AWS/Azure/OpenShift
  • whois4578uh
    How to get Domain information using WHOIS Command in Linux Linux
  • Featured image 2
    5 Steps to Fix Outlook continually prompts for passwords Windows
  • BitLocker Recovery Password Rotation in Active Directory
    Perform BitLocker Recovery Password Rotation in Active Directory Windows Server
  • MDT Workbench Crashes when opening WinPE tab Properties
    Fix MDT Workbench Crashes when opening WinPE tab Properties Windows
  • mountedimagenotaccessible
    Unable to access the image: Make sure that the image path exist Windows
  • veeam vulnerability backups
    Fix critical Veeam Backup and Replication 9.5, 10, and 11 vulnerabilities Backup
  • microsoft logo rgb wht
    All about Group Policies: Group Policy GPUpdate Commands Windows Server

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 1,746 other subscribers
  • RSS - Posts
  • RSS - Comments
  • About
  • Authors
  • Write for us
  • Contact
  • Advertise with us
  • General Terms and Conditions
  • Privacy policy
  • Feedly
  • Telegram
  • Youtube
  • Facebook
  • Instagram
  • LinkedIn
  • Tumblr
  • Pinterest
  • Twitter
  • mastodon
  • Bsky

Tags

Active Directory Azure Bitlocker Microsoft Windows PowerShell WDS Windows 10 Windows 11 Windows Deployment Services Windows Server 2016

Copyright © 2026 TechDirectArchive

Loading Comments...

You must be logged in to post a comment.