{"id":385,"date":"2019-03-27T16:08:32","date_gmt":"2019-03-27T15:08:32","guid":{"rendered":"https:\/\/wiki.ad-libitum.info\/?page_id=385"},"modified":"2019-03-27T16:19:19","modified_gmt":"2019-03-27T15:19:19","slug":"import-in-sql","status":"publish","type":"page","link":"https:\/\/wiki.ad-libitum.info\/?page_id=385","title":{"rendered":"Import in SQL"},"content":{"rendered":"\n<pre class=\"wp-block-preformatted\"><code>sqlcmd -S SERVERNAME\\INSTANCE_NAME -i C:\\path\\mysqlfile.sql -o C:\\path\\output_file.txt<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">oder<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sqlcmd -S SERVERNAME -d MYDATABASE -U USERNAME -P PASSWORD -i C:\\path\\mysqlfile.sql -o C:\\path\\results.txt<\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>-S:<\/strong> is your servername or localhost<\/li><li><strong>-d:<\/strong> is the database you are targeting<\/li><li><strong>-U:<\/strong> is the username<\/li><li><strong>-P:<\/strong> is the password<\/li><li><strong>-i:<\/strong> is the path to your .sql file<\/li><li><strong>-o:<\/strong> is where the logs file will be saved so if you had problem during the importation you can debug them<\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>sqlcmd -S SERVERNAME\\INSTANCE_NAME -i C:\\path\\mysqlfile.sql -o C:\\path\\output_file.txt oder sqlcmd -S SERVERNAME -d MYDATABASE -U USERNAME -P PASSWORD -i C:\\path\\mysqlfile.sql -o C:\\path\\results.txt -S: is your servername or localhost -d: is the database you are targeting -U: is the username -P: is the password -i: is the path to your .sql file -o: is where the logs [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-385","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/wiki.ad-libitum.info\/index.php?rest_route=\/wp\/v2\/pages\/385","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wiki.ad-libitum.info\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/wiki.ad-libitum.info\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/wiki.ad-libitum.info\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/wiki.ad-libitum.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=385"}],"version-history":[{"count":0,"href":"https:\/\/wiki.ad-libitum.info\/index.php?rest_route=\/wp\/v2\/pages\/385\/revisions"}],"wp:attachment":[{"href":"https:\/\/wiki.ad-libitum.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=385"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}