A
u
g
u
s
t
2
0
0
5
It’s terminal
I just realised how wonderful it is to have terminal access in MacOSX.
One web application I am working on has a database that’s about 14MB in size when it’s exported. We use MySQL extensively and the ubiquitous PHPMyAdmin. However, PHPMyAdmin has limitations on the size of imports primarily due to the script timeouts built into PHP on a shared server setup. This means if we use PHPMyAdmin to backup databases, we can’t get them back in.
So we have to resort to mysqldump instead and SSH in to the server to do the work. We simply open a Terminal window and go right ahead. And somehow it seems so much nicer that doing the Run -> Command thing in Windows, which of course it is.
