This is really the most handy tool for mysql databases. A built in mysqldump can be used via shell to dump mysql databases within a few minutes. Sometimes dumping backups using phpmyadmin is too hazardous. So it’s really a necessary tool and fast too. I have listed this commands and i believe this should be useful to lots of system admins
Taking Database Backup
mysqldump -uuser -pmysqluserpassword database_name > database_name.sql
Restoring a Database
mysql -uuser -pmysqluserpassword database_name < database_name.sql
Here, you need to replace the user with the proper database user who has access to that specific database and the mysqluserpassword directs the password of that specific user. Here, one important thing is database_name.sql file can be replaced with the location of the sql file, suppose if you want to save it or retrieve from /home/backup then you can put /home/backup/database_name.sql to do that.
50 comments:
decided account you've hog
Keep working ,remarkable job!
Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I'll be subscribing to your feed and I hope you post again soon.
Great blog you have here. So many blogs like this cover subjects that can't be found in print. I don't know how we got on 12 years ago with just print media.
Cheers. I defo learned alot read your post. I'm gonna bookmark your blog and check back later
Took me time to read all the comments, but I actually enjoyed the post. It proved to be Very helpful to me and I'm sure to all the commenters right here It's always nice when you can not only be informed, but also entertained I'm positive you had fun writing this write-up.
That's pretty crazy, awesome although.
I'm still learning from you, as I'm trying to achieve my goals. I definitely enjoy reading all that is posted on your site.Keep the aarticles coming. I loved it!
Great site here. Lots of websites like this cover subjects that aren't found in magazines. I don't know how we got by 12 years ago with just newspapers and magazines.
I am always searching online for articles that can benefit me. Thanks!
I've been searching for a website just like this for a long time. Thank you for taking the time to produce this...never easy when you're busy.
Great site here. Lots of websites like this cover subjects that can't be found in magazines and newspapers. I don't know how we got on 12 years ago with just magazines and newspapers.
I've been searching for a website exactly like this for a long time. Thank you for taking the time to create and maintain this...never easy when you're busy.
thanks !! very useful submit!
You completed several nice points there. I did a search on the subject matter and found a good number of people will consent with your blog.
Many thanks for writing on this issue. Great article.
I'd like to see the commenters really add something to the discussion rather than just inane generic comments.
Some good stuff here. Some stuff I don't agree with, but still worth the read.
To the majority of us, alcohol has appear to necessarily mean a drink that we share having a few of friends or at a get together.
I really like looking through and I conceive this website got some genuinely useful stuff on it! .
Great blog. Lots of websites like this cover subjects that just aren't covered by magazines. I don't know how we got by 15 years ago with just print media.
Great blog. Lots of websites like yours cover subjects that can't be found in magazines and newspapers. I don't know how we got on 10 years ago with just magazines and newspapers.
ashukothari@gmail.com
Great blog. So many blogs like yours cover subjects that can't be found in print. I don't know how we got by 15 years ago with just magazines and newspapers.
Tea tree oil may be a hugely well-known organic treatment for acne with incredibly great purpose. Tea tree oil has solved the acne problems of hundreds that have problems with all forms of blemish problems.
very informative post. Looking more to something like this
I cherished up to you'll obtain performed proper here. The comic strip is tasteful, your authored material stylish. however, you command get bought an nervousness over that you want be turning in the following. in poor health no doubt come more until now again since precisely the same just about a lot often inside of case you shield this increase.
This website is very good. How did you make it .
I conceive other website owners should take this web site as an example , very clean and superb user friendly design .
I would like to begin writing articles and post them like you do, but i just can't determine which platform to use, between blogger and wordpress. Which 1 would u suggest for a newbie like me? By the way great articles you have!
I've been reading your weblog and to be frank, i like the content of it extremely much! I've also bookmarked it in my toolbar for easier access. :) informative weblog!
thank you very much for making this post honey it was a fun read
Easy yet the ideas are presented in a fantastic way. I just like the way on how you write this blog post!
As the saying goes, "sharing is caring". I actually like the way you write this article and thanks for sharing this piece of details! It saves my day in some ways :)
Regards for this post, I am a big fan of this site would like to go along updated.
Great blog, bookmarked the site in interest to see more information!
Not that back home owners' might make sure to gain individual, but they are bound to try to result in the optimum sales agreement that they'll make; truly quite an internet business. Certainly being aware what to get done by no means to undertake when wihtout a doubt with the juncture including mediation is essential.
A moment's insight is sometimes worth a life's experience. - Oliver Wendell-holmes
Good posting. Thanks for taking the time to jot down this information. I will check back often for further blog postings. Thanks :)
Not too house dwelling sellers should make an effort to leverage on you will, but they're definitely going to attempt to make the optimum business they will read; seriously is but an enterprise. Therefore understanding what attempt rather than you will need to formerly at the state related to relief is a must.
Lifting her or his head just isn't a bigger challenge than it's to maintain child in that consistent rest placement.
Hiya, is it possible this could away from subject matter matter still , in any case, i have been previously perusing across a web site and style essentially clearly assembled. I am developing a latest thoughts and as well as experiencing financial distress so it will be look good, each so i place nearly anything and also screw it up. The correct way very could be it again set up web site? Would a guy like me without the valuable experience do so, and as a consequence incorporate children enhance rankings need to have of destroying it every time?
Just desire to say your post is astounding. The clarity with your article is simply spectacular and that i can assume you happen to be an professional on this field. Effectively with your permission permit me to seize your rss feed to maintain as much as date with incoming put up. Thanks a million and please sustain the fabulous work.
I love your content, Most definitely i'll attempt to see your blog page monthly ;-). Thank you.
As a Newbie, I'm at all times searching on-line for articles that can help me. Thank you! I all the time needed to write down in my site one thing like that. Can I take part of your submit to my weblog?
I'm afraid, you cannot copy any material from the blog to your blog...
Howdy! You some type of knowledgeable? Nice message. Can you tell me find out how to subscribe your weblog?
That was an informative article. You made some great points and I appreciate for your information! Take care!
hey guys, i just found this here when i did an good google search. Fine blog you got here! Keep it up!
Mate, i am from Australia. You have been of great help with this topic. Thanks a lot.
Post a Comment