Mysql : Acesso com o Mysql Workbench

Caso não possua este programa para o acesso ao MySQL, você poderá fazer o download do mesmo no site oficial

Para o acesso a base de dados, abra o programa e em SQL Development clique em New Connection .

Mysql : Acesso com o Mysql Workbench

Na tela seguinte, preencha com os dados de sua base, caso não os tenha, poderá obter em seu painel de controle como informado neste artigo .

Os Campos a serem preenchidos são :

Connnection Name : inclua o nome de sua base de dados
Connection Method :Standard (TCP/IP)
Hostname : Servidor, ou o ip do servidor de sua base de dados
Port :3306
Username :Usuário
Default Schema :o mesmo nome de sua base de dados

Mysql : Acesso com o Mysql Workbench

Clique em ok , e será solicitada a senha de acesso. Caso deseje salvar a senha de acesso basta marcar a opção Store in Vault .

Veja também


Por questões de performance e até mesmo por limitações do próprio phpMyAdmin, recomendamos que efetue essa operação via phpMyAdmin somente se sua base tenha um tamanho inferior a 2MB. Para exportação de arquivos maiores, consulte Como efetuar um Backup do banco MySQL via SSH (somente para clientes com hospedagem Linux).

Siga as instruções abaixo:

Mysql : Acesso com o Mysql Workbench Acesse a Administração do phpMyAdmin, e clique sobre nome da base, localizado no menu à esquerda.

Mysql : Acesso com o Mysql Workbench

Mysql : Acesso com o Mysql Workbench Clique na aba Exportar.

Mysql : Acesso com o Mysql Workbench

Mysql : Acesso com o Mysql Workbench Selecione todas as tabelas de sua base de dados (por padrão, todas já vem selecionadas).

Mysql : Acesso com o Mysql Workbench Em Dados, marque a opção Inserções completas.

Mysql : Acesso com o Mysql Workbench

Mysql : Acesso com o Mysql Workbench Defina o nome do arquivo de Backup.

Mysql : Acesso com o Mysql Workbench Escolha o tipo de compactação.

Mysql : Acesso com o Mysql Workbench Clique sobre o botão Executar.

Mysql : Acesso com o Mysql Workbench

Mysql : Acesso com o Mysql Workbench Será mostrado a janela de Download para você.

Mysql : Acesso com o Mysql Workbench Salve o backup em um local seguro.

Mysql : Acesso com o Mysql Workbench

Mysql : Acesso com o Mysql Workbench Obs.: Na impossibilidade de fazer a exportação dos dados pelo phpMyAdmin ou pelo SSH, sugerimos que crie um chamado no HelpDesk solicitando o dump da base de dados, inserindo o login e a senha dela no campo Dados Sigilosos do chamado.

Veja também


Esse artigo ajudou você?

