MySQL waa Nidaamka Maareynta Xogta Xidhiidhka ah^{(Relational Database Management System)} ( RDBMS ). Waxay gacanta ku haysaa tilmaamaha xogta xogta waxayna maareyn kartaa kaydyo badan isku mar.

Tusaale ahaan, haddii aad rabto inaad abuurto kayd cusub^{(create a new database)} ama aad ku darto xogta kaydka jira, waxaad fariin u dirtaa server-ka MySQL , sii xogta aad rabto inaad ku darto, oo u sheeg meesha aad ku darto.

Haddii ganacsigaagu yar yahay ama ha weynaado, xogtaadu waa shay lagama maarmaan ah. Si loo hubiyo in macluumaadkaaga qiimaha leh uu ka badbaado burburka, xatooyada, ama saamaynta musiibada, kaydi xogta MySQL^{(backup your MySQL)} . Maqaalkani wuxuu sharxi doonaa dhowr siyaabood oo taas loo sameeyo.

Kayd MySQL Database Isticmaalka phpMyAdmin^{(Backup MySQL Database Using phpMyAdmin)}

Samee^(Create) faylka dhoofinta ama kaydinta xogta MySQL adiga oo gelaya phpMyAdmin aaladda kontoroolka martigelinta ee shabakadaada sida cPanel. Waxaan u isticmaali doonaa cPanel ujeeddooyinka maqaalkan.

• Ku bilow inaad gasho cPanel kaaga oo guji phpMyAdmin.

• Dooro xogta MySQL ee aad rabto inaad ka soo celiso guddida navigation ee dhinaca bidix. Kadib guji xiriirka dhoofinta ee ku yaal bar navigation sare.

• Laga soo bilaabo bogga Dhoofinta^(Export) , waxaad arki doontaa laba ikhtiyaar: Custom iyo Quick . Dooro ikhtiyaarka gaarka^(Custom) ah.

• Ka dib markaad doorato Custom , waxaad arki doontaa liiska macluumaadkaaga macluumaadka. Waxaad dooran kartaa mid, qaar, ama dhammaan. Dejinta caadiga ah waa in dhammaan kaydinta.
• Hoosta ikhtiyaarka wax soo saarka, dooro gzipped si aad u cadaadiso^{(Compression)} . U daa ikhtiyaarada kale inay yihiin kuwa khaladka galay.

• Guji badhanka Go si aad u bilowdo kaydka oo aad u soo dejiso faylkaaga. Magaca faylkaagu wuxuu noqon doonaa faylkaagaDatabaseName.sql.gz^{(YourDatabaseName.sql.gz file)} .

Wakhtiga ay qaadanayso in kaydinta la dhamaystiro waxay ku xidhan tahay xajmiga xogtaada.

Kaydka MySQL Database Iyadoo leh mysqldump^{(Backup MySQL Database With mysqldump)}

Isticmaal amarka mysqldump si aad u abuurto daadinta faylka qoraalka ee xogtaada oo ay maamuli doonto MySQL . Tuubitaanka faylka qoraalka waa faylal qoraal ah oo ay ku jiraan amarrada SQL ee aad u baahan tahay si aad xogtaada uga abuurto xoq.^(SQL)

• Si aad u kaydiso hal xog-ururin, adeegso amarka soo socda:

mysqldump database_name > database_name.sql

Amarkan ayaa abuuri doona kaydka oo u diri doona faylka .sql. Waxa kaliya oo ay samayn doontaa koobiga xogtaada mana saameyn doonto.

• Adeegso amarkan soo socda si aad u kaydiso xog ururin badan isku mar.

mysqldump –databases database_one database_two > two_databases.sql

Database_one waxa loola jeedaa magaca kaydka kowaad iyo database_two waa magaca kaydka labaad ee aad rabto inaad kaydiso. Labaduba waxa lagu kaydin doonaa hal kayd.

• Haddii aad rabto inaad kaydiso dhammaan macluumaadkaaga MySQL ee server-ka, adeegso amarkan soo socda si aad u abuurto hal fayl oo gurmad ah oo .sql ah kaas oo ka koobnaan doona dhammaan xogtaada.

mysqldump –all-databases > all_databases.sql

Kaydka MySQL Database Isticmaalka Cron Jobs^{(Backup MySQL Database Using Cron Jobs)}

Shaqada cron waa amar Linux ah oo loo isticmaalo in lagu fuliyo hawl waqti cayiman si toos ah. Waxaan sharxi doonaa sida loo isticmaalo amarkan si otomaatig loogu sameeyo kaydka xogta MySQL . 

