Re: ezmlm response

[Ute Hoffmann]

>Hi all,
>I work with mysql 3.23.40 on Mac Os X 10.0.x and have created a Database.
>This Database has to move to another mysql server 3.23.40 on a Mac OS X
>Server. In older versions (up to 3.23.39 I think) it was sufficient to
>create an empty database on the destination machine and just copy and paste
>the whole information (all three tables, complete with PK table to the new
>destination).
>
>This will not work any longer. (Mysql does not find the .frm tables, but we
>can see them in the terminal listed at the appropiate place in the
>database).
>
>Is there a built in way to export complete Databases in mysql? We searched
>the docs but in vain.
>
>Does sql provide for this situation anyway and we just don't know about
>this?
>
>Is there any way to get the database from machine a to machine b?
>
>Please help- there must be a way:-).
>
>Thanks.
>
>Ute
>



_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Access Database into mysql

[Ute Hoffmann]

Hi,

I have a database table, which was made with Microsoft Access and am to move 
the data into a mysql database table. As there are some long entries, which 
exceed the data size allowed in a table cell by Microsoft Excel I can't 
export it via Excel and convert it from Excel into a Text Tabs document (As 
I did with other tables).

I tried all possible export options with Access, but when I try to do a text 
document it just removes all data, which is not visible on the monitor, when 
the export takes place. (It is a table with many columns). I can have either 
a html file or a richtext file with all the data in. Both seem to me not 
that useful for my purpose.

Is it possible to export the data directly from Access to Mysql via the ODBC 
Adaptor? If so, how?

Is there another way to get the data from Access to Mysql without the need 
of either pasting them in per hand or by putting the tabs and breaks in by 
hand into the rich text file to end up with a text which is tabs separated 
and can be imported?

I work on a NT machine. The data will be exported to mysql and will then be 
moved to a MacOsX Server 1.2.

Thank you for any suggestions, as doing it by hand will be very 
inconvenient.

sincerely
Ute
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php