Archive | MySQL RSS feed for this section
Import BCP output file into MySQL database
Recently, A project that I was working on required that I import a fairly large BCP file containing around 260k entries. I spent quite a while trying to work out the best way to import it directly into my MySQL database with little or no pre-processing required. The answer turned out to be quite simple, [...]
Continue reading...Optimize All MySQL Tables on a Server
30. January 2010
I would like to point out here quickly that I assume that you have root access in this article. One of my regular tasks is to optimize MySQL installations (primarily on shared cPanel servers). I use a number of utilities in order to identify areas in which I could optimize the MySQLÂ installations, the main one [...]
Continue reading...
19. June 2011
4 Comments