At 6:59 PM -0600 10/30/01, Ryan Winterbourne wrote: >I was wondering if there is a way to download the MySql database >hosted on a UNix machine running Solaris, to my Windows computer and >be able to view and modify it from there? The Solaris version has >.ISD and .ISM files wheras Windows has .MYD and .MYI files. Any help >would be greatly appreciated. Thanks
ISAM tables (.ISD/.ISM) are machine dependent, so you cannot move them directly to Windows and use them there. MyISAM tables (.MYD/.MYI) are machine independent. If your tables were MyISAM tables, you'd be able to do what you want. You can use mysqldump to dump the tables to a text file, then move that file to your Windows box and recreate them there. On Solaris: % mysqldump database tbl1 tbl2 ... > dump.txt On Windows: C\:> mysql database < dump.txt --------------------------------------------------------------------- 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