Is there a way to get a DB Dump?

Apr 14, 2008 4:20pm

amarillo 3 post(s)

Hi!

I’ve tested Tracks and GTD on MorphExchange thoroughly and decided to host my own installation of Tracks.
The system is running and now I want to migrate my tasks from MorphExchange.
Tracks does provide an export function for all the data, but, as I found out on the developer forum, the import function is not finished yet.
So, is there a way to get a MySQL dump (or the Sqlite db file) of my data?

thanks,
amarillo

Apr 15, 2008 6:50am

LaniSara 8 post(s)

Hi amarillo,

Thank you for using Tracks!

We’re currently evaluating your query. Our team will get back to you as soon as possible to inform you about the status of this query.

Again, thanks!

Apr 15, 2008 1:02pm

Mark Maglana Administrator 4 post(s)

Hi amarillo,

Your best option right now is to use Tracks’ export function to get your data in CSV format. After that, use a tool such as PHPMyAdmin to import or inject your data directly into your local Tracks installation’s database.

Apr 15, 2008 9:59pm

amarillo 3 post(s)

Hi again,

I tried to import the csv file using PHPMyAdmin as recommended. But I always get the following error:
bq. Invalid field count in CSV input on line 1.
My settings are:

character set: utf8
start at line 1 (to skip fieldnames)
input format: csv
fields terminated by ,
fields enclosed by ”
I also tried some other settings. Does anyone have an idea what’s wrong here?

thanks,
amarillo

Jun 19, 2008 12:37am

Mark Maglana Administrator 4 post(s)

Hello Amarillo,

I apologize for the late reply. Have you consulted the developer of Tracks re this issue? I’d also suggest that you post this problem in the PHPMyAdmin forums as they may know about this issue.

Jun 21, 2008 10:49am

amarillo 3 post(s)

Hello Mark,

The Tracks developers sent me to you (i.e. MorphExchange forum).
They’re working on an import function, but it won’t be ready until v1.7.

Jun 21, 2008 4:02pm

Mark Maglana Administrator 4 post(s)

Hi Amarillo,

It seems as though Tracks is exporting a CSV file that PHPMyAdmin doesn’t understand. What I’d like to do is pinpoint where the problem lies (including if it’s from our end). So could you do the following for me:

1. From your local (not the one in Morph eXchange) Tracks installation, export your data in CSV format.

2. Try to import the data again using PHPMyAdmin.

If you’re still getting an error in step 2, that could mean Tracks is producing a CSV file that PHPMyAdmin doesn’t understand.

Apr 14, 2008 4:20pm amarillo 3 post(s)	Hi! I’ve tested Tracks and GTD on MorphExchange thoroughly and decided to host my own installation of Tracks. The system is running and now I want to migrate my tasks from MorphExchange. Tracks does provide an export function for all the data, but, as I found out on the developer forum, the import function is not finished yet. So, is there a way to get a MySQL dump (or the Sqlite db file) of my data? thanks, amarillo

Apr 15, 2008 6:50am LaniSara 8 post(s)	Hi amarillo, Thank you for using Tracks! We’re currently evaluating your query. Our team will get back to you as soon as possible to inform you about the status of this query. Again, thanks!

Apr 15, 2008 1:02pm Mark Maglana Administrator 4 post(s)	Hi amarillo, Your best option right now is to use Tracks’ export function to get your data in CSV format. After that, use a tool such as PHPMyAdmin to import or inject your data directly into your local Tracks installation’s database.

Apr 15, 2008 9:59pm amarillo 3 post(s)	Hi again, I tried to import the csv file using PHPMyAdmin as recommended. But I always get the following error: bq. Invalid field count in CSV input on line 1. My settings are: character set: utf8 start at line 1 (to skip fieldnames) input format: csv fields terminated by , fields enclosed by ” I also tried some other settings. Does anyone have an idea what’s wrong here? thanks, amarillo

Jun 19, 2008 12:37am Mark Maglana Administrator 4 post(s)	Hello Amarillo, I apologize for the late reply. Have you consulted the developer of Tracks re this issue? I’d also suggest that you post this problem in the PHPMyAdmin forums as they may know about this issue.

Jun 21, 2008 10:49am amarillo 3 post(s)	Hello Mark, The Tracks developers sent me to you (i.e. MorphExchange forum). They’re working on an import function, but it won’t be ready until v1.7.

Jun 21, 2008 4:02pm Mark Maglana Administrator 4 post(s)	Hi Amarillo, It seems as though Tracks is exporting a CSV file that PHPMyAdmin doesn’t understand. What I’d like to do is pinpoint where the problem lies (including if it’s from our end). So could you do the following for me: 1. From your local (not the one in Morph eXchange) Tracks installation, export your data in CSV format. 2. Try to import the data again using PHPMyAdmin. If you’re still getting an error in step 2, that could mean Tracks is producing a CSV file that PHPMyAdmin doesn’t understand.

Morph eXchange Forums

Voices