Kenyans247 Forum

Welcome, Guest: Join Kenyans247 LOGIN!

Stats: 226 Members, 11,371 topics and 65 posts Date: Tuesday 07 April 2020 at 07:45 PM
TrendingRecentNewestClassifiedDirectoryLivescoresLive Kenyan TVLive Kenyan Radio

Backup MySQL Database to a file

Kenyans247 / Science/Technology / Programing / Backup MySQL Database to a file (10 View's)

Restore Mysql Database From A Backup File How Do I Create Fast Backup Of Camera Photos To Cloud Storage Backup Mysql Database To A File Backup Mysql Database To A File
(Go Down) (» Reply topic)
Backup MySQL Database to a file by Kenyans247(m): 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.

(» Reply topic) (» Go Up)

Recommended for you

» Restore Mysql Database From A Backup File » How To Use All Of Windows 10’s Backup And Recovery Tools » How Do I Create Fast Backup Of Camera Photos To Cloud Storage » Backup Mysql Database To A File
Viewing this topic:
1 guest(s) viewing this topic

Sections: Huduma Centre, Africa, Environment, Business, Romance, Computers, Building/Architecture, Webmasters, Technology Market, Education, Social Media/K247 Chit-Chat, Sports, Lifestyle, Jokes Etc, TV/Movies, South Sudan Forum, Somalia Forum, Ugandan Forum, Rwanda Forum, Burundi Forum,

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.