I just finished a Freeway Pro/Perch enabled website, which is currently on my development server. I need to move the site and the XML database to the live server at GoDaddy.com.
Moving the Freeway Pro files is not a problem. However, moving the database will be. GoDaddy will not let you simply moving an XML database file onto its servers. Instead, you need to move just the data.
What’s the best/easiest way to do this? To me, PHP Admin is extremely cumbersome, so I tend to avoid it. In the past, I’ve used Sequel Pro, but I think Coda might have an XML utility as well.
Coda licenses Sequel Pro and integrates it into their application, as part of their all-in-one approach. Sequel / Coda will work, as long as the database server is configured to allow external users to connect. Most MySQL installations are set to only allow connections from “localhost”, as a security measure. phpMyAdmin runs on your server, so it connects over localhost, and there is no issue with permissions as a result.
phpMyAdmin is perfectly capable of rolling up all of your data and restoring it on another server. You can either back up the entire database (all tables and all content) or one table at a time. Be sure to capture format and data, and make sure that wherever you are restoring this data, the server is configured more or less the same. (Default charset is critical!)
Walter
On Jun 7, 2013, at 9:07 AM, RavenManiac wrote:
I just finished a Freeway Pro/Perch enabled website, which is currently on my development server. I need to move the site and the XML database to the live server at GoDaddy.com.
Moving the Freeway Pro files is not a problem. However, moving the database will be. GoDaddy will not let you simply moving an XML database file onto its servers. Instead, you need to move just the data.
What’s the best/easiest way to do this? To me, PHP Admin is extremely cumbersome, so I tend to avoid it. In the past, I’ve used Sequel Pro, but I think Coda might have an XML utility as well.
Okay, I’ll give it a go. I discovered that GD has something called Starfield, which looks like a licensed copy of PHP Admin, so I may try that first. Thanks Walter.