Click here to get back home

Developing DB-driven Sites Offline?
 Home | NewsGroups | Search | About
Login Password
Register Now! Lost Password?
 alt.www.webmaster    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
Developing DB-driven Sites Offline? Berko 06-15-2006
Get Chitika Premium
Posted by Berko on June 15, 2006, 2:27 pm
Please log in for more thread options

Hi, there, all. I have been working with MySQL in the past while. I
began this work doing blog designs for Wordpress and Drupal and I have
started coding my own. Enough background...

How do you guys handle your development of db driven sites? I like to
design offline so that I can do my work even without a connection. I
have PHP and MySQL installed on my Powerbook, but I ran into a problem
when I exported a database from localhost to production server.

So, do you guys have any problems developing offline and then going
live with the data you have in your local database? Any pitfalls to
watch out for? Any tools that make it easier for you? (I know about
MAMP and Headdress for OS X.)

Thanks in advance.


Posted by David Dorward on June 15, 2006, 2:38 pm
Please log in for more thread options
 Berko wrote:

> So, do you guys have any problems developing offline and then going
> live with the data you have in your local database?

None

> Any tools that make it easier for you?

Writing an install script to set up the database and using that to set up
the development system is a good bet.

--
David Dorward <http://blog.dorward.me.uk/> <http://dorward.me.uk/>
Home is where the ~/.bashrc is

Posted by mens libertina on June 15, 2006, 2:46 pm
Please log in for more thread options

Berko wrote:
> Hi, there, all. I have been working with MySQL in the past while. I
> began this work doing blog designs for Wordpress and Drupal and I have
> started coding my own. Enough background...
>
> How do you guys handle your development of db driven sites? I like to
> design offline so that I can do my work even without a connection. I
> have PHP and MySQL installed on my Powerbook, but I ran into a problem
> when I exported a database from localhost to production server.
>
> So, do you guys have any problems developing offline and then going
> live with the data you have in your local database? Any pitfalls to
> watch out for? Any tools that make it easier for you? (I know about
> MAMP and Headdress for OS X.)


Solution: I always try to develop on an exact replica so I can avoid
any migration issues. :)

Without knowing more about your problem, all I can suggest is that you
doublecheck file and table names, database evironment settings, and the
host's limitations. If you're sure that your installations of PHP and
MySQL are the same, the host probably has switched on/off some
environment options that you aren't aware of.

$.02


Posted by Ignoramus19197 on June 15, 2006, 2:58 pm
Please log in for more thread options
> Hi, there, all. I have been working with MySQL in the past while. I
> began this work doing blog designs for Wordpress and Drupal and I have
> started coding my own. Enough background...
>
> How do you guys handle your development of db driven sites? I like to
> design offline so that I can do my work even without a connection. I
> have PHP and MySQL installed on my Powerbook, but I ran into a problem
> when I exported a database from localhost to production server.

I do it all the time with algebra.com, with is a mod_perl, MySQL kind
of site.

> So, do you guys have any problems developing offline and then going
> live with the data you have in your local database? Any pitfalls to
> watch out for? Any tools that make it easier for you? (I know about
> MAMP and Headdress for OS X.)

I have no problems.

I extract database contents, scp them to my machine and load them in
my database, I wrote scripts for that. My database is about 10 MB,
compressed, without a special table called "cached" that contains
various frequently used, precomputed data.

do:

man mysqldump
man scp
man mysql

i


Posted by David Cary Hart on June 15, 2006, 3:08 pm
Please log in for more thread options
opined:
> Hi, there, all. I have been working with MySQL in the past while. I
> began this work doing blog designs for Wordpress and Drupal and I
> have started coding my own. Enough background...
>
> How do you guys handle your development of db driven sites? I like
> to design offline so that I can do my work even without a
> connection. I have PHP and MySQL installed on my Powerbook, but I
> ran into a problem when I exported a database from localhost to
> production server.
>
> So, do you guys have any problems developing offline and then going
> live with the data you have in your local database? Any pitfalls to
> watch out for? Any tools that make it easier for you? (I know about
> MAMP and Headdress for OS X.)
>
> Thanks in advance.
>
If you feel the need to develop offline make sure that you are using
the same versions of MySQL and PHP. Furthermore, compilation options
with PHP can make a huge difference. I am amazed how many hosts are
still running MySQL 3x which breaks anything built with => 4x. Some
php packages are release specific. For example I use jpgraph in
conjunction with MySQL and PHP for graphs. There are two versions;
PHP 4x only and PHP 5x only.

--
Displayed Email Address is a SPAM TRAP
Our DNSRBL - Eliminate Spam: http://www.TQMcube.com
Multi-RBL Check: http://www.TQMcube.com/rblcheck.php
The Dirty Dozen Spammiest Ranges: http://tqmcube.com/dirty12.php

Similar ThreadsPosted
www.etools.tk - Anybody interested in developing such web-sites or needs a helping hand can contact us. April 16, 2007, 2:25 am
oops - Oil Depot Fire Knocks Web Sites Offline December 13, 2005, 2:25 am
Developing in Japanese February 10, 2006, 2:02 am
Developing killer application August 2, 2005, 8:13 am
pls check this page I'm developing January 18, 2006, 10:01 am
I am New to Web Developing seeks your advice December 11, 2008, 6:48 am
Offline XHTML validator ? June 15, 2005, 6:16 pm
Free Offline Log Analysis Tool March 2, 2005, 4:44 pm
What is the best way to save a site for offline viewing? January 12, 2007, 5:21 pm
Offline Link Checking Software? January 15, 2007, 11:32 pm

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap