|
       
 |
|
| Programming tutorials All Knowledge Info and links to posted here |
  |
|
Dump just the table structure to a file in MySQL
|
LinkBack | Thread Tools | Display Modes |
20-Dec-2006, 04:12 AM
|
#1 (permalink) |
|
Administrator
Posts: 18,715
Join Date: Jan 2006
Rep Power: 10
IM:
|
Dump just the table structure to a file in MySQL
mysqldump -d -h localhost -u root -pmypassword databasename > dumpfile.sqlThe 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 |
|
        
|
|
|
|
| |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| MySQL Export Table To Text File Software 7.0 | iTouch | Application Downloads | 0 | 26-Feb-2008 07:15 AM |
| MySQL Export Table To XML File Software 7.0 | iTouch | Application Downloads | 0 | 26-Feb-2008 07:12 AM |
| Import Excel file to Access Table | Iphone | Internet Explorer Error | 1 | 28-Mar-2007 12:49 AM |
| System freezing - examining dump file (.dmp) | Anilrgowda | Microsoft Windows xp error | 1 | 10-Mar-2007 01:08 AM |
| Save Dump -- The computer has rebooted from a bugcheck -- Dump Included Here | Anilrgowda | Microsoft Windows xp error | 1 | 10-Mar-2007 12:14 AM |
Linear Mode
