Re: [amee-developer] Dump Database
James Smith
2009/2/19 Jer <lan...@gmail.com>:
> Just wondering is there some way to do a database dump on the amee
> staging database I have been given. I am doing a college project based
> on the calculations AMEE performs and it would be really handy to know
> what fields amee stores for each profile.
A database dump wouldn't really help, I'm afraid! The best way to find
what data we store is to explore the web interface (you were sent a
link with your key). We don't necessarily store all data for every
profile, just what the API client puts in. As for how AMEE performs
its calculations, the wiki (http://wiki.amee.com) has information on
all that side of things.
Alternatively, if you mean you want to fetch all data for an existing
profile, you can use our recursive GET call to fetch all data within a
profile in one go. See
http://my.amee.com/developers/wiki/AmeeProfileApi/BatchGet for
details.
cheers,
James Smith
James Smith
2009/2/19 Jerry Lane <lan...@gmail.com>:
> Thats ok so. The reason I wanted this is I cant make the database on my own
> site using the db_init.php file in the calc so I was going to try manually
> import this database and try reinstall. I will have to think around another
> way to do this so.
Ah, you are using the PHP calculator on your own site? I understand a
bit more now :)
You should be able to set up a local database using db_init.php. If it
doesn't work, you need to check your MySQL settings in
login_details.php - make sure you can use them on the command line to
be sure they work. Note that this database doesn't store any carbon
data however, that is all stored in AMEE itself. The local database
just stores user registrations for the PHP frontend.
cheers,
James Smith