Re: [Phphelpdesk-help] converting database files to phphelpdesk

[<Ste...@in...>]

The info on doing this is described at this url:

http://www.mysql.com/doc/L/O/LOAD_DATA.html

I've used it myself... works great




                                                                                                                                       
                    Matt Grab <ma...@ma...>                                                                                      
                    Sent by:                                 To:     phphelpdesk-list <Php...@Li...>         
                    php...@li...urc       cc:                                                                       
                    eforge.net                               Subject:     Re: [Phphelpdesk-help] converting database files to          
                                                              phphelpdesk                                                              
                                                                                                                                       
                    18-02-2002 21:43                                                                                                   
                                                                                                                                       
                                                                                                                                       




The trick would be mapping the fields in your access database to the fields
in mysql.  Are you able to do that?  If so, just export the tables into a
.txt or .csv file, and then import them into mysql.  I do not know how to
import into mysql, does somebody else?
Matt

At 02:40 AM 2/17/2002 -0600, Russ Haskett wrote:


>i have used a windows application for our helpdesk for 2 years now. i am
>looking to migrate to phphelpdesk so we can access our helpdesk from
>both windows and linux workstations (among other reasons).
>
>the current windows software stores its records in an access database.
>is it possible to drop the current database into the mysql database of
>phphelpdesk so that we don't lose all the data we have collected over
>the past 2 years?
>
>sorry if this question is insane but i really need to find a way to not
>lose info as well as migrate to a more scalable solution.
>
>thanks,
>
>-russ
>
>
>_______________________________________________
>Phphelpdesk-help mailing list
>Php...@li...
>https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help


_______________________________________________
Phphelpdesk-help mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help