Welcome Guest Login Register Member List
ExpressionEngine Forums
Advanced Search
Username: Password:
Remember Me? forgot password?
You are here: Forum Home  >  Usage  >  Tips and Tricks  >  Thread
   
 
Transfer and import db from an existing Tracks db (mysql)?
 
labyrinth
Posted: 09 December 2007 02:35 AM   [ Ignore ]  
Newbie
Rank
Total Posts:  6
Joined  2007-12-09

How do I get Tracks to use a transferred mysql db?

I just switched from OpenSuse to Debian. Tracks is a beautiful program and worked well on OpenSuse w/ Firefox. I made a backup/dump of my tracks db using mysql-admin, and now on this Debian machine (using IceWeasel browser), I was able to get tracks up and running (after I learned about adding the socket: /var/run/mysqld/mysqld.sockvar/ line to the profiles in config/databases.yml).

Unfortunately, though I can import the tracks.sql dump I made into the new mysql on this system (watch out if you have a YYYY-MM-DD format), I don’t know how to make tracks work with it. Either tracks won’t let me login, or I end up with a wiped db after running rake db-schema-import (no surprise there—that’s what it’s supposed to do).

I’m open to any solution that will either:
1) allow me to import dump data prior to
2) allow me to feed the dump in after going through a normal install

Thanks!

Profile
 
Reinier Balt
Posted: 09 December 2007 01:35 PM   [ Ignore ]   [ # 1 ]  
Sr. Member
RankRankRankRank
Total Posts:  442
Joined  2006-10-05

Hi

Did you also restore the salt you configured in your old tracks install. It is a setting in /config/environment.rb

If the salt of your new install is not the same, tracks will run, but you will not be able to log in.

Profile
 
labyrinth
Posted: 10 December 2007 05:09 AM   [ Ignore ]   [ # 2 ]  
Newbie
Rank
Total Posts:  6
Joined  2007-12-09

oh….......................

crap.

Moral:
Do not forget your salt.

Profile
 
labyrinth
Posted: 10 December 2007 05:35 AM   [ Ignore ]   [ # 3 ]  
Newbie
Rank
Total Posts:  6
Joined  2007-12-09

Phew. It took me some time, but I finally remembered the salt string. Everything works perfectly now. Thanks so much—it never would have occurred to me that the salt was the problem.

Profile
 
   
 
 
‹‹ Tracking Usage      Javascript Helper for default Context Name ››

Powered By ExpressionEngine
Template Design By Sonnenvogel.com
Select a theme:

ExpressionEngine Discussion Forum - Version 2.1.1 (20081028)
Script Executed in 0.1140 seconds

Atom Feed
RSS 2.0