2.4k questions

2.4k answers

95.6k users

13 Online Users
0 Member 13 Guest
Today Visits : 863
Yesterday Visits : 2184
Total Visits : 2346352

Categories

Notice

Dear All, These are my answers from Quora and primarily Google; please check the answer and from others sites; the answers are free and without any liability.To make a decision, write down all of the positives and negatives on a piece of paper.Thank you,

Elias Katsaniotis, MSc

Information

Viktoria Katsanioti,

Kaliningrad,

Russia,

matizegr@yahoo.com

0 votes
92 views
in General by (95.8k points)

1 Answer

0 votes

You can do this from 1) the command line, 2)for smaller from PHPMYadmin or 3) from Workbench, e.t.c.

How import MySQL database from the command line?

  1. Open the MySQL command line.
  2. Type the path of your MySQL bin directory and press Enter.
  3. Paste your SQL file inside the bin folder of the MySQL server.
  4. Create a database in MySQL.
  5. Use that particular database where you want to import the SQL file.
  6. Type source databasefilename.sql and Enter.
  7. Your SQL file upload successfully.

by (95.8k points)
...