Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Eric Robinson
June 23, 2005, 8:43 pm
rate this thread
utilization through the roof. This happened once before, and the technican
simply dumped the data to disk and then played it back in. This seemed to
correct database corruption. After than, the database went back to normal
performance. Does anyone know how to do this?
Re: How To Dump The Database and Read It Back In?
If you're having issues like this and dumping and re-reading the data is
fixing it, then there's bound to be issues which can be approached in
There are some table maintenance functions availble. The manuals page is
Of particular use are 'repair table', 'optimize table' and 'check
table'. From reading the manual page, the optimize table function
appears to fix indexes which may be what your problem relates to.
If you do decide to dump the database you want the mysqldump command.
The manual page is here:
You can then read it into the database on the command line like so
"mysql -u [username] -p [databasename] < dumpfile.txt"
However, you should really do this as a last resort. It would be better
to try to work out what the problem is and have a regular maintenance
program to prevent the slowdowns in the first place.
Chris Hope | www.electrictoolbox.com | www.linuxcdmall.com
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum