<div>
There is no option for mysqldump to include/exclude indexes independently from the rest of the table definitions. &nbsp;You would need to drop them after they are created, or use a text editor to delete those lines in the resulting text file (they should be pretty easy to identify as they will start with PRIMARY KEY, UNIQUE KEY or KEY, I believe).
</div>


There is no option for mysqldump to include/exclude indexes independently from the rest of the table definitions.  You would need to drop them after they are created, or use a text editor to delete those lines in the resulting text file (they should be pretty easy to identify as they will start with PRIMARY KEY, UNIQUE KEY or KEY, I believe).

<div>
oh really!! even i was having the same idea but this article has confused me a lot...<br />
it shows clearly that its possible.<br />
<a href="http://node1.yo-linux.com/cgi-bin/man2html?cgi_command=mysqldump" rel="ugc">http://node1.yo-linux.com/cgi-bin/man2html?cgi_command=mysqldump</a><br />
&nbsp; &nbsp; &nbsp; &nbsp;? &nbsp;--disable-keys, -K<br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;For each table, surround the INSERT statements with /*!40000 ALTER<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;TABLE tbl_name DISABLE KEYS */; and /*!40000 ALTER TABLE tbl_name<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;ENABLE KEYS */; statements. This makes loading the dump file into a<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;MySQL 4.0 or newer server faster because the indexes are created<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;after all rows are inserted. This option is effective for MyISAM<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;tables only.
</div>


oh really!! even i was having the same idea but this article has confused me a lot...
it shows clearly that its possible.
http://node1.yo-linux.com/cgi-bin/man2html?cgi_command=mysqldump [http://node1.yo-linux.com/cgi-bin/man2html?cgi_command=mysqldump]
       ?  --disable-keys, -K

        For each table, surround the INSERT statements with /*!40000 ALTER
        TABLE tbl_name DISABLE KEYS */; and /*!40000 ALTER TABLE tbl_name
        ENABLE KEYS */; statements. This makes loading the dump file into a
        MySQL 4.0 or newer server faster because the indexes are created
        after all rows are inserted. This option is effective for MyISAM
        tables only.

<div>
what are available options?
</div>


<div>
<div class="content wysiwyg-content">
How can i take mysqldump without indexes ?<br />
and also is there any way to only dump out the indexes ?
</div>
</div>


How can i take mysqldump without indexes ?
and also is there any way to only dump out the indexes ?

mysql DUMP without/of indexes

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.