Insert .sql file into your MySQL database

Question

I have installed XAMPP. In this I made a database via PhpMyadmin.

How can I upload a SQL file to the database?

You could have found your answer in Google faster then typing your question here — John Conde, Dec 19 '12 at 15:49

Basith · Answer 1 · 2012-12-19T16:05:37.950

10

Follow the setps to upload your sql file to database.

Run this link from your browser http://localhost/phpmyadmin.
Select Database which you want to upload the SQL file. (If no DB , create new database).
Click on Import option from top menu section and upload you files.

Please check the screenshots for your reference.

enter image description here Try It... This will helps you....

edited Dec 19 '12 at 16:05

answered Dec 19 '12 at 15:54

Basith

score 6 · Answer 2 · edited Sep 23 '15 at 10:54

6

In your mysql console you have to type this command :

mysql> use YourDataBaseName
mysql> source YourFile.sql

or in your console type :

mysql -u root -p [YourPassword] [YourDataBaseName < YourFile.sql

edited Sep 23 '15 at 10:54

Willl

answered Dec 19 '12 at 15:54

Benabra

score 1 · Answer 3 · answered Dec 19 '12 at 15:47

1

In phpmyadmin choose import in the top menu and open your sql file from that page

answered Dec 19 '12 at 15:47

AgeDeO

score 0 · Answer 4 · answered Dec 19 '12 at 15:46

0

answered Dec 19 '12 at 15:46

John Conde

4 Answers4