A cikin labari na gaba zamuyi duba MySQL Workbench. Wannan daya ne kayan aikin zane na gani bayanan bayanai wannan yana haɓaka ci gaban software, gudanar da bayanan bayanai, ƙirar bayanai, ƙirƙirawa da kulawa don tsarin MySQL.
Wannan shirin shine magajin Mai gabatarwa 4. mysql workbench Yana ɗaya daga cikin samfuran farko a cikin dangin MySQL don bayar da bugu biyu daban, tushen buɗewa da kuma tallan kasuwanci. Wannan software ɗin yana bawa mai amfani damar yin tallan bayanai, ci gaban SQL da ingantattun kayan aikin gudanarwa don daidaitawar sabar, gudanarwar mai amfani, abubuwan adanawa da ƙari. MySQL Workbench yana kan Windows, Gnu / Linux, da Mac OS X.
MySQL Workbench yana ba da izini zane na gani, samfura, samarwa da kuma sarrafa rumbunan adana bayanai. Ya haɗa da duk abin da mai tsara bayanai ke buƙata don ƙirƙirar samfuran ER mai rikitarwa, kai tsaye da kuma juya aikin injiniya, sannan kuma yana ba da mahimman fasalulluka don rubuce-rubuce masu wahala da sauya ayyukan gudanarwa waɗanda galibi ke buƙatar lokaci da ƙoƙari.
Manhajar zata samar mana da kayan aiki dan inganta ayyukan MySQL. Rahotannin aiwatarwa zasu samar mana da sauƙin ganewa da kuma isa ga wuraren samun IO, bayanan SQL da ƙari. Ari da, tare da dannawa ɗaya, masu haɓakawa na iya ganin inda za su haɓaka tambayoyin su.
Masu haɓaka bayanai da masu gudanarwa za su iya cikin sauri da sauƙi sauya aikace-aikacen data kasance don gudana akan MySQL duka akan Gnu / Linux da kan wasu dandamali. Shige da fice kuma yana tallafawa ƙaura daga tsofaffin sifofin MySQL zuwa sabbin sigar.
Duk wani mai amfani da shi zai iya yin shawarwari da shi manual by Tsakar Gida masu haɓakawa suna samarwa ga duk wanda yake buƙatarsa.
Janar ayyuka na MySQL Workbench
Aikace-aikacen zai ba mu duk abin da ake buƙata don ci gaban SQL. Duk wani mai amfani za'a bashi izinin ƙirƙira da sarrafa haɗin haɗi zuwa sabobin bayanai. Toari da ba ku damar saita sigogin haɗi, MySQL Workbench yana ba da ikon gudanar da tambayoyin SQL akan haɗin kan bayanai ta amfani da Editan SQL an haɗa shi.
MySQL Workbench yana tallafawa nau'ikan uwar garken MySQL na 5.5 kuma mafi girma. Hakanan ya dace da tsofaffin sifofin uwar garken MySQL 5.x, sai dai a wasu yanayi (kamar nuna jerin ayyukan) saboda sabin tsarin da aka gyara. Ba ya goyi bayan sigar uwar garken MySQL 4.x.
Wannan shirin zai bamu damar kirkirar tsarin tsari na tsari yadda yakamata. Hakanan zai ba mu damar juyawa da aika aikin injiniya tsakanin tsarin da kuma adana bayanan kai tsaye tare da ba mu damar shirya duk abubuwan da ke cikin bayanan ta amfani da Editan Tebur. Da Editan tebur samar da wurare don shirya tebur, ginshiƙai, fihirisa, abubuwan jawowa, rabewa, zaɓuɓɓuka, abubuwan sakawa, da sauransu.
Workbench zai taimaka mana tare da hijirar bayanai. Zai baiwa kowane mai amfani damar yin kaura daga MySQL zuwa Microsoft SQL Server, Microsoft Access, Sybase ASE, SQLite, SQL Anywhere, PostreSQL da sauran tebura, abubuwa da bayanai na RDBMS. Shige da fice kuma yana tallafawa ƙaura daga tsofaffin sifofin MySQL zuwa sabbin sigar.
Sanya MySQL Workbench 6.3.9 akan Ubuntu 16.04
Muna iya shigar da wannan shirin ta hanyoyi biyu. Na farko zai kasance ta hanyar saukar da .deb kunshin daga shafin yanar gizon su. To kawai zamu girka shi. Hanya ta biyu don girka wannan software zata kasance ta amfani da m da umarnin APT.
Kafin fara shigarwa daga tashar, ya zama dole mu sabunta wuraren ajiyar mu. Don wannan zamu bude tashar (Ctrl + Alt + T) kuma zamu rubuta mai zuwa a ciki:
sudo apt update && sudo apt upgrade
Yanzu zamu iya sanya MySQL Workbench ta amfani da APT. A cikin wannan tashar za mu rubuta:
sudo apt install mysql-workbench
Da zarar an gama shigarwa, zamu iya ƙaddamar da aikace-aikacen ko dai daga Dash ko kuma ta kiran shirin daga tashar:
mysql-workbench
Uninstall MySQL Workbench
Don cire shirin daga tsarin aikin mu daga na'ura mai kwakwalwa (Ctrl + Alt + T) kuma zamu rubuta masu zuwa:
sudo apt remove mysql-workbench && sudo apt autoremove
A yau akwai hanyoyi da yawa (kuma mai yiwuwa ya fi na zamani, kodayake ina shakkar cewa ya fi tasiri) don aiki tare da ɗakunan bayanai. Wannan shine farkon zaɓi da na fara wasa da shi. Abu ne mai sauƙi a yi amfani da shi, amma kamar yadda na ce, zaɓi ɗaya ne kawai na yawancin waɗanda ke wanzu. Kowane mutum na iya samun wanda ya fi dacewa da yadda yake aiki.