Trying to import a .sql file into MySQL on windows

[CaviB]

I have been at this for hours now, I am running xampp on my windows pc and want to import a data.sql file into my database

this is the command I have been using in the terminal
mysql -u username -ppassword < query_file.sql
mysql -u admin -pnotworking < fucking_file.sql

Thanks to anyone that can help

 

[jryan21]

try

-p=xxxx
or
--password=xxxx

if it's on your local box

or just -p
and then it should prompt for password

or go here and try using this:
http://www.heidisql.com/

 

[CaviB]

mysql -u admin -p=xxxxxxx somedb < C:\xampp\mysql\data\info_user.sql

This is what I am doing and it says file not found , thats the whole path up there and I am assuming this is done while not logged into the terminal, I have 4 books on php and mysql and none of them go over this shit,

 

[jryan21]

try using mysqlimport and even putting the datafile in the bin folder with the executables so you won't have to use path.

I've done this several times on different Windows machines and each time I ended up doing something completely different than before to get it to work.

 

[CaviB]

could you show me the exact syntax for that? I'm looking at the mysql site now and I can't find anything , Fuck me this is frustrating.

 

[jryan21]

mysqlimport is a different executable than mysql, it has its own commands that are not quite the same as mysql:

MySQL :: MySQL 5.0 Reference Manual :: 4.5.5 mysqlimport ? A Data Import Program

but you must have a separate datafile for each table, named the same as the table

 

[pstation]

use the mysql cli program

when you're logged in, just use "source blah.sql" and it'll run it.

 

[CaviB]

YEAH !!!! I finally figured it out I had to go into the directory where the file is located and then do the command below
mysql - u user -p path\filename.sql

I'm reading Head First PHP & MySQL , it's beyond me why they didn't tell you how to do this in the book. Plus the damm book is loaded with errors and typos so if something isn't working I always have to refer to the errata.
Thanks for the help guys.

 

[uplinked]

ditch the book of errors and just start reading the documentation. it'll be more confusing at first, but why would you want to learn it wrong the first time?

 

[CaviB]

True, I thought when spending $40 on a book I would get good quality