How to import a MySQL Database via the command line

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.