CODEWITHSUNDEEP
command-linemysql
Richard Skinner
Richard Skinner

Reputation: 738

MySQL Import Database Schema

I'm having issues attempting to import a database of 195MB via the command line.

mysql -u root -p [DB_NAME] C:\Users\user_name\Downloads\file.sql

When I run this command all I receive from MySQL is a list of variables and options available.

What am I doing wrong?

Also like to add I'm using a fresh install of XAMPP.

Upvotes: 14

Views: 51490

Answers (1)

fancyPants
fancyPants

Reputation: 51908

You're missing a <, which means you want to direct the content of the file into mysql.

mysql -u root -p [DB_NAME] < C:\Users\user_name\Downloads\file.sql

Upvotes: 36

Related Questions