| Viewing this topic:
1 guest(s) viewing this topic
Live Kenyan TV •
Live Kenyan Radio
|Restore MySQL database from a backup file by Kenyans247(m): Sun 22, March, 2020 08:40am|
There are many reasons you would want to restore a database from a backup file… But you should also test this on a test server just to make sure that your database backups are working correctly. Here’s the syntax:
mysql -h hostname -u username -pthepassword databasename < dumpfile.sql
Here’s an example:
mysql -h localhost -u root -p72aDufi8 db01 < thedumpfile.sql
Sections: World List Directory, Career, Food, Africa, Investment, Building/Architecture, Computers, Innovation, Art, Graphics & Video, Education, Photography, Jokes Etc, Poetry, K247 TV, Social Media/K247 Chit-Chat, Somalia Forum, Tanzania Forum, South Sudan Forum, Rwanda Forum, Ugandan 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.