Welcome, Guest: Join Kenyans247 Log In!

Stats: 290 Members, 13,218 topics and 65 posts Date:  Wednesday 21 October 2020 at 04:11 PM
Popular & Trending NewestFeatured Links ClassifiedDirectoryLivescoresLive Kenyan TVLive Kenyan Radio Follow Us Like Us

About Us Terms & Conditions Privacy Policy FAQ's Disclaimer Copyright Contact Us Advertise With Us Download K247 APP Marketplace Moderator Policy We Are Hiring Kenya Radio and TV Stations Listen and Watch Live Letter From the C.E.O Kenya Radio Stations Live Kenya TV Stations Live Kenya - Newspapers and News Sites and popular blog Forum Rules

Backup MySQL Database to a file

Kenyans247 / Science/Technology / Programing / Backup MySQL Database to a file

71 people viewed

How To Use All Of Windows 10’s Backup And Recovery Tools Restore Mysql Database From A Backup File Restore Mysql Database From A Backup File Backup Mysql Database To A File
(Go Down) (» Reply topic)
Backup MySQL Database to a file by Kenyans247(1): Sun 22, March, 2020 08:19am
Backing up your database is a very important system administration task, and should generally be run from a cron job at scheduled intervals. We will use the mysqldump utility included with mysql to dump the contents of the database to a text file that can be easily re-imported.

Syntax:

mysqldump -h localhost -u root -pmypassword databasename > dumpfile.sql

Example:

mysqldump -h localhost -u root -p2Uad7as9 database01 > dumpfile.sql

This will give you a text file containing all the commands required to recreate the database.

0 Shares 0 Like •

(» Go Up)

You must Sign in or Sign Up to post content

For you to post content on this website you have to log in or register, it only take few minute to create account

Go Up

Recommended for you

Make A Backup Copy Of Your Production Wordpress Blog On Ubuntu How Do I Create Fast Backup Of Camera Photos To Cloud Storage Backup Mysql Database To A File Restore Mysql Database From A Backup File

Currently: 1 guest(s) reading this article

Sections: Religion, Culture, World List Directory, Family, Autos, Universities, Webmasters, Computers, Art, Graphics & Video, Innovation, Gossip, Emojipedia, Forum Games, Poetry, K247 TV, Tanzania Forum, Burundi Forum, Rwanda Forum, South Sudan Forum, Somalia Forum,

About Us | Terms & Conditions | Privacy Policy | FAQ's | Disclaimer | Copyright | Contact Us | Advertise With Us | Download K247 APP | Marketplace | Moderator Policy | We Are Hiring | Kenya Radio and TV Stations Listen and Watch Live | Letter From the C.E.O | Kenya Radio Stations Live | Kenya TV Stations Live | Kenya - Newspapers and News Sites and popular blog | Forum Rules | Featured LinksFollow Us on TwitterLike Us on Facebook

Kenyans247 - Copyright © 2019 - 2020 Sande Kennedy. All rights reserved. See How To Advertise.
Disclaimer: Every Kenyans247 member is solely responsible for anything that he/she posts or uploads on Kenyans247.