| Viewing this topic:
1 guest(s) viewing this topic
Live Kenyan TV •
Live Kenyan Radio
|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.
mysqldump -h localhost -u root -pmypassword databasename > dumpfile.sql
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.
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.