Kenyans247 Forum

Welcome, Guest: Join Kenyans247 LOGIN!

Stats: 223 Members, 11,345 topics and 65 posts Date: Friday 03 April 2020 at 09:53 AM
TrendingRecentNewestClassifiedDirectoryLivescoresLive Kenyan TVLive Kenyan Radio

Restore MySQL database from a backup file

Kenyans247 / Science/Technology / Programing / Restore MySQL database from a backup file (14 View's)

Backup Mysql Database To A File Restore Mysql Database From A Backup File Change Or Set The Mysql Root Password Backup Mysql Database To A File
(Go Down) (» Reply topic)
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
https://www.howtogeek.com/howto/mysql/restore-mysql-database-from-a-backup-file/

(» Reply topic) (» Go Up)

Recommended for you

» Restore Mysql Database From A Backup File » Switch Mysql To Listen On Tcp » Backup Mysql Database To A File » Switch Mysql To Listen On Tcp
Viewing this topic:
1 guest(s) viewing this topic

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.