{"id":1797,"date":"2011-06-19T14:44:08","date_gmt":"2011-06-19T12:44:08","guid":{"rendered":"http:\/\/www.beseit.net\/?p=1797"},"modified":"2011-10-25T09:22:59","modified_gmt":"2011-10-25T07:22:59","slug":"gestio-de-les-bd-mysql-del-servidor-remot-en-mysql-workbench","status":"publish","type":"post","link":"https:\/\/www.beseit.net\/?p=1797","title":{"rendered":"Gesti\u00f3 de les BD MySql del servidor remot en MySQL workbench"},"content":{"rendered":"<ul>\n<li><span style=\"color: #000000;\">\u00a0\u00a0\u00a0 <span style=\"font-family: Calibri;\">Configuraci\u00f3 de MySQL workbench:<\/span><\/span><span style=\"color: #000000;\"><span style=\"font-family: Calibri;\">Manage import\/export<\/span><\/span><\/li>\n<\/ul>\n<p>Name:beseit.net<br \/>\nHost: 79.170.44.151:3306<br \/>\nServer: MySQL Version: 5.1.56-community-log<br \/>\nUser: web151-beseit<br \/>\nPer con\u00e8ixer el host es \u00fatil fer un ping al domini (beseit.net)<\/p>\n<ul>\n<li>Manage import\/export<\/li>\n<\/ul>\n<p><a href=\"http:\/\/www.beseit.net\/wp-content\/uploads\/2011\/06\/Sin-t\u00edtulo-1.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-1798\" title=\"Sin-t\u00edtulo-1\" src=\"http:\/\/www.beseit.net\/wp-content\/uploads\/2011\/06\/Sin-t\u00edtulo-1-300x240.gif\" alt=\"\" width=\"300\" height=\"240\" \/><\/a><br \/>\n<span style=\"font-family: Calibri; color: #000000;\">\u00a0<\/span><span style=\"font-family: Calibri; color: #000000;\">\u00a0<\/span><span style=\"font-family: Calibri; color: #000000;\">\u00a0<a href=\"http:\/\/www.beseit.net\/wp-content\/uploads\/2011\/06\/Sin-t\u00edtulo-1.gif\"><\/a><\/span><span style=\"font-family: Calibri; color: #000000;\">\u00a0hi ha dos<\/span>\u00a0opcions per a fer la exportaci\u00f3:<\/p>\n<ul>\n<li><span style=\"color: #000000;\"><span style=\"font-family: Calibri;\">En taules individual<\/span><\/span><\/li>\n<li><span style=\"color: #000000;\"><span style=\"font-family: Calibri;\">Totes juntes en un paquet (agafem aquesta ultima)<\/span><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Calibri; color: #000000;\">Hi ha que tenir en compte que quan s\u2019importi a local, la taula conserva el\u00a0 nom del servidor: web151-beseit. Hi ha que canviar-l\u2019hi el nom normalment. \u00a0Aix\u00f2 es fa directament \u00a0des de c:\/appser\/MySql\/data .<\/span><\/p>\n<p><span style=\"font-family: Calibri; color: #000000;\">Ho he provat avui i funciona correctament<\/span><\/p>\n<p><span style=\"font-family: Calibri; color: #000000;\">Com es l\u00f2gic quan es puja una taula a local hi ha que tenir les precaucions descrites al post : <\/span><a href=\"http:\/\/www.beseit.net\/?p=142\"><span style=\"font-family: Calibri; color: #800080;\">http:\/\/www.beseit.net\/?p=142<\/span><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0\u00a0\u00a0 Configuraci\u00f3 de MySQL workbench:Manage import\/export Name:beseit.net Host: 79.170.44.151:3306 Server: MySQL Version: 5.1.56-community-log User: web151-beseit Per con\u00e8ixer el host es \u00fatil fer un ping al domini (beseit.net) Manage import\/export \u00a0\u00a0\u00a0\u00a0hi ha dos\u00a0opcions per a fer la exportaci\u00f3: En taules individual &hellip; <a href=\"https:\/\/www.beseit.net\/?p=1797\">Continua llegint <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,54],"tags":[],"class_list":["post-1797","post","type-post","status-publish","format-standard","hentry","category-bloc-de-notes","category-software-aplicacions"],"_links":{"self":[{"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/1797","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1797"}],"version-history":[{"count":9,"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/1797\/revisions"}],"predecessor-version":[{"id":2076,"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/1797\/revisions\/2076"}],"wp:attachment":[{"href":"https:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1797"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1797"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1797"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}