• Ku bilow inaad gasho cPanel kaaga oo aad hoos ugu dhaadhacdo qaybta Sare^(Advanced) oo guji Shaqooyinka Cron^{(Cron jobs)} .

• Waxaad arki doontaa digniin ah inaad leedahay aqoon wanaagsan oo amarrada Linux ah si aad u isticmaasho shaqooyinka cron si wax ku ool ah. Haddii aadan, ka hubi maamulahaaga martigelinta.

• Haddii aad rabto inaad hesho iimayl mar kasta oo shaqo cron ah ay maamusho amar soo saara wax soo saar, geli ciwaanka emailkaaga sanduuqa oo guji Cusbooneysii Email^{(Update Email)} .

• Ka dooro mid ka mid ah Goobaha Guud^{(Common Settings)} ee liiska hoos u dhaca si aad u dooratid inta jeer ee aad rabto inaad socodsiiso kaydinta.

• Waxaad sidoo kale hagaajin kartaa goobaha kale sida wakhtiga iyo maalinta toddobaadka.

• Hadda waa waqtigii lagu dhejin lahaa amarka sida soo socota:

/usr/bin/mysqldump -u dbusername -p’dbpassword’ dbname > /home/username/path/backup.sql

• Ku beddel dbusername , dbpassword , iyo dbname magaca isticmaalaha xogtaada, erayga sirta ah, iyo magaca kaydka macluumaadka.
• Jidku^(Path) waxa ay tilmaamaysaa gal ama taxane faylal ah oo aad rabto in faylkaaga kaydinta ahi aado. Magaca faylkaaga kaydinta waxa uu u taagan yahay amarka sida backup.sql . Waad bedeli kartaa magacaas ama aad uga tagi kartaa sidiisa. Guji ^(Click) Kudar Shaqo Cusub Cron^{(Add New Cron Job)} .
• Haddii aad hoos u yara dhaadhacdo, waxaad arki doontaa liiska Shaqooyinka Cron-kaaga Hadda.^{(Current Cron Jobs.)}

• Haddii aad rabto inaad bedesho mid ka mid ah shaqooyinka cron-kaaga hadda, dhagsii Edit . Haddii aadan rabin inaad wax shaqo ah qabato ama aad qalad sameyso, guji Delete .

Isticmaal WordPress (WP) Plugins si aad u kabsato MySQL^{(Use WordPress (WP) Plugins to Backup MySQL)}

Haddii aad isticmaalayso WP, waxaad isticmaali kartaa plugin si aad u kaydiso xogtaada^{(use a plugin to back up your database)} . UpdraftPlus waxay ku kaydin doontaa faylkaaga xogta hal mar. Hadda waxa ay haysaa in ka badan laba milyan oo rakibo oo firfircoon.

BackWPup

Isticmaal BackWPup^{(Use BackWPup)} si aad u kaydiso faylashaada xogta MySQL iyo xitaa rakibaada WP oo dhamaystiran.

Waxaa jira plugins badan oo WP^{(WP plugins)} ah oo diyaar u ah in lagu taageero MySQL^(MySQL) . Dooro mid la shaqeeya nooca hadda ee WP oo si firfircoon loo cusboonaysiiyay.

Si looga fogaado luminta xogta muhiimka ah, si joogto ah u kaydi xogta MySQL . Haddii aad haysato kayd, waxaad awoodi doontaa inaad soo celiso xogta muhiimka ah ama aan la bedeli karin haddii ay wax dhacaan si ay u kharribaan goobtaada.

How To Backup a MySQL Database

MySQL is a Relational Database Management System (RDBMS). It handles database instructions and can manage many databases at the same time.

For example, if you want to create a new database or add data to an existing database, you send a message to the MySQL server, give it the data you want to add, and tell it where to add it.

Whether your business is small or large, your data is an essential element. To ensure that your valuable information is secure from damage, theft, or the effects of a disaster, backup your MySQL database. This article will explain several ways to do that.

Backup MySQL Database Using phpMyAdmin

Create an export or backup file of your MySQL database by accessing the phpMyAdmin tool from your web hosting control panel such as cPanel. We will use cPanel for the purposes of this article.

• Start by logging into your cPanel and clicking on phpMyAdmin.

• Choose the MySQL database you want to back up from the navigation panel on the left sidebar. Then click the export link located on the top navigation bar.

