How To Import SQL File Into MySQL Using Command

Websolutionstuff | Nov-10-2022 | Categories : MySQL

In this article, we will see how to import SQL files into MySQL using the command. You can import databases in multiple ways on different types of servers. We will import the SQL file in xampp PHPMyAdmin using the command line. You can directly import the database in PHPMyAdmin. Using the command line you can import large-size databases.

So, let's see how to import the SQL files in PHPMyAdmin using the command line and command line to import the database in MySQL.

Syntax:

mysql -u username -p database_name < file.sql

 

  1. Open XAMPP.
  2. Start Apache Server and MySQL Database.
  3. Create a database via phpMyAdmin.
  4. Open Command Prompt
  5. Go to the SQL file path. Example: if your .sql file is located in the download folder then e.g Go to C:\Users\Websolutionstuff\Downloads.
  6. Type: mysql -u username -p database_name < file.sql
  7. The username refers to your MySQL username.
  8. database_name refers to the database you want to import.
  9. file.sql is your file name.
  10. If you've assigned a password, type it now and press Enter.

 

Example:

In this example, we will import backup_database_file.sql into the new_database_example database in PHPMyAdmin. 

mysql -u root -p new_database_example < backup_databse_file.sql

 

 

Export MySQL or MariaDB Database

In this example, we will export the mysqldump console utility exports databases to SQL text files. This makes it easier to transfer and move databases. You will need your database’s name and credentials for an account whose privileges allow at least full read-only access to the database.

Use mysqldump to export your database:

mysqldump -u username -p database_name > file.sql

 

  • The username refers to your MySQL database username.
  • The database_name refers to the database you want to export.
  • file.sql is your file name.

 

Example:

In this example, we will export tutorial_database with the backup_file.sql file.

mysqldump -u root -p tutorial_database > backup_file.sql

 


You might also like:

Recommended Post
Featured Post
How to Upload File on the FTP Server Using PHP
How to Upload File on the FTP...

In this small post i will show you how to upload file on the ftp server using php. As we know there are many ftp functio...

Read More

May-20-2021

Autocomplete Search using Bootstrap Typeahead JS
Autocomplete Search using Boot...

In this example we will see autocomplete search using bootstrap typeahead js.Typeahead search is a method for progr...

Read More

Jun-09-2021

How to Use Bitmasks for Efficient Data Filtering?
How to Use Bitmasks for Effici...

Data filtering might not sound like the most thrilling topic, but when it comes to processing large volumes of informati...

Read More

Oct-25-2023

How to Get Current URL in Laravel
How to Get Current URL in Lara...

In this article, we will see how to get the current URL in laravel. If you want to get the current page URL in...

Read More

Mar-10-2021