Kenyans247 Forum

Welcome, Guest: Join Kenyans247 LOGIN!

Stats: 224 Members, 11,371 topics and 65 posts Date: Sunday 05 April 2020 at 03:54 PM
TrendingRecentNewestClassifiedDirectoryLivescoresLive Kenyan TVLive Kenyan Radio

Dump just the table structure to a file in MySQL

Kenyans247 / Science/Technology / Programing / Dump just the table structure to a file in MySQL (18 View's)

Dump Just The Table Structure To A File In Mysql Dear Mama 2pac Produced By Tony Pizarro Album Me Against The World
(Go Down) (» Reply topic)
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.

Syntax:

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.

Example:

mysqldump -d -h localhost -u root -p2Uad7as9 database01 > dumpfile.sql

https://www.howtogeek.com/howto/programming/mysql/dump-just-the-table-structure-to-a-file-in-mysql/

(» Reply topic) (» Go Up)

Recommended for you

» Dear Mama 2pac Produced By Tony Pizarro Album Me Against The World » Dump Just The Table Structure To A File In Mysql
Viewing this topic:
1 guest(s) viewing this topic

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.