Archive for January 29th, 2010
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 29, 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.
-
You are currently browsing the archives for Friday, January 29th, 2010
Flexicoder Blog- WWDC 2012 – Apple TV Apps May 10, 2012I’m lucky enough to be attending the WWDC this year, as it reaches closer to the “day of the long queue” my thoughts are turning to what I hope will be announced at the conference. So here they are in no real order (apart from the first one) Ability to run apps on the Apple […]
- Úll Conference – Review May 1, 2012I’ve just come back from Dublin, Ireland, where I attended the Úll Conference to cover all things iOS related. When the tickets where first released, the conference was advertised as a 3 day affair, starting on Friday 27th April and ending on the Sunday. A friend from Ireland, @realmikebutler, had told me about the conference […]
- Worthing Digital – Local Tech Community March 8, 2012If you are local to the Worthing/Sussex area, please check out the new Worthing Digital group, they’ve arranged a number of good talks and also started up a co-working event. If you have any ideas on helping the community grow you can also post comments on the forum […]
- Open doors effect at App launch February 4, 2012This is a copy of a blog entry I originally wrote for ios-blog There are a number of apps in the App Store that launch with a set of closed doors, these are then opened to present the actual UI underneath it. I had to create this effect for an app I wrote for a […]
- New App – Ballpark Costs January 26, 2012When potential clients ask for a ballpark figure on development costs, these are the questions I ask to help clarify whats required and therefore affect the cost. They are in no particular order… What are the target platforms, iPhone, iPad, Android, Windows Mobile? If iPhone do you want a universal version, i.e. the same app […]
- CCLabelBMFont – not displaying May 13, 2011I hit a problem today where the CCLabelBMFont wasn’t rendering the text I wanted at all. I created the the fnt file using http://www.n4te.com/hiero/hiero.jnlp Turns out that as it creates the underlying png for some reason it saves it in a flipped format, therefore you need to load the png into your favourite graphics package […]
- WWDC 2012 – Apple TV Apps May 10, 2012