From: Joseph R. H. <jo...@ne...> - 2002-02-19 14:43:32
|
There are a couple of options that I can think of: 1)you can do mysqldump phphelpdesk > somefilename.sql that'll dump the phphelpdesk database into a file for you. Actually, this is already done for you in a file that you use during the install process. 2)you can setup an ODBC connection from your MS Access Box to the MySQL box and just import the data from Access into the phphelpdesk MySQL tables. On Mon, 2002-02-18 at 12:43, Matt Grab wrote: > The trick would be mapping the fields in your access database to the fiel= ds=20 > in mysql. Are you able to do that? If so, just export the tables into a= =20 > .txt or .csv file, and then import them into mysql. I do not know how to= =20 > import into mysql, does somebody else? > Matt >=20 > At 02:40 AM 2/17/2002 -0600, Russ Haskett wrote: >=20 >=20 > >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 >=20 >=20 > _______________________________________________ > Phphelpdesk-help mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help |