Good
day,
I have created a
database using MySQL under Windoze and am trying to move the data to MySQL
running on Linux. I have exported the data to a res file - can't see how to do a
mysqldump in Windoze. I then try and import the file on the Linux machine using
LOAD DATA, but end up with either NULL in all the fields except the primary key
field or if I use ENCLOSED BY '', I end up with the data enclosed by
quotes.
How do I do this
"properly", please?
TIA
Glyn
<><><><><><><><>
Glyn
Davies
Cirrus-TechVue
South Africa
Tel: +27 11 783
1508
www.cirrus.co.za
______________________________________________
"The information contained in this email is intended solely for the
use of the individual or entity to whom it is addressed and others
authorised to receive it.
Cirrus Techvue is not liable for the proper, complete transmission
of the information contained in this email, or any delay in its
receipt, and does not warrant that the mail is virus-free."
--------------------------------------------------------------------- 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
