?
Solved

MySQL Install: Neither host could be looked up with ./bin/resolveip

Posted on 2005-04-16
14
Medium Priority
?
3,720 Views
Last Modified: 2008-01-09
DB: MySQL 4.1
OS: Fedora Core 3

I'm trying to install mysql from a binary version on linux and I'm getting the following error.

[root@web_server mysql]# scripts/mysql_install_db
scripts/mysql_install_db: line 86: ./bin/my_print_defaults: cannot execute binary file
Neither host 'server' nor 'localhost' could be looked up with
./bin/resolveip
Please configure the 'hostname' command to return a correct hostname.
If you want to solve this at a later stage, restart this script with
the --force option

Any ideas?
0
Comment
Question by:itcdr
  • 7
  • 7
14 Comments
 
LVL 10

Expert Comment

by:kupra1
ID: 13799264
Check your aliases in the /etc/hosts file.
Change them to something like this:

127.0.0.1 localhost localhost
111.112.113.114 mysite mysite.com
0
 
LVL 10

Expert Comment

by:kupra1
ID: 13799285
Also, see what happens when you run this command from your shell prompt:

resolveip `hostname` (your hostname)  

You should run this command from the bin folder of your mysql, which contains the resolveip exe.
0
 
LVL 1

Author Comment

by:itcdr
ID: 13799312
I was having other problems with the installation and since I wanted to start from scrach anyway I went ahead and re-installed linux.

Now I have a fresh installation and ready to start. I was thinking I should install mysql from the source. I'm going to copy my db over to this server. 1 of the tables inparticular has over 1.5 million records with 8 columns. Is there any compilation options that I should use to make the db as optimized as possible in this situation?
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
LVL 10

Expert Comment

by:kupra1
ID: 13799319
you can directly copy all the table specific files in the data folder of mysql.
0
 
LVL 1

Author Comment

by:itcdr
ID: 13799323
I know how to copy the files over to the new server. I'm just having trouble installing mysql itself.

I wanted to know if there is any reason I should install from source. Is there any options that are not default that would help my db be more effecient?
0
 
LVL 10

Expert Comment

by:kupra1
ID: 13799325
also, you can use the mysqlhotcopy script.
http://dev.mysql.com/doc/mysql/en/mysqlhotcopy.html
0
 
LVL 10

Expert Comment

by:kupra1
ID: 13799333
what trouble are you having in installation?
0
 
LVL 1

Author Comment

by:itcdr
ID: 13799343
This may be the problem. For some reason resolveip is not working. The executable is there. What's wrong?

[root@static-host mysql]# sh bin/resolveip localhost
bin/resolveip: bin/resolveip: cannot execute binary file
0
 
LVL 1

Author Comment

by:itcdr
ID: 13799350
I tried changing the hosts file as you said, but it made no difference. I still get the following:

[root@static-host mysql]# scripts/mysql_install_db
scripts/mysql_install_db: line 86: ./bin/my_print_defaults: cannot execute binary file
Neither host 'static-host' nor 'localhost' could be looked up with
./bin/resolveip
Please configure the 'hostname' command to return a correct hostname.
If you want to solve this at a later stage, restart this script with
the --force option
0
 
LVL 1

Author Comment

by:itcdr
ID: 13799379
I got it working. I downloaded the standard version compiled with gcc instead of the one compiled with C++. I did the same thing and it worked.

Now how do I get the mysql client to work globally. Currently I have to access the db with
./bin/mysql

and that's if I'm already in the mysql directory. How do I access the db with just 'mysql' like I have done before?
0
 
LVL 10

Expert Comment

by:kupra1
ID: 13799410
set the /bin/mysql in your classpath.
0
 
LVL 1

Author Comment

by:itcdr
ID: 13799414
I'm new to linux. What is classpatch?
0
 
LVL 10

Accepted Solution

by:
kupra1 earned 1500 total points
ID: 13799420
0
 
LVL 1

Author Comment

by:itcdr
ID: 13799441
Thanks
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question