47 respostas para “Mysql : Acesso com o Mysql Workbench”

  1. Cannabis Seed Mixpacks Delivery

    I’m impressed, I have to admit. Rarely do I encounter a blog that’s both equally educative and engaging, and let me tell you, you have hit the nail on the head. The issue is something too few people are speaking intelligently about. Now i’m very happy that I found this during my hunt for something relating to this.

    Responder
  2. directory best news viral

    What i don’t realize is in truth how you’re not actually much more smartly-favored than you might be now. You’re so intelligent. You realize thus significantly in relation to this matter, produced me personally believe it from numerous numerous angles. Its like women and men aren’t interested until it’s one thing to accomplish with Lady gaga! Your own stuffs great. Always handle it up!

    Responder
  3. University Furnishings Logistics

    We are a group of volunteers and starting a new scheme in our community. Your website offered us with valuable information to work on. You’ve done an impressive job and our entire community will be grateful to you.

    Responder
  4. Issac Lukesh

    Having read this I believed it was really enlightening. I appreciate you finding the time and energy to put situs bandar casino online paling dipercaya this short article together. I once again find myself personally spending a lot of time both reading and commenting

    Responder
  5. free horror

    Hi there, I think your blog may be having web browser compatibility problems. Whenever I take a look at your site in Safari, it looks fine however, when opening in IE, it has some overlapping issues. I merely wanted to give you a quick heads up! Other than that, great site.

    Responder
  6. dig this legal news central

    Hello there, I found your website via Google while looking for a related topic, your web site came up, it looks good. I have bookmarked it in my google bookmarks.

    Responder
  7. Tim Jones

    Awesome article! I’ll be back to see your next article! Thanks!

    Responder
  8. Anamaria Shupp

    It is challenging to discover knowledgeable people on this subject, but you sound like you know what you are talking about! Thanks

    Responder
  9. Leandro Lafromboise

    I’m typically in order to running a blog and that i actually appreciate your articles. The write-up has actually highs my curiosity. I will save your own web site and maintain checking for brand spanking new data.

    Responder
  10. Charlotte exterminators

    If you are looking for the best extreminator company, look no more. These guys rock!

    Responder
  11. Pretty Gaming

    Wonderful post! We will be linking to this great post on our site. Keep up the great writing.

    Responder
  12. Isreal Roik

    The following time I read a blog, I hope that it doesnt disappoint me as a lot as this one. I mean, I do know it was my option to read, but I actually thought youd have something interesting to say. All I hear is a bunch of whining about something that you would fix should you werent too busy in search of attention.

    Responder
  13. Nilda Urman

    I am pleased that I detected this web blog, just the right information that I was searching for!|

    Responder
  14. Room of choice delivery

    you’re truly a just right webmaster. The web site loading speed is incredible. It seems that you’re doing any distinctive trick. Moreover, The contents are masterwork. you’ve performed a fantastic activity in this subject!

    Responder
  15. 슬롯

    Best view i have ever seen !

    Responder
  16. Goldendoodle Hip Dysplasia

    I’ve read a few good stuff here. Definitely value bookmarking for revisiting. I surprise how so much attempt you set to create such a wonderful informative website.

    Responder
  17. Saturnina Kommer

    This internet site is actually a walk-through its the info it suited you about this and didn’t know who must. Glimpse here, and you’ll absolutely discover it.

    Responder
  18. Marcellus Valentine

    This is a terrific web site, would you be interested in doing an interview about how you designed it? If so e-mail me!

    Responder
  19. DARTMOOR Ruedas de bicicleta de montaña en venta

    I am constantly searching online for ideas that can help me. Thanks!

    Responder
  20. OUTROAD OUTDOOR CAMPING GARDEN PATIO for sale

    I am curious to find out what blog system you’re working with? I’m experiencing some small security issues with my latest blog and I would like to find something more secure. Do you have any recommendations?

    Responder
  21. Oma

    Nice blog here! Also your web site a lot up very fast! I desire my site
    loaded up as quickly as yours…

    Responder
  22. can tax preparer get transcript

    I take pleasure in, cause I found just what I was having a look for. You’ve ended my four day long hunt! God Bless you man. Have a great day. Bye

    Responder
  23. Gout Locations In Foot

    I precisely had to appreciate you yet again. I’m not certain the things I would have achieved without the actual points revealed by you concerning such subject matter. Completely was a real horrifying issue in my position, however , looking at the very professional technique you managed it forced me to leap with joy. Now i am grateful for this advice and thus hope that you find out what an amazing job you’re putting in teaching men and women all through your web site. More than likely you haven’t encountered any of us.

    Responder
  24. look at more info

    I just want to say I am just beginner to blogs and actually liked you’re blog. More than likely I’m likely to bookmark your blog . You really come with incredible articles. Bless you for sharing your web page.

    Responder
  25. 안전토토

    Best view i have ever seen !

    Responder
  26. plumbing repair Check This Out

    Hello, i feel that i noticed you visited my blog so i came to “go back the prefer”.I’m attempting to in finding issues to improve my web site!I assume its adequate to use some of your ideas!!

    Responder
  27. Lucas

    Very good post! We will be linking to this great
    content oon our website.Keep up the great writing!

    Responder
  28. YesBet88

    Best view i have ever seen !

    Responder
  29. VitalFlow Benefits

    Having read this I believed it was rather informative. I appreciate you finding the time and energy to put this short article together. I once again find myself spending a significant amount of time both reading and posting comments. But so what, it was still worth it!

    Responder
  30. foundation repair dallas reviews

    F*ckin’ tremendous things here. I am very glad to see your post. Thanks a lot and i am looking forward to contact you. Will you please drop me a mail?

    Responder
  31. home warranty worth it

    I enjpy reading through your website. Thanks!

    Responder
  32. 마사지알바

    It’s a jealous article. It’s very amazing and brand-new. Who happen to be you to write this specific special article?

    Responder
  33. Playset assembly service

    I truly appreciate this post. I have been looking everywhere for this! Thank goodness I found it on Bing. You have made my day! Thanks again!

    Responder
  34. Emergency Plumber San Diego you can check here

    Nice post. I was checking continuously this blog and I am impressed! Extremely useful information specially the last part 🙂 I care for such info a lot. I was seeking this particular information for a very long time. Thank you and best of luck.

    Responder
  35. Bariatric Vitamins Calcium Citrate And D

    you’re really a good webmaster. The website loading speed is incredible. It seems that you are doing any unique trick. Furthermore, The contents are masterpiece. you have done a magnificent job on this topic!

    Responder
  36. porno

    Many thanks to you for sharing these wonderful articles. In addition, the right travel plus medical insurance approach can often eradicate those considerations that come with touring abroad. Some sort of medical emergency can before long become costly and that’s sure to quickly impose a financial stress on the family finances. Having in place the best travel insurance offer prior to setting off is worth the time and effort. Cheers

    Responder
  37. Pool table refelting

    naturally like your web-site however you have to take a look at the spelling on several of your posts. Many of them are rife with spelling problems and I in finding it very bothersome to tell the truth on the other hand I’ll definitely come back again.

    Responder
  38. diy bedroom improvements

    I have been absent for a while, but now I remember why I used to love this site. Thanks , I will try and check back more frequently. How frequently you update your website?

    Responder
  39. remodel pictures

    Hey there! I just wanted to ask if you ever have any trouble with hackers? My last blog (wordpress) was hacked and I ended up losing a few months of hard work due to no backup. Do you have any methods to protect against hackers?

    Responder
  40. o q marketing digital

    Wow! Thank you! I continuously needed to write on my site something like that. Can I include a part of your post to my website?

    Responder
  41. try this web-site

    I loved as much as you’ll receive carried out right here. The sketch is tasteful, your authored subject matter stylish. nonetheless, you command get bought an edginess over that you wish be delivering the following. unwell unquestionably come further formerly again as exactly the same nearly very often inside case you shield this hike.

    Responder
  42. alberta car towing

    I think other site proprietors should take this website as an model, very clean and fantastic user friendly style and design, let alone the content. You are an expert in this topic!

    Responder
  43. click here for more

    I just want to tell you that I’m beginner to weblog and absolutely loved your page. Probably I’m likely to bookmark your website . You absolutely have great stories. Thank you for sharing your web-site.

    Responder
  44. site here

    I genuinely enjoy looking at on this web site , it contains fantastic articles . “Dream no small dreams. They have no power to stir the souls of men.” by Victor Hugo.

    Responder
  45. Rosanne Rieve

    I just want to tell you that I am just beginner to weblog and definitely savored you’re web page. More than likely I’m likely to bookmark your site . You actually come with awesome stories. Regards for sharing your blog site.

    Responder

Comente sobre este conteúdo! Escreva o que pensa, complemente, vamos discutir. O conhecimento é livre!