Import single databases mysql file from command line

Question

I am using XAMPP, but I needed a new PHP version, so I had to install the new XAMPP available. As I got many websites, it is very hard to export every single database and then to import it. That's why I have exported all databases in one single SQL file, which is big around 8 GB.

My question is how to import that big file from the command line, when it includes all my databases ?

Thanks in advance !

try: mysql -h localhost -u username -p < filename.sql

Rajesh Karunakaran
– Rajesh Karunakaran

2017-04-25 09:19:52 +00:00
Commented Apr 25, 2017 at 9:19 — Rajesh Karunakaran
– Rajesh Karunakaran, Commented Apr 25, 2017 at 9:19

Honzy · Accepted Answer · 2017-04-25 09:19:39Z

1

C:\xampp\mysql\bin\mysql -u {username} -p {databasename} < file_name.sql

answered Apr 25, 2017 at 9:19

Honzy

881 silver badge3 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Import single databases mysql file from command line

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related