• From the Export page, you will see two options: Custom and Quick. Select the Custom option.

• After choosing Custom, you will see a list of your databases. You can select one, some, or all. The default setting is to backup all.
• Under the Output options, choose gzipped for Compression. Leave the other options as the defaults.

• Click the Go button to start the backup and download your file. The name of your file will be YourDatabaseName.sql.gz file.

The time it takes for the backup to complete will depend upon the size of your database.

Backup MySQL Database With mysqldump

Use the mysqldump command to create a text file dump of your database that will be managed by MySQL. A text file dump is a text file that includes the SQL commands you need to recreate your database from scratch.

• To back up a single database, use the following command:

mysqldump database_name > database_name.sql

This command will create the backup and send it to a .sql file. It will only make a copy of your database and won’t affect it.

• Use the following command to backup multiple databases at the same time.

mysqldump –databases database_one database_two > two_databases.sql

Database_one refers to the name of the first database and database_two is the name of the second database you want to back up. Both will be backed up into a single database.

• If you want to backup all your MySQL databases on a server, use the following command to create a single .sql backup file that will contain all your databases.

mysqldump –all-databases > all_databases.sql

Backup MySQL Database Using Cron Jobs

A cron job is a Linux command used to execute a task at a specified time automatically. We will explain how to use this command to automate a backup of MySQL databases. 

• Start by logging into your cPanel and scrolling down to the Advanced section and click on Cron jobs.

• You will see a warning that you should have a good knowledge of Linux commands to use cron jobs effectively. If you don’t, check with your hosting administrator.

• If you want to receive an email every time a cron job runs a command that produces output, put your email address in the box and click Update Email.

• Choose one of the Common Settings from the dropdown menu to select how often you want to run the backup.

• You can also tweak the other settings such as time and day of the week.

• Now it’s time to put in the command as follows:

/usr/bin/mysqldump -u dbusername -p’dbpassword’ dbname > /home/username/path/backup.sql

• Replace dbusername, dbpassword, and dbname with your database username, database password, and database name.
• Path refers to a folder or series of folders where you want your backup file to go. The name of your backup file is represented in the command as backup.sql. You can change that name or leave it as is. Click Add New Cron Job.
• If you scroll down a little bit, you will see a list of your Current Cron Jobs.

• If you want to change any of your current cron jobs, click Edit. If you no longer want to run any job or make a mistake, click Delete.

Use WordPress (WP) Plugins to Backup MySQL

If you are using WP, you can use a plugin to back up your database. UpdraftPlus will back up your database file with a single click. It currently has over two million active installs.

BackWPup

Use BackWPup to backup your MySQL database files and even your complete WP installation.

There are many more WP plugins available to back up MySQL. Choose one that works with the current version of WP and is being actively updated.

To avoid losing critical data, regularly backup your MySQL database. If you have a backup, you will be able to restore essential or irreplaceable data should something happen to corrupt your site.

Related posts

• Dib-u-eegis Buugaag - Hagaha sida-Geek-ga loo barto ee Windows 8

• Ku rakibida GIMP Plugins: Habka-Hagaha

• Sida loo soo dejiyo Google Chrome Offline (Standalone) Rakibaye

• Demi Koontaroolada Koontada Isticmaalaha (UAC) ee Codsi Gaar ah

• 8 ka mid ah Fikradaha Farsamada ugu Fiican ee lagula tacaali karo Go'doominta

• 6 Dejinta kamarada ugu Fiican ee Sawirada Dayaxa

• Sida Loo Abuuro Koox Ka Mid Ah Kooxaha Microsoft

• Sida loo sahlo Xaqiijinta Ilaalada Steam

• Sida loo beddelo midabka asalka ah ee Google Docs

• Sida Loo Dhiso Laabtoobkaaga

• Sida SSH ama SFTP loogu geliyo Raspberry Pi kaaga

• Sida loo furo Faylka JAR ee Daaqadaha

• Sida loo damiyo Furaha Daaqadaha

• Sida Loo Soo Celiyo Akoonka Facebook-ga La Jabsado

• Uninstall iyo reinstall IE gudaha Windows 7

• Sida Loo Ogaado Hadii Kombayutarkaga Lala Soconayo

• Sida loo beddelo faylasha IMG loona beddelo ISO

• Sida loo digitize DVD-yada

• Sida Bogag Badan Loogu Sawiro Hal Fayl oo PDF ah

• Sida Loo Ilaaliyo PC-gaaga Daaqadaha Adigoon taaban Jiirka