RE: mysql using existing .MYD .MYI files?
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
RE: @HOSTNAME@error
Those are the startup scripts to startup MySQL when the server is rebooted. view the file /etc/init.d/rc.d/S61mysql and search for @HOSTNAME@ and my_print_defaults and see how these commands are invoked and if they exists on your system. Hope this helps, -Teresa -Original Message- From: harry amarantidis [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 5:02 PM Cc: [EMAIL PROTECTED] Subject: Re: @HOSTNAME@error I checked my boot log and found the follwing errors /etc/init.d/rc.d/S61mysql: @HOSTNAME@: command not found /etc/init.d/rc.d/S61mysql: my_print_defaults: command not found I have checked the manual but could not figure out if this is a problem or not mysql seems t run fine for now. What are these commands use for? any insight would greatly be appreciated Harry Amarantidis - 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
RE: ERROR 2002
Seems like MySQL is not running. Check to make sure it's running by executing: ps -eaf | grep mysql (on a Unix platform). If no processes are running then start MySQL. Hope this helps you, -Teresa -Original Message- From: Pablo Javier Gonzalez Mateos [mailto:[EMAIL PROTECTED]] Sent: Friday, September 07, 2001 4:10 PM To: [EMAIL PROTECTED] Subject: ERROR 2002 Anyone can help me with this What can i do thanks a lot ! ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) -- Pablo Javier Gonzalez Mateos, [EMAIL PROTECTED] on 07/09/2001 - 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
Error: Out of virtual memory
Hello, Sorry for the previous posting, please disregard. I just installed mysql 3.22.30 on Digital Unix system 4.0D; it works fine but when I exit out of "mysql" I get the error "xmalloc: out of virtual memory " . Is this an error to be concerned about? The followingis the message I get: Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 3.22.30 Type 'help' for help. mysql exit xmalloc: out of virtual memory - 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