Hi to All Mysql Gurus,
I have 2 existing workstations which has both Mysql 3.23 client and server,
then I upgrade one of them to Mysql 4.0. To check, I use mysql client of
Mysql 4.0 to access the database of Mysql 3.23 server(which was on the 2nd
workstation) and worked perfectly. I was also able to create a new table
ACTL_MAT_VW from database FPY_BRT on Mysql 3.23 but when I used the
mysqlimport from Mysql 4.0 to populate that table , I'm having an error.
The error looks like this:
%> mysqlimport -u username -ppassword -h (ip addr of the other
workstation) - - delete - - fields-terminated-by=, FPY_BRT ACTL_MAT_VM
%> mysqlimport: Error: File ' ./FPY_BRT/ACTL_MAY_VW' not
found (Errcode: 2), when using table: ACTL_MAT_VW
I believe there's nothing wrong with the syntax since I'm using this with
3.23 version, how about the compatibility of Mysql 4.0 and Mysql 3.23?
Appreciate your advise on this matter.
Another question:
Is it possible to use a different version of client programs in accessing a
different version of server in one machine or diff machine? Let's say I'm
using Mysql 4.0 server but Mysql 3.23 client programs. Can you pls. quide
me or redirect me to proper installation in the mysql documentation. I'm
asking this because I'm thinking that If I use Mysql 3.23 client programs
like mysqlimport to access the 2nd machine I will not encounter the same
error above.
I will greatly appreciate any help coming from the lists..
Thanks,
Richard
[This e-mail is confidential and may also be privileged. If you are not the
intended recipient, please delete it and notify us immediately; you should
not copy or use it for any purpose, nor disclose its contents to any other
person. Thank you.]
---------------------------------------------------------------------
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
