MySQL Backup & Restore
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!
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.
Karma, now available on iTunes!
My first published iPhone app, “Karma” is now available on the iTunes store http://itunes.com/apps/karma
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!)
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.
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.
Tools – Roy Osherove – Regulazy!
Just found an awesome tool allowing Regex noob’s such as myself, to build up Regex patterns, using only the sample data that you wish to match- go download Regulazy here!
How to run SQL Profiler against local SQL Express instances
Posted by shawson in .net, SQL Server on December 9th, 2009
I’m building a project using entity framework and wanted to ensure it wasn’t going mental and spamming the database with more queries than it should- this requires SQL Profiler, but i didn’t know how to connect it to my local instance of sql (I had just added an MDB file to the app’s app_data folder, so it was running via local sql express)
Turns out it’s easy- you just connect to .\SQLEXPRESS database and then execute this query against the master database;
SELECT owning_principal_name, instance_pipe_name FROM sys.dm_os_child_instances
From the results you will be able fish out the “named pipe” that you can just put into the server name box when connecting with profiler.
Sql Profiler connection dialogue
via Brad Wilson: Profiling SQL Server Express User Instances.
Properties getting “k__BackingField” appended to their name in the WSDL file
Posted by shawson in .net, C#.net, WCF, Web Services on December 7th, 2009
I was finding k__backingField was being appended to all my object properties when exposed via my a WCF service, in the WSDL. The solution it turns out was simple- just had to make my class a [DataContract] and mark the properties as [DataMember].
via WCF Data Contracts and “k__BackingField” Property Naming – Nathan Bridgewater.
Making your WCF Service compatible with legacy .net 1.1 applications
Posted by shawson in .net, C#.net, WCF, Web Services on December 7th, 2009
I’m building an error tracking service which all our future web project will report to, so we can track and tag all our various systems problems from one place- this is currently done with email which is a bit of a nightmare!
According to Microsoft, traditional ASMX web services are now considered “Legacy technology” (!) so I thought I would buite the bullet and build the new services using WCF.
This was fairly painless until I tried to consume the web service in some old .net 1.1 web apps- when trying to add the web reference I received this error message;
Web ReferenceslocalhostReference.map(1): Custom tool warning: DiscoCodeGenerator unable to initialize code generator. No code generated.
I found a great article over on the MSDN – and all it takes is a small change to the web.config, fiddling with, my old friend, the httpBindings.
I had to swap out the default bindings put in by .net;
<endpoint address="" binding="wsHttpBinding" contract="HachetteErrorTracker.IErrorLog">
<identity>
<dns value="localhost"/>
</identity>
</endpoint>
For this one;
<endpoint
address=""
binding="basicHttpBinding" bindingNamespace="http://errortracker.localhost/"
contract="HachetteErrorTracker.IErrorLog"
/>
How to: Configure WCF Service to Interoperate with ASP.NET Web Service Clients.
-
Flexicoder Blog- Label with line breaks January 15, 2010To have a label recognise line breaks in the text that you enter in the Interface Builder, set the number of lines to 0, and when you want a new line press both the Option key and the Return key Social Bookmarking […]
- Core Data – Updated model November 26, 2009After creating a new version of your data model, and adding the relevant code to handle lightweight migration, to actually get your code to run ensure that you do a clean all targets otherwise you get merge model errors! Social Bookmarking […]
- iPhone mipmaps November 22, 2009Here is some code that shows the glTexParameterf values that need to be set to automatically generate mipmaps and to get OpenGL to use them glBindTexture(GL_TEXTURE_2D, texture[0]); //Next 2 lines are required if not mipmap //glTexParameterf(GL_TEXTURE_2D, GL_TEXTURE_MIN_FILTER, GL_LINEAR); //glTexParameterf(GL_TEXTURE_2D, GL_TEXTURE_MAG_FILTER, GL_LINEAR […]
- iPhone gluProject and gluUnProject November 19, 2009Now that I’ve started to do some OpenGL I needed to determine where in my 3D world a user had touched. In order to do this you can use a function called gluUnProject, which isn’t part of the standard framework. I’ve converted the code (so have many others) and posted it here in case it [...] […]
- Xcode tip – use alt key for selecting code November 13, 2009If you have a code that is in a vertical section and you would like to select it, for copy/cut/paste/delete functions hold down the alt key while dragging your cursor over the code. The screen shot below shows me selecting //’s so that I can uncomment the code The selection you make can also be used [...] […]
- Moving the view so a Textfield can be seen when keyboard is shown September 25, 2009Found this great article that shows how to scroll the view so that a textfield is in view when the keyboard appears. http://de-co-de.blogspot.com/2009/03/moving-uitextfield-above-keyboard.html I’ve copied the code below so that I have a reference to it as well. You also need to ensure the following steps are followed… Make your controller implement UITextVi […]
- svn cleanup September 22, 2009I recently had a problem where I couldn’t check in files from my project because I was getting an error stating that the folder was locked. I tried to run a cleanup on the folder but that failed due to the “build” folder not being under source control. Quick and dirty solution to this is [...] […]
- Core Data – fetch a single entity September 10, 2009I’ve used the following code to retrieve an entity from Core Data, so that the result returns the entity object rather than a Dictionary -(Target *) currentTargetInContext:(NSManagedObjectContext *)context { Target *match; NSFetchRequest *request = [[NSFetchRequest alloc] init]; NSEntityDescription *entity = [NSEntityDescription entityForName: @"T […]
- UIActionSheet in a tab view August 20, 2009I was getting problems displaying an action sheet in a view that was contained within a tab control. UIActionSheet *sheet = [[UIActionSheet alloc] initWithTitle:@"Are you sure you wish to continue?" delegate:self cancelButtonTitle:@"No" destructiveButtonTitle:@"Yes" otherButtonTitl […]
- CoreData – SQLite Manager for Firefox August 14, 2009This Firefox add-on allows you to view the data you are running against while using the iPhone simulator. Your sqlite files can be found in the following folder /Users/”user name”/Library/Application Support/iPhone Simulator/User/Applications/”application guid”/Documents This is a great tool for view the data you’ve created within your apps, but I would sug […]
- Label with line breaks January 15, 2010