This forum is no longer active. Please post your questions to our new community site

Forums Tracks

Database tracks

Subscribe to Database tracks 7 post(s), 2 voice(s)

 
Avatar smika 6 post(s)

Hello,

I used tracks as a stand alone application on my server. Now I want to use the Bitnami packages.
The only problem is, that my old installation doesn’t work anymore, so now I can’t make an export from my old installation. Also I don’t know in which mysql tables tracks saved the todo’s and users. Is this is the ibdata1?

I treid to copy the forms and the ibdata1 to the bitnami installation, but this doesn;t work.

I hope someone can help me to solve this problem.

Thanks a lot,

Smika

 
Avatar Beltrán Rueda Administrator 3,714 post(s)

The database name is “bitnami_tacks” in the mysql/data folder, but copy the database is not the best way to restore the database. Could you start the old database and create a backup?

$ mysqldump -u root -p bitnami_tracks > bitnami_tracks.sql

 
Avatar smika 6 post(s)

The strange thing is, when I add a todo in my tracks. I don;t see any change in the timestamp of the files in bitnami_tracks. So where does tracks store his data?

Smika

 
Avatar Beltrán Rueda Administrator 3,714 post(s)

Could you check the timestamp of the files into that folder?

 
Avatar smika 6 post(s)

total 160
rw-rw—- 1 mysql mysql 65 2009-11-11 23:33 db.opt
rw-rw—- 1 mysql mysql 9000 2009-11-11 23:33 users.frm
rw-rw—- 1 mysql mysql 8670 2009-11-11 23:33 tags.frm
rw-rw—- 1 mysql mysql 8670 2009-11-11 23:33 sessions.frm
rw-rw—- 1 mysql mysql 8566 2009-11-11 23:33 schema_migrations.frm
rw-rw—- 1 mysql mysql 8924 2009-11-11 23:33 projects.frm
rw-rw—- 1 mysql mysql 8748 2009-11-11 23:33 notes.frm
rw-rw—- 1 mysql mysql 8774 2009-11-11 23:33 contexts.frm
rw-rw—- 1 mysql mysql 9038 2009-11-11 23:33 todos.frm
rw-rw—- 1 mysql mysql 8682 2009-11-11 23:33 taggings.frm
rw-rw—- 1 mysql mysql 9702 2009-11-11 23:33 recurring_todos.frm
rw-rw—- 1 mysql mysql 9572 2009-11-11 23:33 preferences.frm
rw-rw—- 1 mysql mysql 8668 2009-11-11 23:33 open_id_authentication_nonces.frm
rw-rw—- 1 mysql mysql 8780 2009-11-11 23:33 open_id_authentication_associations.frm

I added a todo 1 hour ago, but nothing changed!

 
Avatar Beltrán Rueda Administrator 3,714 post(s)

Sorry, really strange I do not know what could be happening.

 
Avatar smika 6 post(s)

That;s why I think tracks saved my todo’s in ibdata1. But how can I import or use this from my old installation? When I copy my old ibdata1 to the mysql/data folder, then tracks doens’t work anymore.

Forums Tracks