Archive for January, 2010

MySQL Backup & Restore

Posted by shawson in mySQL on January 29th, 2010

I did this on an install of MySQL 5 Community Server running on Windows 2008 Server Web Edition- From the command line- backup:

mysqldump -u [username] -p[password] [database name] > FILE.sql

restore;

mysql -u [username] -p[password] [database name] < FILE.sql

Remember; if you have restored your core mysql database, which contains all the info on users and privileges, you will need to do a

FLUSH PRIVILEGES;

before you will be able to login using those user accounts!

, , , ,

No Comments

Web site’s back!

Posted by shawson in Uncategorized on January 29th, 2010

Just a quick note to say everything is back up and running after the past 24 hours worth of downtime. I’ve rebuilt the server here with a fresh install of windows server 2008 and the latest releases of php for IIS and MySQL5, as well as a whole new backup plan.

No Comments

Karma, now available on iTunes!

Posted by shawson in iPhone on January 19th, 2010

My first published iPhone app, “Karma” is now available on the iTunes store http://itunes.com/apps/karma

No Comments

Submitted “Karma” to Apple for approval

Posted by shawson in Uncategorized on January 18th, 2010

I’ve just submitted my second ever iPhone app to apple for approval- you can find details of the app on the dedicated Karma iPhone app support page on my new iPhone projects site.

I shall post again once it’s been accepted (hopefully!)

2 Comments

Cocos2d documentation on Easing effects for animating sprites

Posted by shawson in Objective C, iPhone on January 15th, 2010

just found this ; http://www.cocos2d-iphone.org/wiki/doku.php/prog_guide:actions_ease?s=ease after ages of searching! shows you how to do smooth scrolling movements which ease out.

No Comments

Full Text Reindex, scheduled job has no steps!

Posted by shawson in SQL Server on January 12th, 2010

We have a SQL Server 2005 box, on which we have a database which has a full text index. The database gets a massive refresh of its data each night, meaning the full text index needs rebuilding. I added a schedule to my full text index (Databases > [DBName] > Storage > Full Text Catalogs > Right click your index – click properties > Population Schedule) and this created me a new job (SQL Server Agent > Jobs) but when i opened it up and went to steps, nothing was there!  If i tried running the job it would fail because there are no steps!

I found this as a documented bug in the initial release candidate of sql 2005 (since fixed in the service packs) on the microsoft connect site, and added a workaround – basically just add your own job, using the following sql (which i found on msdn) to rebuild your index;

ALTER FULLTEXT CATALOG [catalogue_name] REBUILD;

Of course, this is only a workaround until we can get the latest service pack installed.

, ,

No Comments