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:
  1. Menyelaraskan kandungan rekod di antara dua database yang berlainan lokasi.
  2. Perisian, sistem atau portal diserang oleh penjenayah.
  3. Komponen database seperti table serta rekod rosak (corup) akibat masalah teknikal.
  4. Kegagalan perkakasan server berfungsi dengan baik.
  5. Prosedur backup yang dijalankan oleh sesebuah Organisasi.
  6. 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


Related Posts by Categories



Widget by Hoctro | Jack Book

46 comments

  1. Anonymous  

    December 27, 2012 at 7:07 AM

    What a stuff of un-ambiguity and preserveness of precious know-how
    concerning unpredicted emotions.

    My site ... rechner private Krankenversicherung
    Visit my web page

  2. Anonymous  

    January 7, 2013 at 9:53 AM

    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

    Feel free to surf to my homepage: selbstständig kredit
    Feel free to visit my weblog ...

  3. Anonymous  

    February 7, 2013 at 8:33 AM

    Hey There. I found your blog the usage of msn. That is an extremely neatly written article.
    I 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

  4. Anonymous  

    February 9, 2013 at 3:31 PM

    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!
    My blog best web hosting uk

  5. Anonymous  

    February 11, 2013 at 3:15 AM

    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
    e-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

  6. Anonymous  

    February 15, 2013 at 8:25 PM

    Hi, i read your blog occasionally and i own a similar one and i was just curious if you
    get 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

  7. Anonymous  

    February 19, 2013 at 5:27 AM

    hello!,I like your writing so a lot! percentage we keep in touch more about
    your 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

  8. Anonymous  

    February 19, 2013 at 6:11 AM

    Hello, of course this piece of writing is in fact good and I have learned lot of things
    from it on the topic of blogging. thanks.

    Look at my web site ... kostenloser vergleich krankenversicherung

  9. Anonymous  

    February 19, 2013 at 4:40 PM

    I could not refrain from commenting. Very well written!


    my web-site - 500 euro kredit

  10. Anonymous  

    February 20, 2013 at 2:57 PM

    Hello, constantly i used to check blog posts here early in the daylight,
    since i enjoy to gain knowledge of more and more.

    Also visit my web page; beitragsbemessungsgrenze private krankenversicherung

  11. Anonymous  

    February 23, 2013 at 4:56 AM

    WOW just what I was looking for. Came here by searching for
    dallas seo expert

    My webpage: seo new york

  12. Anonymous  

    February 24, 2013 at 5:04 PM

    I drop a comment when I appreciate a post on a site or if
    I 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

  13. Anonymous  

    February 25, 2013 at 9:31 PM

    Howdy! This is my first visit to your blog! We are a team
    of 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

  14. Anonymous  

    February 25, 2013 at 10:51 PM

    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
    to contribute & help other users like its helped me. Great job.


    My website ... krankenversicherung studenten
    Also see my site - private krankenversicherung wechsel

  15. Anonymous  

    February 25, 2013 at 11:38 PM

    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!!

    Check out my web site :: private krankenversicherung 2008

  16. Anonymous  

    February 26, 2013 at 12:01 AM

    I do accept as true with all of the ideas you've introduced to your post. They're
    very 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

  17. Anonymous  

    February 26, 2013 at 1:55 PM

    Link exchange is nothing else except it is simply placing the
    other 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

  18. Anonymous  

    February 27, 2013 at 9:46 PM

    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
    bookmarking 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

  19. Anonymous  

    February 27, 2013 at 10:59 PM

    It's very effortless to find out any topic on web as compared to textbooks, as I found this post at this site.

    Here is my web site ... krankenversicherung privat gesetzlich

  20. Anonymous  

    February 28, 2013 at 6:35 AM

    Hi! This is kind of off topic but I need some guidance from an established blog.

    Is 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

  21. Anonymous  

    March 1, 2013 at 4:52 AM

    Very shortly this site will be famous amid all blogging and site-building viewers, due to it's nice articles

    Feel free to visit my web page - make money now
    my webpage :: affiliate sites

  22. Anonymous  

    March 1, 2013 at 10:08 AM

    We are a group of volunteers and opening a new scheme in our community.
    Your 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

  23. Anonymous  

    March 1, 2013 at 5:59 PM

    Nice answer back in return of this difficulty with firm arguments and explaining everything on the topic
    of that.

    Here is my site - online business ideas

  24. Anonymous  

    March 3, 2013 at 5:52 AM

    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.
    You 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

  25. Anonymous  

    March 3, 2013 at 9:21 AM

    Woah! I'm really loving the template/theme of this website. It's simple,
    yet 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

  26. Anonymous  

    March 5, 2013 at 3:00 AM

    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
    me. Nonetheless, I'm definitely happy I found it and I'll
    be book-marking and checking back often!

    My web blog affiliate internet marketing

  27. Anonymous  

    March 5, 2013 at 5:41 AM

    Right here is the perfect site for everyone who hopes to understand this topic.
    You 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

  28. Anonymous  

    March 6, 2013 at 1:21 AM

    Inspiring story there. What happened after? Thanks!



    Here is my page; find bad credit home loan

  29. Anonymous  

    March 6, 2013 at 7:30 AM

    Its like you learn my thoughts! You seem to grasp a lot approximately
    this, 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

  30. Anonymous  

    March 7, 2013 at 10:18 PM

    Do you mind if I quote a couple of your articles as long as I provide credit and sources back to
    your 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

  31. Anonymous  

    March 8, 2013 at 5:02 PM

    Hi there I am so happy I found your website, I really found
    you 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

  32. Anonymous  

    March 9, 2013 at 4:56 PM

    This site truly has all the info I wanted about this subject and didn't know who to ask.

    Look into my site: top all inclusive honeymoons

  33. Anonymous  

    March 15, 2013 at 5:52 PM

    I like what you guys are usually up too. This kind of clever work
    and reporting! Keep up the excellent works guys I've incorporated you guys to blogroll.

    Also visit my weblog: getting a mortage with bad credit

  34. Anonymous  

    March 18, 2013 at 4:46 AM

    Every weekend i used to go to see this web site, for the reason that i want enjoyment,
    since this this site conations actually nice funny data too.


    Here is my site - student loan refinance rates

  35. Anonymous  

    March 18, 2013 at 7:00 AM

    Great beat ! I wish to apprentice even as you amend your site, how could i
    subscribe 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

  36. Anonymous  

    March 18, 2013 at 10:53 PM

    Incredible points. Solid arguments. Keep
    up the amazing spirit.

    Feel free to surf to my web blog :: gesetzliche krankenversicherungen

  37. Anonymous  

    March 20, 2013 at 11:46 AM

    Yes! Finally someone writes about web hosting
    dedicated.

    Feel free to surf to my page beste web hosting

  38. Anonymous  

    April 1, 2013 at 4:35 PM

    Keep on writing, great job!

    Feel free to surf to my web site ... only online shop

  39. Anonymous  

    April 7, 2013 at 3:30 AM

    Nice blog here! Also your site loads up fast! What host are
    you 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

  40. Anonymous  

    April 7, 2013 at 4:57 AM

    Thanks for sharing your thoughts about outbound conference call.
    Regards

    My web site :: just click the up coming web site

  41. Anonymous  

    April 9, 2013 at 10:24 AM

    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.

    Also visit my blog post: ohne schufa auskunft

  42. Anonymous  

    April 20, 2013 at 8:19 AM

    Terrific work! This is the type of information that should
    be 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

  43. Anonymous  

    May 10, 2013 at 3:58 PM

    You really makе it appear so easу tοgethеr with yοur presentаtion but I find this
    mа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

  44. Anonymous  

    May 11, 2013 at 1:25 AM

    Hi, I do not have an understanding of that for those who
    own your own website in RSS reader. Are you able to assistance please:)

    Here is my page - how to start a reseller hosting business

  45. Josi Bunder  

    June 7, 2014 at 9:23 AM

    Best web hosting companies. Reviews, rates, statistics of top hosting companies.
    Find best hosting company at www.HostingCompaniesz.com

  46. Samsun Nahar  

    December 9, 2014 at 5:27 AM

    This is really an awesome article. Thank you for sharing this.It is worth reading for everyone. Very informative article. Keep it up.
    Reseller Hosting

Post a Comment

New Articles

Latest Comment

Tambah Duit Poket