Copying entire database ...

[JLEEINC]

hello all ... i'm working with a company and they are using FMP ... i'm relatively experienced with websites and php coding, etc, but not too overly familiar with all the in's and out's of FileMaker - getting more and more familiar, but there are still "holes in my game" ... what we are looking to do is take a database that we are working with for a particular business and duplicate this for another business venture (of course we'll probably change/modify some things after the fact) but this will give us a great head start and for lack of a better term a working template to build the next database ...

my question is there has to be a way to essentially grab everything, code, scripts, images, etc and duplicate it, right?

the original db is hosted online, so i'll need to login and grab everything .. then create a new hosting acct and "upload" the new (duplicate) database ...

i think this gives an idea of what i'm trying to accomplish ... please feel free to post, pm or email if there are questions and/or (hopefully) insight/suggestions..

Thank you all in advance!

Jerimy.

[aldipalo]

I'm not familiar with FM and web sites, but, in FM you just "Save a copy as" create a new name and everything goes with it. If you just want the structure, but, not the records save it as a clone.

HTH

[Stuart Taylor]

[color:red]I think the reason no one has answered this post is that there are inconsistancies...

what we are looking to do is take a database that we are working with for a particular business and duplicate this for another business venture --- [color:red]So you built this one?

(of course we'll probably change/modify some things after the fact) but this will give us a great head start and for lack of a better term a working template to build the next database ...

my question is there has to be a way to essentially grab everything, code, scripts, images, etc and duplicate it, right?

[color:red]Why would you need to do this if you built the original?

the original db is hosted online, so i'll need to login and grab everything .. then create a new hosting acct and "upload" the new (duplicate) database ...

[color:red]I work mainly with FileMaker on an internal setup ... you seem not to understand how the structure would work for constructing a filemaker database with non instant web publishing else you would not have asked this?

i think this gives an idea of what i'm trying to accomplish ... please feel free to post, pm or email if there are questions and/or (hopefully) insight/suggestions..

[color:red]It seems like you are trying to steal someones work from an uninformed perspective... sorry if thats not true ... but that is how i read it

The web is open source and i have no problem with using open source code ... filemaker is not open source.

Best

Stuart

[JLEEINC]

Stuart, i'm not stealing anything - let me further explain .. and i do thank you for your statements and observations ... i hesitate to say im overly familiar with file maker, again, my focus is more on websites, etc ... i'm working for a company that uses FMP as it's inventory management system, and they hired someone to build it originally - since this guy has gone AWOL, and since i have more experience with this "type" of thing in our company i'm trying to take the lead with it (best as i can ) ...

i've been quite successful in manipulating the database that's already there, like adding fields and other features, etc ...

the company i'm working with is now wanting to set up another business model and they are wanting to use FMP again ... and i figured the best way would be to start with the model we already have avail to us ...

we currently have our database hosted - i don't have a local copy - that's the reason for mentioning that it was online, as i thought there might be a slightly different way of gathering this info vs it being right on my hard drive (of course) ...

i hope that helps explains the situation ... again, i'm not doing anything malicious, etc, simply do not have all the knowledge that i "need" ... and was hoping this forum could help me out a little ... thanks again,

Jerimy.

[email protected]

256-658-0558

[Stuart Taylor]

I did think this maybe the other option.

Ok then if you have internal access ... why not run a backup schedule from the server to make a copy of the current solution.

best

Stuart

[JLEEINC]

i was not sure that made an entire copy of structure as well as content/inventory ...

if thats the case then that sounds like the plan .. again, i would only assume that this cannot be a difficult process ... like anything, knowledge helps things a little bit , lol

so in running a backup schedule, do i have to implement some script or can is there another way to do this -sorry for the dumb questions, again, i'm just not that familiar with this process ..

Thank you very much for your help!

J.

[Stuart Taylor]

Mac or PC server?

[JLEEINC]

almost certain a PC server

[Stuart Taylor]

You don't have access to it???

[JLEEINC]

i can login to my database, but i dont know how to see if it's a mac server or pc server - i dont have "root" access to the server, just my database (at least that i'm aware of) ..

[Ender]

You'll need physical access to the server.

[JLEEINC]

interesting ... i would have thought i could make a copy without have "physical" access (that dont seem to make sense to me, but again i'm not familiar with the workings of fmp - i know with websites, you NEVER need "physical" access to a server)... this is becoming much more trouble than i thought ..

from what i'm gathering, i'm better off just creating a new db from scratch (even with my limited knowledge)

thanks for everyones help ..

Edited April 13, 2007 by Guest

[Ender]

This is a basic security measure for a server. Administrators don't want users (or hackers) to have access to download complete copies of their systems.

There are ways to access the server OS or file system remotely, but this capability is setup by the administrator, and is not a built-in feature of FM Server.

[Fenton]

Since you don't care about the data in the database, all you need is a "clone" of the file(s). And since it doesn't sound like there's been any structural changes lately, you could easily make a clone from backup copies of the files; which someone in the company should have access to (one would think).