How to import database into vagrant mysql?

Question

In window cmd ,I usually do like this and it is working

C:\Users\davi> mysql -u root -p mydb < D:/xampp/mysql/bin/db.sql

I am new in vagrant , this is what I do in vagrant ssh

[vagrant@localhost bs]$ mysql -u root -p mydb < D:/xampp/mysql/bin/db.sql

But I got this error

-bash: D:/xampp/mysql/bin/db.sql: ??????????????????????

Is there anyway to import correctly ?

Probably path is wrong. In Vargant files have different location. Read about `mount` etc.. https://www.vagrantup.com/docs/synced-folders/ — bato3, Jun 21 '17 at 10:28

score 18 · Accepted Answer · answered Jun 21 '17 at 12:30

18

You do not have D:/xampp/mysql/bin/db.sql from your vagrant VM

run the following command to import the db

$ mysql -u root -p mydb < /vagrant/db.sql

The /vagrant folder is a default shared folder in the VM.

answered Jun 21 '17 at 12:30

Frederic Henri

1

this helps me save a lot of time searching for the answer – Kim Tormes May 13 '21 at 08:01

score 0 · Answer 2 · answered Jan 11 '20 at 05:47

0

Copy DB.sql under your project folder in Windows

In Vagrant after mysqling into database, you can access your source /var/www/PROJECTNAME/DB.sql

answered Jan 11 '20 at 05:47

Smit Patadiya

2 Answers2