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
- › Hey Google, Longer Device Support Would Help the Earth Too
- › That’s No Moon, That’s an Ad
- › What Is “Watch Only” Mode on a Galaxy Watch? (and How to Use It)
- › Google’s Pixel 7 Will Only Get Three Years of OS Updates
- › How to Change a Windows User Account Password From Command Prompt
- › How to Mirror or Flip Text in Microsoft Word