List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 24 2006 1:07am
Subject:Re: Dump only data and Database
View as plain text  
At 18:59 -0200 1/23/06, Luiz Rafael Culik Guimaraes wrote:
>Dear Friends
>
>What are the best options to dump an entire database on linux (with 
>creation of databases and tables) with out dumping the index 
>creation sentences

What is an "index creation sentence"?

Do you mean that you want the dump to include the CREATE TABLE statements,
but for those statements not to contain the index definitions?  If so,
there's no option for that.

>
>For dump I use this command
>
>mysqldump -e  --add-drop-database --add-drop-table dabasename > database.sql

-- 
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Thread
Need help with a queryMark Phillips23 Jan
  • Dump only data and DatabaseLuiz Rafael Culik Guimaraes23 Jan
    • Re: Dump only data and DatabasePaul DuBois24 Jan
  • Re: Need help with a queryMichael Stassen23 Jan
    • Re: Need help with a queryMark Phillips24 Jan
  • Re: Dump only data and DatabaseLuiz Rafael Culik Guimaraes24 Jan
  • Re: Dump only data and DatabaseHarald Fuchs24 Jan
RE: Dump only data and DatabaseSST - Adelaide)24 Jan