lunatechian (lunatech-ian)

By default, MySQL's datadir is placed in the /var/lib/mysql directory. However, if you are planning on using MySQL tables to store a lot of data and your /var partition is small, it might cause you problem at a later stage. In such a scenario, it is better to move the MySQL's datadir to another partition (like /home.

The steps are

1. Stop your mysql server before starting this operation
2. Create the directories that will be new datadir
3. chown the directory to the mysql:mysql user
4. copy the files from the old datadir to the new location. However, make sure that the files named ib_arch_log_0000000000, ib_logfile0 etc. are not copied to the newer location.
5. Make sure that the files and directories are owned by mysql user
6. Make changes in the my.cnf to point the new datadir.
7. Restart the MySQL database
8. You might need to do varying degree of troubleshooting to get the server working if there is some problem
9. Create a new database and verify that the files for this database are getting created in the new datadir
10. After the server is running for a few days properly, get rid of the old data.
11. Sleep

I tested these steps on MySQL 4.0.24 and all my tables were MyISAM type.

A few days back Lig and me put together the second edition of PHPCommunity Gazette. Do have a look at it .

I was watching the recorded episodes of Simpsons today. In one of the scenes, the children of Springfield decide that they are going to spill out all the secrets of the adults. So they start to plan how they can do it.

Lisa : Let us publish this information on the Internet
Bart : No, we have to get to the people whose opinion really matter

A question that has been on my mind for a long time was put in by my friend Mary (he is the sysadmin at Sarai). Let me give a bit of the background. When I was in Delhi, a bunch of us fellow-geeks used to meet almost twice a month to talk about our hacking projects, our current work (all of us were happily free of NDAs), have a good dinner and generally get into debates about topics that would be considered a taboo (or inappropriate by most people). Once when we were joking about how prostitution is legal in Thailand and what procedure would the government be using to collect the taxes (I mean, how will they cross check the receipts), that Mary popped the question "Why do you think prostitution is wrong ?" . My first reaction was "It is not the right thing to do" - however, I realized that pushing my judgement of what is right and what is wrong on someone else is not the correct thing to do. I have been thinking of why I consider prostitution to be wrong - it is a profession - a service is provided and a price is paid for it.

This question again came to the front of my mind when I read this blog post by Joshua Newton. He writes about the An autobiography of a sex worker by Nalini Jameela. He posts the following quote from the book

Some see brothels as a space for sexual perverts.
They are wrong. Why do people of all walks of life come to us? Parents prevent our sexual desires in the beginning. Then teachers in schools. Then moralists in churches, mosques, and temples slap rules. When you grow up, police and courts take up the role. They spread the rule one man for one woman. Yet people seek out prostitutes all over the world in all ages. What does it prove?

So are you against moral structures?
No. Men dictate the morality of this age. They use wives or sex workers to their ends. We dream of a new dawn of morality. Sexuality like food and shelter is a terrain of human tastes. It is still to be developed into a plateau of endless tastes and forms. Morality should not suppress. It should be liberating. When sex work turns into one among many human service sectors, you will stop suppressing yourself and others.

I have not read the book but this book is definitely on my to-read book

Fuck cisco for this. Here are the notes from Lynn's presentation.. Unsurprisingly, a small list of mirrors for Lynn's presentation is here.