CODEWITHSUNDEEP
mysqldatabaseimport
Vince Carter
Vince Carter

Reputation: 946

Import single databases mysql file from command line

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 !

Upvotes: 0

Views: 44

Answers (1)

Honzy
Honzy

Reputation: 88

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

Upvotes: 1

Related Questions