Connecting Tech Pros Worldwide Forums | Help | Site Map
bytes > topic > mysql > answers

How to take the back-up of all the tables "without data" in Windows??

Member
  
Join Date: Feb 2009
Posts: 57
#1: Aug 7 '09
Hi,
Can anyone please suggest me how to take the back-up of the tables "without data"? Right now i am using Mysql Administrator on Windows XP for taking back-ups and restoring.

TIA......,
Lauren

numberwhun's Avatar
Site Moderator
  
Join Date: May 2007
Location: New Hampshire
Posts: 2,571
#2: Aug 7 '09

re: How to take the back-up of all the tables "without data" in Windows??

Quote:

Originally Posted by SLauren View Post

Hi,
Can anyone please suggest me how to take the back-up of the tables "without data"? Right now i am using Mysql Administrator on Windows XP for taking back-ups and restoring.

TIA......,
Lauren

You want to do a mysqldump of the tables, but also specify the "- - no-data" option to specify to NOT dump the data as well.

Read the link provided. Also, don't forget to reference the online manuals at mysql, they are invaluable.

Regards,

Jeff
Member
  
Join Date: Feb 2009
Posts: 57
#3: Aug 7 '09

re: How to take the back-up of all the tables "without data" in Windows??

Thanx Jeff for the precious information.
Reply

« previous question | next question »

Similar MySQL Database bytes

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,439 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved