| Viewing this topic:
1 guest(s) viewing this topic
Live Kenyan TV •
Live Kenyan Radio
|Dump just the table structure to a file in MySQL by Kenyans247(m): Sun 22, March, 2020 08:31am|
For this exercise, we will use the mysqldump utility the same as if we were backing up the entire database.
mysqldump -d -h localhost -u root -pmypassword databasename > dumpfile.sql
The only option that is different than creating an entire backup is the -d switch, which tells mysqldump not to output the data.
mysqldump -d -h localhost -u root -p2Uad7as9 database01 > dumpfile.sql
Sections: World List Directory, Africa, Politics, Travel, Kenyans247 ads, Webmasters, Technology Market, Education, Universities, Phones, Social Media/K247 Chit-Chat, TV/Movies, Forum Games, Theatre/Comedy, Photography, Tanzania Forum, Burundi Forum, Rwanda Forum, South Sudan Forum, Somalia 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.