Hi Luiz,
If however you do not wish to create the indexes while inserting data,
you can use the following option for the 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 faster because the
indexes are created after all rows are inserted. This option is
effective for MyISAM tables only.
All the indexes will be created at the end. This would speed up your
restore considerably. This will only work on version 4.0 and above.
Regards
---------------------------------------------------------------
********** _/ ********** David Logan
******* _/ ******* ITO Delivery Specialist - Database
***** _/ ***** Hewlett-Packard Australia Ltd
**** _/_/_/ _/_/_/ **** E-Mail: [EMAIL PROTECTED]
**** _/ _/ _/ _/ **** Desk: +618 8408 4273
**** _/ _/ _/_/_/ **** Mobile: 0417 268 665
***** _/ ******
****** _/ ******** Postal: 148 Frome Street,
******** _/ ********** Adelaide SA 5001
Australia
i n v e n t
---------------------------------------------------------------
-----Original Message-----
From: Luiz Rafael Culik Guimaraes [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 24 January 2006 11:40 AM
To: MYSQL List; Paul DuBois
Subject: Re: Dump only data and Database
Paul
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.
yes, exactly this, and thanks for the answer
Regards
Luiz
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
