| Patrick Henderson 2004-09-16, 8:36 pm |
| the easiest way I have found to move data from an access database to mysql
is to get the odbc driver from mysql.com and then export the file from
access to mysql. after you install the odbc driver, when you want to export
the table, just goto file/export. and where it asks where to, select odbc
as the type.
Patrick
<ooar123SP@AMntlworld.com> wrote in message
news:dm7ik0l74hf3rga00c5viph34alo1omb3h@
4ax.com...
> Hi,
>
> First post here and have what I think is an easy question.
>
> As the subject says I'm learning PHP and MySQL (been meaning to do
> this for almost a year!). I'm reading various tutorials and they tend
> to start with installation instructions.
>
> I have my own dedicated servers that are pre installed with PHP and
> MySQL. Have had a PHP file working and created a test database and
> added a table in MYSQL so know both are working on the server. Though
> not tried to use the two together yet.
>
> So my question is do I really need to install PHP and MySQL on a PC
> and if so why?
>
> Assuming I should install them is there an easy way to do this for
> Windows XP Pro?
>
> I vaguely recall seeing a post about bundled releases that install
> easier than the individual programs. I tried installing them
> singularly a few months back on a Win XP Home PC and ran into no end
> of problems! One of the reasons I upgraded to XP Pro.
>
> I plan to create a lot of sites from databases I have access to, so
> will be doing a lot of work with the above long term.
>
> Which brings me to another question while I'm here. I have some MS
> Access databases, is there a recommended way to convert these to
> MySQL? I have access to phpMyAdmin via a Plesk 6 server running Apache
> 2.0 (something, think 4 :-)). phpMyAdmin has the option to import text
> files, should I convert the access DB to a text file and then import
> into MySQL? If so what sort of txt file should I create?
>
> Thanks, real pain in the rear having to learn new things sometimes
> :-))
>
> David
> --
> http://www.search-engine-optimization-services.co.uk/
|