At 18:59 -0200 1/23/06, Luiz Rafael Culik Guimaraes wrote:
>What are the best options to dump an entire database on linux (with
>creation of databases and tables) with out dumping the index
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