How to Import SQL File Within WAMP Environment Using Command Line

This is something I've done already so many times, but just because I don't do it every month, I forget it all the time. So, I thought I would make a reminder note to myself and anyone else who has similar problem :)

The easiest way for me to import an sql file into a database in WAMP environment using command line is using follwoing:

1. Run the cmd (DOS) and get into the mysql folder, which in my case works like this

C:\>cd C:\wamp\bin\mysql\mysql5.0.51b\bin

2. Then use this command to fire up MySQL

C:\wamp\bin\mysql\mysql5.0.51b\bin>mysql.exe -use databasename -u username -p password_optional_if_you_have_one

This line basically connects you to the mysql database of your choice.
3. To make things easier, I copy my SQL file into the same folder where the mysql.exe file is located. And then run this

mysql> source myfilename.sql;

That's it folks!

What Men Really Think About Our Clothes? When it comes to fashion, most men could care less. Shopping? Same thing. Makeup? Not interested. But when it comes to how sexy a woman looks when she's all done up or just chilling in her sweatpants, men are all ears, or eyes we should say—they're visual creatures, what do you expect? They don't care about the hottest new fashion trends or how much a tank top opportunity cost (well, sort of), as long as it looks good on a woman and hugs her curves in all the right places, it's good enough for them. Common though, where's the fun in that? Men have to have a look they love on a gal, right? Here's what we concluded after careful consideration:
1. Men Love Women in a T-Shirt and Tight Jeans
Turns out the casual, au natural look isn't so bad after all. "It's sexy and shows off the curves, but still leaves things to the imagination," says Rafael, an LA based designer. Emma from UK would also have to agree, noting that her husband prefers her most when she's wearing boyfriend jeans, a t-shirt and no makeup.
2. Men Don't Love Women in Clothes That Look Like They Cost More than Their Car
What!? Guys don't love Chanel?!?! "Although it may look good," says Dan, a Manhattan based comedian, "it will make most heterosexual, down to earth men run the other way." Hmm, we guess high maintenance isn't really their thing?jeans for men
3. Different Is Good
"A different or unique outfit reflects a confident woman who is sure of herself," says Andrew Schrage, Editor of the Money Crashers personal finance blog. "Even if it's not the most physically attractive outfit, the thought behind it can be mentally stimulating," Awesome, we love this! Is this outfit too different?
4. Body-Con Dresses Are Great
No surprise here—guys love anything that's form fitting!
5. Yoga Pants Are Probably the Best
We kind of have to agree…they do make our tushes look good! "I don't know when they became an acceptable thing to wear out, but I'm just glad they did," says Mike of NC.
6. Oh, and High Heels Are Super Sexy as Well
This one goes without saying. Every guy loves a woman in high heels!

Post new comment

The content of this field is kept private and will not be shown publicly.
This question is for testing whether you are a human visitor and to prevent automated spam submissions.