{"id":2913,"date":"2012-03-06T14:41:31","date_gmt":"2012-03-06T14:41:31","guid":{"rendered":"http:\/\/megahost.ro\/blog\/?p=2913"},"modified":"2018-09-06T08:43:54","modified_gmt":"2018-09-06T08:43:54","slug":"server-dedicat-comenzi-mysql-utile","status":"publish","type":"post","link":"https:\/\/megahost.ro\/blog\/server-dedicat-comenzi-mysql-utile.html","title":{"rendered":"Administrare server dedicat: comenzi mysql utile"},"content":{"rendered":"

Cei mai multi furnizori de hosting ofera o aplicatie de administrare a bazelor de date, cum ar fi phpMyAdmin<\/em>, ce ajuta la modificarea manuala a acestora. Tot ceea ce se poate face din acest tip de aplicatie se realizeaza printr-o comanda trimisa la un server MySQL si poate fi executata de asemenea dintr-o linie de comanda. Va oferim cateva comenzi utile pentru MySQL, in cazul in care sunteti administrator de server dedicat<\/a> si aveti evident access SSH:<\/p>\n

1) Comenzi din linia de comanda a serverului MySQL.<\/strong><\/p>\n

– Logare:<\/strong>\u00a0mysql -u $username -p<\/em><\/p>\n

– Salvati\/Exportati o baze de date:<\/strong> mysqldump -Q –add-drop-table $database > file.sql<\/em><\/p>\n

– Salvati baze de date multiple:<\/strong> mysqldump -Q –add-drop-table –databases $database1 $database2 > file.sql<\/em><\/p>\n

– Importati o baza de date (salvata anterior):<\/strong> mysql -p -u $username $databasename < file.sql<\/em><\/p>\n

– Importati baze de date multiple (salvate anterior):<\/strong> mysql -p u $username < file.sql<\/em><\/p>\n

2) Comenzi din linia de comanda MySQL (dupa ce v-ati logat si ati ajuns la un prompt MySQL).<\/strong><\/p>\n

*Va rugam sa introduceti comanda impreuna cu punct si virgula la sfarsitul fiecarui rand in scopul de a semnala sfarsitul unei comenzi.<\/p>\n

– Afiseaza o lista de baze de date:<\/strong> show databases;<\/em><\/p>\n

– Stergerea unei baze de date:<\/strong> drop database $database;<\/em><\/p>\n

– Crearea unei baze de date:<\/strong> create database $database;<\/em><\/p>\n

– Selecta\u0163i o baza de date cu care sa lucrati:<\/strong> use $database;<\/em><\/p>\n

– Stergerea unui tabel specific dintr-o baza de date (dupa selectarea bazei de date):<\/strong> drop table $tablename;<\/em><\/p>\n

3) Comenzi administrative:<\/strong><\/p>\n

– Arata toate procesele MySQL:<\/strong> show full processlist;<\/em><\/p>\n

– <\/em>Urmarirea proceselor mysql in timp real: <\/em><\/strong>watch mysqladmin pr (default refreshul este la 2 secunde insa il puteti defini cu –interval=t – exemplu: “‘watch –interval=1 mysqladmin pr”<\/em><\/p>\n

– Termina un proces (este nevoie de introducerea comenzii anterioare pentru a obtine PID):<\/strong> kill $pid;<\/em><\/p>\n

– Acorda privilegii de superutilizator unui utilizator:<\/strong> GRANT ALL PRIVILEGES ON *.* TO user_name@localhost;<\/em><\/p>\n

– Acorda privilegii de superutilizator unui utilizator doar pentru baza de date a acestuia:<\/strong> GRANT USAGE ON *.* TO ‘user’@’host’ GRANT Select, Insert, Update, Delete, Create<\/em><\/p>\n

– Privilegiile intra in vigoare fara a fi nevoie de restart:<\/strong> FLUSH PRIVILEGES;<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

Cei mai multi furnizori de hosting ofera o aplicatie de administrare a bazelor de date, cum ar fi phpMyAdmin, ce ajuta la modificarea manuala a acestora. Tot ceea ce se poate face din acest tip de aplicatie se realizeaza printr-o comanda trimisa la un server MySQL si poate fi executata de asemenea dintr-o linie de comanda. Va oferim cateva comenzi utile pentru MySQL, in cazul in care sunteti administrator de server dedicat si aveti evident access SSH:<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20,184],"tags":[685,118,170,690],"class_list":["post-2913","post","type-post","status-publish","format-standard","hentry","category-hosting","category-server-dedicat","tag-hosting","tag-mysql","tag-server","tag-server-dedicat"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"Administrare server dedicat: comenzi mysql utile | megahost.ro","description":"Cei mai multi furnizori de hosting ofera o aplicatie de administrare a bazelor de date, cum ar fi phpMyAdmin, ce ajuta la modificarea manuala a acestora. Tot ceea ce se poate face din acest tip de aplicatie se realizeaza printr-o comanda trimisa la un server MySQL si poate fi executata de asemenea dintr-o linie de comanda. Va oferim cateva comenzi utile pentru MySQL, in cazul in care sunteti administrator de server dedicat si aveti evident access SSH:","canonical_url":"https:\/\/megahost.ro\/blog\/server-dedicat-comenzi-mysql-utile.html","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null},"aioseo_meta_data":{"post_id":"2913","title":"Administrare server dedicat: comenzi mysql utile | megahost.ro","description":"Cei mai multi furnizori de hosting ofera o aplicatie de administrare a bazelor de date, cum ar fi phpMyAdmin, ce ajuta la modificarea manuala a acestora. Tot ceea ce se poate face din acest tip de aplicatie se realizeaza printr-o comanda trimisa la un server MySQL si poate fi executata de asemenea dintr-o linie de comanda. Va oferim cateva comenzi utile pentru MySQL, in cazul in care sunteti administrator de server dedicat si aveti evident access SSH:","keywords":[{"label":"server dedicat","value":"server dedicat"},{"label":"hosting","value":"hosting"},{"label":"mysql","value":"mysql"}],"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"location":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2020-12-20 22:49:34","updated":"2025-06-04 01:39:55","seo_analyzer_scan_date":null,"focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"aioseo_breadcrumb":"

\n\t\t\tHome<\/a>\n\t\t<\/span>\u00bb<\/span>\n\t\t\tHosting<\/a>\n\t\t<\/span>\u00bb<\/span>\n\t\t\tAdministrare server dedicat: comenzi mysql utile\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/megahost.ro\/blog\/"},{"label":"Hosting","link":"https:\/\/megahost.ro\/blog\/category\/hosting"},{"label":"Administrare server dedicat: comenzi mysql utile","link":"https:\/\/megahost.ro\/blog\/server-dedicat-comenzi-mysql-utile.html"}],"_links":{"self":[{"href":"https:\/\/megahost.ro\/blog\/wp-json\/wp\/v2\/posts\/2913","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/megahost.ro\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/megahost.ro\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/megahost.ro\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/megahost.ro\/blog\/wp-json\/wp\/v2\/comments?post=2913"}],"version-history":[{"count":0,"href":"https:\/\/megahost.ro\/blog\/wp-json\/wp\/v2\/posts\/2913\/revisions"}],"wp:attachment":[{"href":"https:\/\/megahost.ro\/blog\/wp-json\/wp\/v2\/media?parent=2913"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/megahost.ro\/blog\/wp-json\/wp\/v2\/categories?post=2913"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/megahost.ro\/blog\/wp-json\/wp\/v2\/tags?post=2913"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}