{"id":785,"date":"2023-02-22T17:10:38","date_gmt":"2023-02-22T20:10:38","guid":{"rendered":"https:\/\/hostmundo.net\/tecnico\/?post_type=epkb_post_type_1&#038;p=785"},"modified":"2023-10-10T11:28:14","modified_gmt":"2023-10-10T14:28:14","slug":"deletar-e-recriar-bando-de-dados-local","status":"publish","type":"epkb_post_type_1","link":"https:\/\/hostmundo.net\/tecnico\/?epkb_post_type_1=deletar-e-recriar-bando-de-dados-local","title":{"rendered":"Deletar e Recriar Banco de Dados Local do Frente de Caixa e Outros Comandos \u00dateis"},"content":{"rendered":"\t\t<!-- Article Structure Version 2 Style -->\n\n\t\t<style>\t\t\t \/* DESKTOP *\/ \n#eckb-article-page-container-v2  {\n\t\t\t\twidth: 100% }#eckb-article-page-container-v2 #eckb-article-body {\n\t\t\t\twidth: 1140px }\n\t\t        \/* NO LEFT SIDEBAR *\/\n\t\t\t\t#eckb-article-page-container-v2 #eckb-article-body {\n\t\t\t\t      grid-template-columns:  0 80% 0%;\n\t\t\t\t}\n\t\t\t\t#eckb-article-page-container-v2 #eckb-article-left-sidebar {\n\t\t\t\t\t\tdisplay:none;\n\t\t\t\t}\n\t\t\t\t#eckb-article-page-container-v2 #eckb-article-content {\n\t\t\t\t\t\tgrid-column-start: 1;\n\t\t\t\t\t\tgrid-column-end: 3;\n\t\t\t\t\t}\n\t\t\t\t\n\t\t\t\t\/* NO RIGHT SIDEBAR *\/\n\t\t\t\t#eckb-article-page-container-v2 #eckb-article-body {\n\t\t\t\t      grid-template-columns: 0% 80% 0 ;\n\t\t\t\t}\n\t\t\t\t\n\t\t\t\t#eckb-article-page-container-v2 #eckb-article-right-sidebar {\n\t\t\t\t\t\tdisplay:none;\n\t\t\t\t}\n\t\t\t\t#eckb-article-page-container-v2 #eckb-article-content {\n\t\t\t\t\t\tgrid-column-start: 2;\n\t\t\t\t\t\tgrid-column-end: 4;\n\t\t\t\t\t}\n\t\t\t\t\n\t\t\t\t#eckb-article-page-container-v2 #eckb-article-body {\n\t\t\t\t      grid-template-columns: 0 80% 0;\n\t\t\t\t}\n\t\t\t\t#eckb-article-page-container-v2 #eckb-article-left-sidebar {\n\t\t\t\t\t\tdisplay:none;\n\t\t\t\t}\n\t\t\t\t#eckb-article-page-container-v2 #eckb-article-right-sidebar {\n\t\t\t\t\t\tdisplay:none;\n\t\t\t\t}\n\t\t\t\t#eckb-article-page-container-v2 #eckb-article-content {\n\t\t\t\t\t\tgrid-column-start: 1;\n\t\t\t\t\t\tgrid-column-end: 4;\n\t\t\t\t\t}\n\t\t\t\t \/* TABLET *\/ \n@media only screen and ( max-width: 1025px ) {#eckb-article-page-container-v2  {\n\t\t\t\twidth: 100% }#eckb-article-page-container-v2 #eckb-article-body {\n\t\t\t\twidth: 100% }\n\t\t        \/* NO LEFT SIDEBAR *\/\n\t\t\t\t#eckb-article-page-container-v2 #eckb-article-body {\n\t\t\t\t      grid-template-columns:  0 60% 0%;\n\t\t\t\t}\n\t\t\t\t#eckb-article-page-container-v2 #eckb-article-left-sidebar {\n\t\t\t\t\t\tdisplay:none;\n\t\t\t\t}\n\t\t\t\t#eckb-article-page-container-v2 #eckb-article-content {\n\t\t\t\t\t\tgrid-column-start: 1;\n\t\t\t\t\t\tgrid-column-end: 3;\n\t\t\t\t\t}\n\t\t\t\t\n\t\t\t\t\/* NO RIGHT SIDEBAR *\/\n\t\t\t\t#eckb-article-page-container-v2 #eckb-article-body {\n\t\t\t\t      grid-template-columns: 0% 60% 0 ;\n\t\t\t\t}\n\t\t\t\t\n\t\t\t\t#eckb-article-page-container-v2 #eckb-article-right-sidebar {\n\t\t\t\t\t\tdisplay:none;\n\t\t\t\t}\n\t\t\t\t#eckb-article-page-container-v2 #eckb-article-content {\n\t\t\t\t\t\tgrid-column-start: 2;\n\t\t\t\t\t\tgrid-column-end: 4;\n\t\t\t\t\t}\n\t\t\t\t\n\t\t\t\t#eckb-article-page-container-v2 #eckb-article-body {\n\t\t\t\t      grid-template-columns: 0 60% 0;\n\t\t\t\t}\n\t\t\t\t#eckb-article-page-container-v2 #eckb-article-left-sidebar {\n\t\t\t\t\t\tdisplay:none;\n\t\t\t\t}\n\t\t\t\t#eckb-article-page-container-v2 #eckb-article-right-sidebar {\n\t\t\t\t\t\tdisplay:none;\n\t\t\t\t}\n\t\t\t\t#eckb-article-page-container-v2 #eckb-article-content {\n\t\t\t\t\t\tgrid-column-start: 1;\n\t\t\t\t\t\tgrid-column-end: 4;\n\t\t\t\t\t}\n\t\t\t\t}\n\n\t\t\t\/* SHARED *\/\n\t\t\t#eckb-article-page-container-v2 #eckb-article-left-sidebar {\n\t\t\t\tpadding: 10px 10px 10px 10px; ;\n\t\t\t\tbackground-color: #FFFFFF;\t\t\t\tmargin-top: 0px;\t\t\t}\n\t\t\t\n\t\t\t#eckb-article-page-container-v2 #eckb-article-left-sidebar:before {\n\t\t\t\theight: 0px;\t\t\t}\n\t\t\t\n\t\t\t#eckb-article-page-container-v2 #eckb-article-content {\n\t\t\t\tpadding: 20px;;\n\t\t\t\tbackground-color: #FFFFFF;\t\t\t}\n\t\t\t#eckb-article-page-container-v2 #eckb-article-right-sidebar {\n\t\t\t\tpadding: 10px 10px 10px 10px;;\n\t\t\t\tbackground-color: #FFFFFF;\t\t\t\tmargin-top: 0px;\t\t\t}\n\t\t\t\n\t\t\t#eckb-article-page-container-v2 #eckb-article-right-sidebar:before {\n\t\t\t\theight: 0px;\t\t\t}\n\n\t\t\t\/* MOBILE - Set all columns to full width. *\/\n\t\t\t@media only screen and ( max-width: 768px ) {\n\n\t\t\t\t#eckb-article-page-container-v2 {\n\t\t\t\t\twidth:100%;\n\t\t\t\t}\n\t\t\t\t#eckb-article-page-container-v2 #eckb-article-content {\n\t\t\t\t\tgrid-column-start: 1;\n\t\t\t\t\tgrid-column-end: 4;\n\t\t\t\t}\n\t\t\t\t#eckb-article-page-container-v2 #eckb-article-left-sidebar {\n\t\t\t\t\tgrid-column-start: 1;\n\t\t\t\t\tgrid-column-end: 4;\n\t\t\t\t}\n\t\t\t\t#eckb-article-page-container-v2 #eckb-article-right-sidebar {\n\t\t\t\t\tgrid-column-start: 1;\n\t\t\t\t\tgrid-column-end: 4;\n\t\t\t\t}\n\t\t\t\t#eckb-article-page-container-v2 .eckb-article-toc {\n\t\t\t\t\tposition: relative;\n\t\t\t\t\tfloat: left;\n\t\t\t\t\twidth: 100%;\n\t\t\t\t\theight: auto;\n\t\t\t\t\ttop: 0;\n\t\t\t\t}\n\t\t\t\t#eckb-article-page-container-v2 #eckb-article-body {\n\t\t\t\t\tdisplay: flex;\n\t\t\t\t\tflex-direction: column;\n\t\t\t\t}\n\t\t\t\t#eckb-article-page-container-v2 #eckb-article-left-sidebar { order: 3; }\n\t\t\t\t#eckb-article-page-container-v2 #eckb-article-content { order: 2; }\n\t\t\t\t#eckb-article-page-container-v2 #eckb-article-right-sidebar { order: 1; }\n\t\t\t}\n\n\t\t<\/style>    \n\t\t<div id=\"eckb-article-page-container-v2\" class=\" eckb_ap_active_theme_twentynineteen \" >    <div id=\"eckb-article-header\">\n\t\t<script>\n\t\t\tvar ajaxurl = 'https:\/\/hostmundo.net\/tecnico\/wp-admin\/admin-ajax.php';\n\t\t<\/script>   \n\t\t<div class=\"epkb-doc-search-container \" style=\"background-color: #b1d5e1; padding-top: 40px; padding-right: 0px; padding-bottom: 40px; padding-left: 0px; margin-top: 0px; margin-bottom: 40px;\" >\n\n\t\t\t<div class=\"epkb-doc-search-container__title\" style=\"color: #FFFFFF; font-size:36px;;\"> Digite o que voc\u00ea procura<\/div>\n\t\t\t<form id=\"epkb_search_form\" style=\"width: 40%;\" class=\"epkb-search epkb-search-form-1\" method=\"get\" action=\"\">\n\n\t\t\t\t<div class=\"epkb-search-box\">\n\t\t\t\t\t<input type=\"text\" style=\"border-width: 1px; border-color: #CCCCCC; background-color: #FFFFFF; background: #FFFFFF;\" id=\"epkb_search_terms\" aria-label=\"Pesquisar a documenta\u00e7\u00e3o...\" name=\"epkb_search_terms\" value=\"\" placeholder=\"Pesquisar a documenta\u00e7\u00e3o...\" \/>\n\t\t\t\t\t<input type=\"hidden\" id=\"epkb_kb_id\" value=\"1\"\/>\n\t\t\t\t\t<div class=\"epkb-search-box_button-wrap\">\n\t\t\t\t\t\t<button type=\"submit\" id=\"epkb-search-kb\" style=\"background-color: #686868; background: #686868; border-width: 1px; border-color: #f1f1f1;\">Pesquisar <\/button>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t<div class=\"loading-spinner\"><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div id=\"epkb_search_results\"><\/div>\n\n\t\t\t<\/form>\n\n\t\t<\/div>  <\/div>\n\t\t   <div id=\"eckb-article-body\">  <div id=\"eckb-article-left-sidebar\"><\/div>\n\t\t       <article id=\"eckb-article-content\">                        <div id=\"eckb-article-content-header-v2\"><div id=\"eckb-article-content-header-row-1\"><div class=\"eckb-article-content-header-row-left-group\"><div id=\"eckb-article-back-navigation-container\"><div class=\"eckb-navigation-back  \" style=\"margin-top: 4px; margin-right: 15px; margin-bottom: 4px; margin-left: 4px;\"><div tabindex=\"0\" class=\"eckb-navigation-button\" style=\"padding-top: 5px; padding-right: 10px; padding-bottom: 5px; padding-left: 10px; color: #000000; background-color: #ffffff; font-size:14px;; border-radius: 3px; border-style: solid; border-width: 1px; border-color: #b5b5b5;\" onclick=\"history.go(-1);\" >&lt; Todos os T\u00f3picos<\/div><\/div><\/div><div id=\"eckb-article-content-breadcrumb-container\">\n<div class=\"eckb-breadcrumb\" style=\"padding-top: 0px; padding-right: 4px; padding-bottom: 0px; padding-left: 4px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font-size:14px;;\">\t\t<nav class=\"eckb-breadcrumb-outline\">\n\t\t<ul class=\"eckb-breadcrumb-nav\">       <li style=\"font-size:14px;;\">\t<span class=\"eckb-breadcrumb-link\"><a tabindex=\"0\" href=\"https:\/\/hostmundo.net\/tecnico\/\"><span style=\"color: #000000;\" >Principal<\/span><\/a><span class=\"eckb-breadcrumb-link-icon ep_font_icon_arrow_carrot_right\"><\/span>\t<\/span><\/li><li style=\"font-size:14px;;\">\t<span class=\"eckb-breadcrumb-link\"><a tabindex=\"0\" href=\"https:\/\/hostmundo.net\/tecnico\/?epkb_post_type_1_category=frente-de-caixa\"><span style=\"color: #000000;\" >Frente de Caixa<\/span><\/a><span class=\"eckb-breadcrumb-link-icon ep_font_icon_arrow_carrot_right\"><\/span>\t<\/span><\/li><li style=\"font-size:14px;;\">\t<span class=\"eckb-breadcrumb-link\"><span aria-current=\"page\"style=\"color: #000000;\" >Deletar e Recriar Banco de Dados Local do Frente de Caixa e Outros Comandos \u00dateis<\/span>\t<\/span><\/li>\t\t<\/ul>\n\t<\/nav>\n\n<\/div>          <\/div><\/div><div class=\"eckb-article-content-header-row-right-group\"><div id=\"eckb-article-content-toolbar-container\">\n\t\t<div class=\"eckb-article-content-toolbar-button-container\">\n\t\t\t<span class=\"eckb-print-button-container\">\t\t\t<span class=\"eckb-toolbar-button-text\">Imprimir<\/span><span class=\"eckb-toolbar-button-icon epkbfa epkbfa-print\"><\/span>\t\t\t<\/span>\n\t\t<\/div> <\/div><\/div><\/div><div id=\"eckb-article-content-header-row-2\"><div class=\"eckb-article-content-header-row-left-group\"><div id=\"eckb-article-content-title-container\"><h1 class=\"eckb-article-title kb-article-id\" id=\"785\">Deletar e Recriar Banco de Dados Local do Frente de Caixa e Outros Comandos \u00dateis<\/h1><\/div><\/div><\/div><div id=\"eckb-article-content-header-row-3\"><div class=\"eckb-article-content-header-row-left-group\">\n\t\t<div class=\"eckb-article-content-created-date-container\">\t\t<span class=\"eckb-meta-data-feature-icon epkbfa epkbfa-calendar\"><\/span><span class=\"eckb-meta-data-feature-text\">Criado em<\/span><span class=\"eckb-meta-data-feature-value\"><time class=\"entry-date\" datetime=\"2023-02-22T17:10:38-03:00\">22\/02\/2023<\/time><\/span>\t\t<\/div> \n\t\t<div class=\"eckb-article-content-last-updated-date-container\">\t\t<span class=\"eckb-meta-data-feature-icon epkbfa epkbfa-pencil-square-o\"><\/span><span class=\"eckb-meta-data-feature-text\">Updated<\/span><span class=\"eckb-meta-data-feature-value\"><time class=\"entry-date\" datetime=\"2023-10-10T11:28:14-03:00\">10\/10\/2023<\/time><\/span>\t\t<\/div> \n\t\t<div class=\"eckb-article-content-author-container\">\t\t<span class=\"eckb-meta-data-feature-icon epkbfa epkbfa-user\"><\/span><span class=\"eckb-meta-data-feature-text\">Por<\/span><span class=\"eckb-meta-data-feature-value\">Jo\u00e3o Batista<\/span>\t\t<\/div> <\/div><\/div><\/div><div id=\"eckb-article-content-body\">\n<p>Baixe o arquivo abaixo compactado abaixo e descompacte, \u00e9 um zip, dentro dele tem um bat, execute.<\/p>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-2861bfa6-8675-44c7-838e-d46ed0046545\" href=\"https:\/\/hostmundo.net\/tecnico\/wp-content\/uploads\/2023\/02\/RECRIAR_BD.zip\">Recriar Banco de Dados Local do Frente de Caixa<\/a><a href=\"https:\/\/hostmundo.net\/tecnico\/wp-content\/uploads\/2023\/02\/RECRIAR_BD.zip\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-2861bfa6-8675-44c7-838e-d46ed0046545\">Baixar<\/a><\/div>\n\n\n\n<p>Caso n\u00e3o consiga siga esses passos:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Digite no &#8220;Executar&#8221; o comando CMD para abrir o Prompt de Comando do Windows<\/li>\n\n\n\n<li>digite esses comandos:<br><strong>primeiro este:<\/strong><br>sqllocaldb delete<br><strong>e depois:<\/strong><br>sqllocaldb create<\/li>\n<\/ul>\n\n\n\n<p><strong>Comandos \u00dateis<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sqllocaldb info\nsqllocaldb stop\nsqllocaldb start<\/code><\/pre>\n<\/div><div id=\"eckb-article-content-footer\"><\/div>\n\t\t       <\/article><!-- \/#eckb-article-content -->     <div id=\"eckb-article-right-sidebar\"><\/div>\n\t\t   <\/div><!-- \/#eckb-article-body -->              <div id=\"eckb-article-footer\"><\/div>\n\t\t<\/div><!-- \/#eckb-article-page-container -->\n\t\t\n\t\t<style id=\"eckb-article-print-styles\">\n\t\t\t@media print {\n\t\t\t\t@page {\n\t\t\t\t\tmargin: 10px 10px 10px 10px!important;\n\t\t\t\t}\n\t\t\t}\n\t\t<\/style>\n\t\t<style id=\"eckb-article-styles\" type=\"text\/css\">@media only screen and (max-width: 768px ){\t\t\t\t\t        #eckb-article-content-header-row-1,\t\t\t\t\t        #eckb-article-content-header-row-2,\t\t\t\t\t        #eckb-article-content-header-row-3,\t\t\t\t\t        #eckb-article-content-header-row-4,\t\t\t\t\t        #eckb-article-content-header-row-5 {\t\t\t\t\t            flex-direction:column;\t\t\t\t\t        }\t\t\t\t\t\t}#eckb-article-content-header-row-1{\t\t\t\t\t        margin-bottom: 8px;\t\t\t\t\t      }\t\t\t\t\t\t\t\t\t      #eckb-article-content-header-row-1 .eckb-article-content-header-row-left-group, \t\t\t\t\t      #eckb-article-content-header-row-1 .eckb-article-content-header-row-right-group {\t\t\t\t\t        align-items: center; \t\t\t\t\t      }\t\t\t.eckb-article-content-toolbar-button-container {\t\t\t\t\tbackground-color: #ffffff;\t\t\t\t\tpadding: 10px  10px  10px  10px;\t\t\t\t\tmargin: 0px  0px  0px  0px;\t\t\t\t\tborder-radius: 0px;\t\t\t\t\tborder-width: 0px;\t\t\t\t\t\tborder-color: #ffffff;\t\t\t\t\t\tborder-style: solid;\t\t\t}\t\t\t.eckb-article-content-toolbar-button-container .eckb-toolbar-button-text{\t\t\t\t\tcolor: #000000;\t\t\t\t\tfont-size: 15px;\t\t\t\t}\t\t\t.eckb-article-content-toolbar-button-container .eckb-toolbar-button-icon{\t\t\t\t\tcolor: #000000;\t\t\t\t\tfont-size: 20px;\t\t\t\t}\t\t\t.eckb-article-content-toolbar-button-container:hover {\t\t\t\t\tbackground-color: #ffffff;\t\t\t}\t\t\t.eckb-article-content-toolbar-button-container:hover .eckb-toolbar-button-text{\t\t\t\t\tcolor: #000000;\t\t\t}\t\t\t.eckb-article-content-toolbar-button-container:hover .eckb-toolbar-button-icon{\t\t\t\t\tcolor: #000000;\t\t\t}#eckb-article-content-header-row-2{\t\t\t\t\t        margin-bottom: 0px;\t\t\t\t\t      }\t\t\t\t\t\t\t\t\t      #eckb-article-content-header-row-2 .eckb-article-content-header-row-left-group, \t\t\t\t\t      #eckb-article-content-header-row-2 .eckb-article-content-header-row-right-group {\t\t\t\t\t        align-items: flex-end; \t\t\t\t\t      }#eckb-article-body .eckb-article-title {\t\t\t\t\t\t\t\t\t\t\t\t}#eckb-article-content-header-row-3{\t\t\t\t\t        margin-bottom: 32px;\t\t\t\t\t      }\t\t\t\t\t\t\t\t\t      #eckb-article-content-header-row-3 .eckb-article-content-header-row-left-group, \t\t\t\t\t      #eckb-article-content-header-row-3 .eckb-article-content-header-row-right-group {\t\t\t\t\t        align-items: flex-end; \t\t\t\t\t      }<\/style>\t\t","protected":false},"excerpt":{"rendered":"<p>Digite o que voc\u00ea procura Pesquisar &lt; Todos os T\u00f3picos Principal Frente de Caixa Deletar e Recriar Banco de Dados Local do Frente de Caixa e Outros Comandos \u00dateis Imprimir Deletar e Recriar Banco de Dados Local do Frente de Caixa e Outros Comandos \u00dateis Criado em22\/02\/2023 Updated10\/10\/2023 PorJo\u00e3o Batista Baixe o arquivo abaixo compactado &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/hostmundo.net\/tecnico\/?epkb_post_type_1=deletar-e-recriar-bando-de-dados-local\" class=\"more-link\">Continue lendo<span class=\"screen-reader-text\"> &#8220;Deletar e Recriar Banco de Dados Local do Frente de Caixa e Outros Comandos \u00dateis&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"epkb_post_type_1_category":[5],"epkb_post_type_1_tag":[],"class_list":["post-785","epkb_post_type_1","type-epkb_post_type_1","status-publish","hentry","epkb_post_type_1_category-frente-de-caixa","entry"],"_links":{"self":[{"href":"https:\/\/hostmundo.net\/tecnico\/index.php?rest_route=\/wp\/v2\/epkb_post_type_1\/785","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hostmundo.net\/tecnico\/index.php?rest_route=\/wp\/v2\/epkb_post_type_1"}],"about":[{"href":"https:\/\/hostmundo.net\/tecnico\/index.php?rest_route=\/wp\/v2\/types\/epkb_post_type_1"}],"author":[{"embeddable":true,"href":"https:\/\/hostmundo.net\/tecnico\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hostmundo.net\/tecnico\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=785"}],"version-history":[{"count":8,"href":"https:\/\/hostmundo.net\/tecnico\/index.php?rest_route=\/wp\/v2\/epkb_post_type_1\/785\/revisions"}],"predecessor-version":[{"id":1005,"href":"https:\/\/hostmundo.net\/tecnico\/index.php?rest_route=\/wp\/v2\/epkb_post_type_1\/785\/revisions\/1005"}],"wp:attachment":[{"href":"https:\/\/hostmundo.net\/tecnico\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=785"}],"wp:term":[{"taxonomy":"epkb_post_type_1_category","embeddable":true,"href":"https:\/\/hostmundo.net\/tecnico\/index.php?rest_route=%2Fwp%2Fv2%2Fepkb_post_type_1_category&post=785"},{"taxonomy":"epkb_post_type_1_tag","embeddable":true,"href":"https:\/\/hostmundo.net\/tecnico\/index.php?rest_route=%2Fwp%2Fv2%2Fepkb_post_type_1_tag&post=785"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}