Re: [WebDNA] Can WebDNA corrupt a db?
This WebDNA talk-list message is from 2012
It keeps the original formatting.
numero = 108045
interpreted = N
texte = I edit my DBs in BBEdit (only) all the time. In fact, I have closedatabase code at the bottom of most my pages that I can invoke if I need to reload a database after hand-editing. Usually, I find directly opening, looking, and editing to be the most efficient way to troubleshoot or fix something. I also have one site where I sometimes export a new DB from Filemaker and overwrite the existing one using FTP. The only times I can remember that a DB got corrupted was because the server ran out of disk space and couldn't update the db so it destroys it completely. Not pretty. I've been caught by this one a couple of times, once when I was running my own server, and again on a shared server. Of course you do have to be smart about it and set up BBEdit to do the right thing regarding line endings and clean up data if you take it from someone else, etc. I appreciate that some people are afraid to directly edit DB files, but it's unfair to try to scare everyone else out of doing so. Terry At 11:34 AM -0500 1/10/12, aaronmichaelmusic@gmail.com wrote: >I typically create and administer all dbs from webdna itself. My >rule is to never open a db in a text editor. Any time you do, you >expose your db to risk. -- Terry Wilson | terry@terryfic.com | http://terryfic.com http://WhosComing.com - a simplified, affordable online reservation system iStockPhoto portfolio - http://www.istockphoto.com/Terryfic3D?refnum=Terryfic3D -------------------------------------------------------------------------- Attitude is the only difference between ordeal and adventure.
Associated Messages, from the most recent to the oldest:
I edit my DBs in BBEdit (only) all the time. In fact, I have closedatabase code at the bottom of most my pages that I can invoke if I need to reload a database after hand-editing. Usually, I find directly opening, looking, and editing to be the most efficient way to troubleshoot or fix something. I also have one site where I sometimes export a new DB from Filemaker and overwrite the existing one using FTP. The only times I can remember that a DB got corrupted was because the server ran out of disk space and couldn't update the db so it destroys it completely. Not pretty. I've been caught by this one a couple of times, once when I was running my own server, and again on a shared server. Of course you do have to be smart about it and set up BBEdit to do the right thing regarding line endings and clean up data if you take it from someone else, etc. I appreciate that some people are afraid to directly edit DB files, but it's unfair to try to scare everyone else out of doing so. Terry At 11:34 AM -0500 1/10/12, aaronmichaelmusic@gmail.com wrote: >I typically create and administer all dbs from webdna itself. My >rule is to never open a db in a text editor. Any time you do, you >expose your db to risk. -- Terry Wilson | terry@terryfic.com | http://terryfic.com http://WhosComing.com - a simplified, affordable online reservation system iStockPhoto portfolio - http://www.istockphoto.com/Terryfic3D?refnum=Terryfic3D -------------------------------------------------------------------------- Attitude is the only difference between ordeal and adventure.
Terry Wilson
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Moment of Thanks (1997)
NewCart+Search with one click ? (1997)
converchars in sendmail context.... (2004)
Fun with Dates - finally resolved but.... (1997)
Large Database (2000)
Time Tracking (2003)
Where is f2? (1997)
gremlins? (2000)
ANother SHOWIF problem (1997)
Cart Numbers (1997)
date formatting for CC card expiration date check (1998)
OT: Need some DVD advice (2006)
Running subtotal? (1998)
Searching a database... (2003)
Shipping charges depending on tax rate? (1997)
RE: EXTERNAL EMAIL: RE: [WebDNA] [BULK] SQL ODBC 00000 Error (2019)
Uploading Files and Descriptions W* (2000)
HTML Emails To Eudora For Windows (2005)
Separate SSL Server (1997)
system crashes, event log (1997)