Welcome Guest Login Register Member List
ExpressionEngine Forums
Advanced Search
Username: Password:
Remember Me? forgot password?
You are here: Forum Home  >  Installation  >  Mac OS X  >  Thread
   
 
What do I need to backup?
 
SeanFGTD
Posted: 07 July 2006 06:34 PM   [ Ignore ]  
Newbie
Rank
Total Posts:  2
Joined  2006-07-07

I followed the Locomotive instructions to install Tracks.  Now I want to make sure that the proper user files are added to my backup routines.  Does anyone know which files hold my user info?  I’m guessing from mod dates that its “/tracks-1.041/db/tracks-104.db”.  Is this correct?

Thanks,
Sean

Profile
 
bsag
Posted: 08 July 2006 11:59 AM   [ Ignore ]   [ # 1 ]  
Administrator
Avatar
RankRankRankRank
Total Posts:  217
Joined  2006-03-05

If you’re using SQLite3 as your database, and you’ve specified tracks-104.db as your database, then yes—you should back up that file. If you want to be extra careful, you can also make a dump of the contents, so if the database gets corrupted, you can just make a new database and use that.

Go into Terminal and type the folowing, replacing ‘pathtotracks’ with the full path to your tracks installation of course:


cd /pathtotracks/db/
sqlite3 tracks-1041.db .dump > ~/Desktop/tracks_dump.sql

The file tracks_dump.sql will be a text file containing all the commands necessary to restore your db, and you can save that somewhere safe.

Profile
 
SeanFGTD
Posted: 10 July 2006 12:57 PM   [ Ignore ]   [ # 2 ]  
Newbie
Rank
Total Posts:  2
Joined  2006-07-07

bsag,

Thanks for the advice.  Dumping the contents occasionally sounds like an excellent idea also.

Regards,
Sean

Profile
 
   
 
 
‹‹ Simply, wonderful      Locomotive and public access. ››

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

ExpressionEngine Discussion Forum - Version 2.1.2 (20091002)
Script Executed in 0.1289 seconds

Atom Feed
RSS 2.0