Have you tried using the
> use db
> source /path/to/dumpfile.sql
command via the mysql command line client?
At 08:28 AM 5/20/2007, Vitaliy Okulov wrote:
Çäðàâñòâóéòå, mysql.
How i can speedup restore of mysql DB from file created by mysqldump?
MySQL is quite fast at reloading data, but if
you don't have enough memory or if
key_buffer_size is not set high enough, then it
can take days to re-index the data. You need to
stuff as much RAM as possible in your machine
and set key_buffer_size to at least 30% of your
machine RAM. I've had indexed take 2+ days to
rebuild and adding more RAM and tweaking
key_buffer_size allowed the same keys to be rebuilt in under an hour.
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
