MySQL Command Lines

CREATE USER 'abc'@'localhost' IDENTIFIED BY '1abc';
GRANT ALL PRIVILEGES ON abc . * TO 'abc'@'localhost';
FLUSH PRIVILEGES;

To Run BackUp From Command Line
mysql -u root -p password abc_database > abc.sql

To Run Import From Command Line
mysql -u root -p password abc_database < abc.sql

MAC MySQL Location for XAMPP
/Applications/XAMPP/xamppfiles/bin/mysql xxxx

Comments

Post a Comment

Popular posts from this blog

Chat Tu Chak Market

Image
It was 9am in the morning when Cat decided i should get my lazy ass out of bed! lol oh wells .. i should well coz i wanna be early else its going to be hot hot hot coz the market is kinda cramp! From the picture above you can imagine a whole market the size of a 1/2 football field filled with rows of shop of this nature. plus there is poeple cooking in some of the inner stalls and hundreds and thousands of ppl ranging from locals to farang's to other local asians walking around with sweaty bodies! eeww! gosh we got out of the place after 2 hours and we barely covered 50% of the place. there is just so much to shop but mostly they are just fashion shops. yeahs i see people taking pictures in siam paragon so taht they can return home to make and sell at the local markets.. genius aye?
Read more

Tennis anyone

The rallies were short initially, almost always hitting the net. Spend most of the time picking up the balls. Spend even more time walking outside the court to pick up more balls. Surprisingly we came back with a couple of new ones. Perhaps this time around in my relationship I haven't been picking up the right vibes off her. Not giving her a chance to tell me whats wrong. Did I not provide not enough windows of opportunity? Late night chats didn't help? She said I slept too soon. Maybe I wasn't sensitive enough? Maybe I wasn't susceptible to changes without consultations? I didn't like to be put in a corner. I am easily swayed in decisions but only with the right nudge. To many factors and thoughts. Its putting a lot of unnecessary weight on my shoulders. Its over mutually but yet I am still giving it so much thought. If only I could rewind history and take back the words that started it all but that would mean today wouldn't come and I wouldn't have en...
Read more

Menstrual Cycles

When menstrual cramps occur, it is usually just before the cycle starts or with the onset of menstruation. They can last anywhere from a few hours to a few days. Menstrual cramps feel like muscle contractions or sharp spasms in the lower abdomen. They may radiate to the back or down the thighs, and range from mildly achy to wrenchingly painful. In the severely afflicted, cramping may be accompanied by nausea, vomiting, headache, nervousness, fatigue, diarrhea, fainting, bloating, breast tenderness, mood swings, backache, and/or dizziness. This was taken as an excerpt from Herbs2000 Perhaps I was going through it the last few days, actually it has almost been a week. But its confirmed, I felt it leaving my body this morning. It was shocking but it felt good.
Read more