Re: Losing indexes after building from dump.

2004-03-01 Thread Sasha Pachev
Toby wrote: I finally figured out that we had been running large databases without indexes working at all. It turns out that if I use mysqldump to dump out a database, then drop/create the database and build from the dump, none of the indexes work. Things slow to a crawl. I found inadvertantly

Losing indexes after building from dump.

2004-02-27 Thread Toby
I finally figured out that we had been running large databases without indexes working at all. It turns out that if I use mysqldump to dump out a database, then drop/create the database and build from the dump, none of the indexes work. Things slow to a crawl. I found inadvertantly that by