Execute MySql File ?

How can I execute MySql database file (.sql) from command prompt in windows ?

Plz help

 

mysql OPTIONS <c:\yourfile.sql
For OPTIONS you need to fill in your username, password and if needed the database to connect to.

Have fun.

 

Is it like this :

???

 

mysql -u root -p

in that format i suppose

 

Stupid me, I could have given you the manual page instead of typing it in myself
http://dev.mysql.com/doc/refman/5.0/en/batch-commands.html
The important part is the small then sign < This means that the file on the right should be used as input for the command on the left.

 

Just use phpmyadmin. Or open up the mysql command box.

 

He did specifically ask for windows command line so I targetted that part.
Maybe he wanted to automate / script something, then this is the easiest way, or he uses an IIS or Java stack instead of php so phpmyadmin is not even an option.

 

You are correct.

But what about using MySql GUI ?

 

I have not used Mysql GUI myself so I can't give advice about that. I hope somebody else has more experience with that.

Cheers,

 

but it's easier (and free also) if you used phpmyadmin more than use the command prompt

 

You suggesting that the free Mysql Client like the free Mysql server costs money, which is not the case the Mysql Client is free.
Easier for someone using a Java or ASP.Net webserver ? when phpmyadmin requires a php enviroment I think not.
Phpmyadmin easier to run into runtime limits (cpu time and ram) with phpmyadmin yep that's phpmyadmin
Phpmyadmin easier to waste time with problems doing large backup/restores yep that's phpmyadmin
Easier to forget that phpmyadmin is additional attack surface that needs to be protected, yep thats phpmyadmin

Easier for you not to read seokochin's question specifically asking for commandline advice yep.

 

my sites use accessy data
is it safe ?
thanks