Find where the tablespaces are located on your server (mine is under: /usr/local/mysql/data). Move all your files(table1.*) below to the tablespace directory you choose. Then login to mysql and do a "show tables". Remeber you must login as some_user and choose the table space name you moved your files to. Your should see table1 in your output.
Hope this helps, -Teresa -----Original Message----- From: Chris Bergeron [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 3:36 PM To: Mysql Subject: mysql using existing .MYD .MYI files? Is there a way I can import data from a mysql using the mysql files? They weren't created using mysqldump; they were just copied from another directory. For example, I have the files: databasename/table1.frm databasename/table1.MYD databasename/table1.MYI how can I bring these into mysql? Mysql doesn't recognize them. It's only seeing user and mysql databases. Any ideas anyone? --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
