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