Import .sql files help

[Anon]

I am trying to import my .sql’s file, some of the db files are about 50k records and about 60MB in size, and phpMyAdmin 2.2.2 cant handle them the browser just times out when importing the big ones, so I have been looking around here and tried some of the note like ie:

in the command prompt

c:\mysql>mysql -u myusername --password=mypassword < file.sql

c:\mysql>mysql db < filename

but they don’t work for me, I am new at this and I hope someone tell me in code detail on how to do it in.

Thank you!

[tasistro]

At the dos prompt

c:\mysql>mysql -u myusername --password=mypassword

After loggin in,
At the mysql prompt

mysql>source %your .sql file here%

Saludos
Gerardo

[Anon]

not working 🙁

when i type

C:\mysql>mysql -u myname --password=mypass
'mysql' is not recognized as an internal or external command, operable program or batch file.

but i have it running, i dont know i suck

[mithril]

What happens id you type "c:\mysql\bin>mysql -u username --password=password"? The mysql.exe binary hides in the x:\mysql\bin folder. Adding the path to the mysql bin directory to your %PATH% should solve your problem.

-geoff