Defini backup secara umumnya adalah "menyalin maklumat atau data supaya salinan tersebut boleh digunakan semula jika terjadinya peristiwa kehilangan data". Salinan pendua maklumat tersebut biasanya disebut sebagai backup.
Proses backup adalah amat penting sekali terutamannya jika sesuatu perisian, sistem atau portal yang anda bangunkan menghadapi masalah yag berkaitan dengan perancangan, integriti rekod, keselamatan dan sebagainya. Di antara sebab-sebab khusus mengapa proses backup perlu dilakukan adalah seperti berikut:
- Menyelaraskan kandungan rekod di antara dua database yang berlainan lokasi.
- Perisian, sistem atau portal diserang oleh penjenayah.
- Komponen database seperti table serta rekod rosak (corup) akibat masalah teknikal.
- Kegagalan perkakasan server berfungsi dengan baik.
- Prosedur backup yang dijalankan oleh sesebuah Organisasi.
- Prosedur pemulihan bencana (disaster recovery) yang diselaraskan oleh Organisasi.
Ada banyak lagi sebab-sebab lain mengapa process backup perlu dilakukan dan jikalau anda mempunya pandangan atau idea yang pastinya bernas, silalah kemukakan pandangan anda melalui ruangan komen di bawah okay? :)
Bagaimanakah caranya untuk melakukan backup dengan Mysqldump?
Perlu diingatkan bahawa tips ini dikhususkan untuk pengguna Linux sahaja. Walau bagaimana pun, pengguna-pengguna Windows masih boleh menggunakan arahan-arahan yang dipaparkan dengan membuat sedikit sebanyak pengubahsuaian berdasarkan sistem pengoperasian tersebut.
Langkah Pertama : Login ke dalam sistem
Login ke dalam sistem operasi linux anda sebagai super user (root salah satunya) ataupun user yang telah didaftar khusus sebagai pentadbir database mysql anda. Sila rujuk ilustrasi atau pun movie di bawah:
Langkah Kedua : Pastikan shell yang betul
Pastikan default login anda menggunakan Bourne (Bash) unix/linux shell. Untuk memastikan shell yang sedang diguna, anda boleh gunakan arahan seperti di bawah. Oleh kerana arahan di bawah mempunyai perincian yang tersendiri, saya mengalukan anda semua untuk membaca maklumat selanjutnya di dalam posting akan datang yang bertajuk "Memastikan Jenis Shell Linux/Unix Pada Terminal Konsol".
$echo $SHELL
-atau-
$ps -p $$
Jika anda dapati shell yang dipaparkan selain daripada Bash maka seterusnya anda perlu taipkan arahan dibawah. Peringatan: Adalah tidak menjadi apa-apa kesalahan jika anda mengguna selain daripada GNU Bourne-Again SHell (Bash) akan tetapi Bourne shell sangat diperlukan untuk mengedit arahan pada konsol.
$bash
Langkah Ketiga: Larikan (run) arahan Mysqldump
mysqldump --host [nama host] --user [login anda] --password=[password anda] --datase [nama database] > [lokasi]/[nama database].sql
Contoh:
1. $mysqldump --host localhost --user root --password=root --database dblocal > /dblocal.sql
2. $mysqldump -h localhost -u root -p dblocal > dblocal.sql
3. $mysqldump --host localhost --user root --password=root --database dblocal > /dblocal_`date +%Y%m%d`.sql
Penjelasan contoh di atas:
Rujukan:
http://www.mysql.com
What a stuff of un-ambiguity and preserveness of precious know-how
ReplyDeleteconcerning unpredicted emotions.
My site ... rechner private Krankenversicherung
Visit my web page
I think this is among the most important info for me. And i'm glad reading your article. But wanna remark on few general things, The web site style is wonderful, the articles is really excellent : D. Good job, cheers
ReplyDeleteFeel free to surf to my homepage: selbstständig kredit
Feel free to visit my weblog ...
Hey There. I found your blog the usage of msn. That is an extremely neatly written article.
ReplyDeleteI will be sure to bookmark it and return to learn extra of your
helpful information. Thank you for the post. I'll definitely comeback.
Feel free to surf my website wechsel von privat in gesetzliche krankenkasse
Hello! I've been reading your website for a long time now and finally got the courage to go ahead and give you a shout out from Huffman Texas! Just wanted to mention keep up the excellent job!
ReplyDeleteMy blog best web hosting uk
When I originally commented I clicked the "Notify me when new comments are added" checkbox and now each time a comment is added I get three
ReplyDeletee-mails with the same comment. Is there any way you can remove me
from that service? Thanks!
My webpage - http://veteranwebmasters.Com/socialnetworking/profile/DomenicMu
Review my web page HTTP://www.mosc.my/sessions/taking-challenge-out-bankruptcy
Hi, i read your blog occasionally and i own a similar one and i was just curious if you
ReplyDeleteget a lot of spam remarks? If so how do you prevent it, any plugin or anything you
can recommend? I get so much lately it's driving me crazy so any help is very much appreciated.
Also visit my page: kredit ohne schufa auskunft sofort
hello!,I like your writing so a lot! percentage we keep in touch more about
ReplyDeleteyour post on AOL? I require an expert on this house to solve my
problem. May be that is you! Taking a look forward to see
you.
My website; mouse click the next site
Hello, of course this piece of writing is in fact good and I have learned lot of things
ReplyDeletefrom it on the topic of blogging. thanks.
Look at my web site ... kostenloser vergleich krankenversicherung
I could not refrain from commenting. Very well written!
ReplyDeletemy web-site - 500 euro kredit
Hello, constantly i used to check blog posts here early in the daylight,
ReplyDeletesince i enjoy to gain knowledge of more and more.
Also visit my web page; beitragsbemessungsgrenze private krankenversicherung
WOW just what I was looking for. Came here by searching for
ReplyDeletedallas seo expert
My webpage: seo new york
I drop a comment when I appreciate a post on a site or if
ReplyDeleteI have something to valuable to contribute to the discussion.
Usually it's a result of the fire communicated in the article I read. And after this post "Backup Database MySQL Menggunakan Mysqldump Dalam Server Linux". I was actually excited enough to create a thought ;) I actually do have a couple of questions for you if you don't mind.
Is it only me or do some of the remarks come across like left by
brain dead people? :-P And, if you are writing on additional online sites, I would like to keep up with you.
Could you make a list the complete urls of all your communal pages like your twitter feed, Facebook page or linkedin profile?
Stop by my web blog: own your own business ideas
my site :: small business to start
Howdy! This is my first visit to your blog! We are a team
ReplyDeleteof volunteers and starting a new project in a community in the same niche.
Your blog provided us valuable information to work on. You have done
a wonderful job!
my page; gehaltsgrenze private krankenversicherung 2011
What's Happening i'm new to this, I stumbled upon this I've found It positively helpful and it has helped me out loads. I'm hoping
ReplyDeleteto contribute & help other users like its helped me. Great job.
My website ... krankenversicherung studenten
Also see my site - private krankenversicherung wechsel
Good web site you have got here.. It's hard to find high-quality writing like yours these days. I honestly appreciate individuals like you! Take care!!
ReplyDeleteCheck out my web site :: private krankenversicherung 2008
I do accept as true with all of the ideas you've introduced to your post. They're
ReplyDeletevery convincing and can certainly work. Nonetheless, the posts are
too brief for newbies. May you please lengthen them a bit from subsequent time?
Thank you for the post.
My web page: private krankenversicherung für rentner
Also see my website - studenten pkv
Link exchange is nothing else except it is simply placing the
ReplyDeleteother person's website link on your page at proper place and other person will also do similar in favor of you.
My web-site click through the up coming web page
My website :: http://Drama-education.com/ausslers/blog/index.php?postid=328
It's a pity you don't have a donate button! I'd certainly donate to this excellent blog! I suppose for now i'll settle for
ReplyDeletebookmarking and adding your RSS feed to my Google account.
I look forward to brand new updates and will share this blog with
my Facebook group. Chat soon!
My weblog ... reseller windows hosting
It's very effortless to find out any topic on web as compared to textbooks, as I found this post at this site.
ReplyDeleteHere is my web site ... krankenversicherung privat gesetzlich
Hi! This is kind of off topic but I need some guidance from an established blog.
ReplyDeleteIs it very difficult to set up your own blog?
I'm not very techincal but I can figure things out pretty quick. I'm thinking about
making my own but I'm not sure where to start. Do you have any points or suggestions? Thanks
My blog post :: seo expert miami
My website: search engine optimization top
Very shortly this site will be famous amid all blogging and site-building viewers, due to it's nice articles
ReplyDeleteFeel free to visit my web page - make money now
my webpage :: affiliate sites
We are a group of volunteers and opening a new scheme in our community.
ReplyDeleteYour site provided us with valuable info to work on. You
have done a formidable job and our whole community will be thankful to you.
My web blog - wechsel in private krankenversicherung voraussetzungen 2012
Nice answer back in return of this difficulty with firm arguments and explaining everything on the topic
ReplyDeleteof that.
Here is my site - online business ideas
What i do not realize is actually how you're now not actually a lot more well-favored than you might be right now. You're very intelligent.
ReplyDeleteYou know thus considerably in relation to this topic, made me individually imagine it from numerous various angles.
Its like men and women aren't interested except it is something to do with Woman gaga! Your personal stuffs outstanding. All the time handle it up!
Feel free to surf to my webpage; can you refinance home with bad credit
Also see my webpage: home equity loan for bad credit
Woah! I'm really loving the template/theme of this website. It's simple,
ReplyDeleteyet effective. A lot of times it's difficult to get that "perfect balance" between superb usability and visual appearance. I must say that you've done a fantastic job with this.
In addition, the blog loads very fast for me on Internet explorer.
Exceptional Blog!
Take a look at my web blog :: hallesche krankenversicherung
Also see my page: Beitragsbemessungsgrenze krankenversicherung 2011
Hello there! I could have sworn I've been to this website before but after browsing through some of the post I realized it's new to
ReplyDeleteme. Nonetheless, I'm definitely happy I found it and I'll
be book-marking and checking back often!
My web blog affiliate internet marketing
Right here is the perfect site for everyone who hopes to understand this topic.
ReplyDeleteYou understand a whole lot its almost tough to argue with you (not that I really
would want to…HaHa). You certainly put a fresh spin on a topic that has been discussed for years.
Great stuff, just great!
my website search engine optimization seattle
My website - search engine optimization analysis
Inspiring story there. What happened after? Thanks!
ReplyDeleteHere is my page; find bad credit home loan
Its like you learn my thoughts! You seem to grasp a lot approximately
ReplyDeletethis, such as you wrote the guide in it or something.
I think that you can do with a few percent to power the message house a bit, however instead of that, that is wonderful blog.
A great read. I will definitely be back.
Here is my web-site; kredit mit negativ schufa
Do you mind if I quote a couple of your articles as long as I provide credit and sources back to
ReplyDeleteyour website? My blog is in the exact same area of interest as yours and
my users would really benefit from some
of the information you provide here. Please let me know if this okay with you.
Many thanks!
my blog post; reseller web hosting cheap
Hi there I am so happy I found your website, I really found
ReplyDeleteyou by error, while I was searching on Yahoo for something else, Anyways I
am here now and would just like to say thanks for a fantastic post and a all
round enjoyable blog (I also love the theme/design), I don’t have time to go
through it all at the moment but I have book-marked it and also included
your RSS feeds, so when I have time I will be back to read a great deal more, Please do keep up the great work.
My web-site: seo search engine ranking
My web site - Search Engine Optimization Course
This site truly has all the info I wanted about this subject and didn't know who to ask.
ReplyDeleteLook into my site: top all inclusive honeymoons
I like what you guys are usually up too. This kind of clever work
ReplyDeleteand reporting! Keep up the excellent works guys I've incorporated you guys to blogroll.
Also visit my weblog: getting a mortage with bad credit
Every weekend i used to go to see this web site, for the reason that i want enjoyment,
ReplyDeletesince this this site conations actually nice funny data too.
Here is my site - student loan refinance rates
Great beat ! I wish to apprentice even as you amend your site, how could i
ReplyDeletesubscribe for a weblog website? The account aided me a acceptable
deal. I were tiny bit familiar of this your broadcast offered vivid clear
concept
Stop by my webpage: beach vacation spots
Incredible points. Solid arguments. Keep
ReplyDeleteup the amazing spirit.
Feel free to surf to my web blog :: gesetzliche krankenversicherungen
Yes! Finally someone writes about web hosting
ReplyDeletededicated.
Feel free to surf to my page beste web hosting
Keep on writing, great job!
ReplyDeleteFeel free to surf to my web site ... only online shop
Nice blog here! Also your site loads up fast! What host are
ReplyDeleteyou using? Can I get your affiliate link to your host?
I wish my web site loaded up as quickly as yours lol
My weblog: work from home jobs legit
Thanks for sharing your thoughts about outbound conference call.
ReplyDeleteRegards
My web site :: just click the up coming web site
I'm gone to tell my little brother, that he should also visit this web site on regular basis to obtain updated from latest gossip.
ReplyDeleteAlso visit my blog post: ohne schufa auskunft
Terrific work! This is the type of information that should
ReplyDeletebe shared around the internet. Disgrace on Google for not positioning this put up
upper! Come on over and visit my web site . Thank you =)
Here is my web site: internet outlet store
You really makе it appear so easу tοgethеr with yοur presentаtion but I find this
ReplyDeletemаtter to be actually one thing that Ι feel I might neνer unԁerѕtаnd.
It sort of feels too сomplicateԁ аnd νery vаst for me.
I am having a looκ ahеaԁ tο your subsequent post,
I will attempt to get the dangle of it!
Lоok at my site: http://wiki.satanboard.de/index.php/Benutzer:OrlandoRa
Hi, I do not have an understanding of that for those who
ReplyDeleteown your own website in RSS reader. Are you able to assistance please:)
Here is my page - how to start a reseller hosting business
very good article judi poker
ReplyDeleteis very fond of this article because it gives a lot of inspiration thanks raja poker
ReplyDeleteAfter I read and try to understand this article and finally amazingwe are all grateful for the existence of this article can add even more insight for us all thank you
ReplyDeletebandar judi online indonesia
Good web site you have got here.. It's hard to find high-quality writing like yours these days. I honestly appreciate individuals like you! Take care!! ALSO, VISIT HERE
ReplyDeleteJudi Online Hbo365
ReplyDeletebagi bagi bonus yang besar tentu tidak membuat areaslot rugi karena semua itu untuk member setianya
ReplyDelete