Monday, August 31, 2009

Importing large mysql database dump into Godaddy shared hosting

So, you have a database dump which you want to upload to Godaddy? There is the Import tab in phpmyadmin, but it often times out for big files, so it's not really good. Luckily, there is a better way using FTP:

Upload your dump with FTP into the _db_backups directory in the root of your hosting account. Then go to hosting management, databases and click on the pencil icon beside the database into which you want to pump data.

Then check out the icons on the top. Select Restore and you'll see your dump file there (possibly you have to give it a .sql extension, I used this extension in the first place).

Next select the file and start the restore. A warning will pop up saying the existing database contents will be lost, but don't worry, it happens only if you restore a complete databse dump with dropping tables and stuff. If your dump contains only insert statements and such then existing data won't be harmed. You can always create a database backup first in database managament if you want to be on the safe side.

The uploading of the dump may take a while, but that's it. I don't know why Godaddy doesn't have this description in their support pages. It's very useful.

Sunday, August 16, 2009

How to turn the right control key into a useful key.

For example, into F15 which you can bind with a tool like Autohotkey.

Follow the instructions here.

Use the value: 00 00 00 00 00 00 00 00 01 00 00 00 66 00 1D E0 00 00 00 00 00

Thursday, August 13, 2009

Google Reader update breaks Mark Until Current as Read

Damn! I use it all the time. They could really incorporate it officially into Google Reader. Such a useful extension.

Sunday, August 2, 2009

Convert jQuery selector result to DOM object

The result of e.g. $("#id") is not a DOM object, but an array of DOM objects, so you can index it to access the DOM object: $("#id")[0]