MySQL database files won't install

[arioch]

I'm installing MySQL in binary form, and i'm at the point of installing the database files.

When i run:

scripts/mysql_install_db --user=mysql

I get "No such file or directory". But i'm inside the dir?!? It is there...

This penguin is goin' belly up!

What's going on?

Bye.

[Choozo]

Which version of MySQL?

Just downloaded 4.0.21 binary, and had a look through the docs/manual.txt which said you had to be in the 'mysql' directory when running this command.

When you are in the directory you claim to be; What does ls -l scripts give you?

[arioch]

I'm using MySQL 4.0.21

I am in the correct dir. according to the instructions I have (/usr/local/mysql)

www.sitepoint.com/books/Kevs-php-mysql.pdf
Page thirteen and forward.

This is what "ls -l scripts" gives me from that location:


-rw-r--r-- 1 503 users 8769 2004-09-06 18:29 make_binary_distribution.sh
-rw-r--r-- 1 503 users 4514 2004-09-06 18:29 Makefile.am
-rw-r--r-- 1 503 users 17280 2004-09-06 18:30 Makefile.in
-rw-r--r-- 1 503 users 2014 2004-09-06 18:29 make_sharedlib_distribution.sh
-rw-r--r-- 1 503 users 4440 2004-09-06 18:29 make_win_binary_distribution.sh
-rw-r--r-- 1 503 users 8475 2004-09-06 18:29 make_win_src_distribution.sh
-rw-r--r-- 1 503 users 1462 2004-09-06 18:29 msql2mysql.sh
-rw-r--r-- 1 503 users 1702 2004-09-06 18:29 mysqlaccess.conf
-rw-r--r-- 1 503 users 111509 2004-09-06 18:29 mysqlaccess.sh
-rwxr-xr-x 1 503 users 10584 2004-09-06 18:35 mysqlbug
-rw-r--r-- 1 503 users 9400 2004-09-06 18:29 mysqlbug.sh
-rw-r--r-- 1 503 users 4161 2004-09-06 18:29 mysql_config.sh
-rw-r--r-- 1 503 users 2970 2004-09-06 18:29 mysql_convert_table_format.sh
-rw-r--r-- 1 503 users 20080 2004-09-06 18:29 mysqld_multi.sh
-rw-r--r-- 1 503 users 11092 2004-09-06 18:29 mysqld_safe.sh
-rw-r--r-- 1 503 users 4979 2004-09-06 18:29 mysqldumpslow.sh
-rw-r--r-- 1 503 users 10412 2004-09-06 18:29 mysql_explain_log.sh
-rw-r--r-- 1 503 users 2647 2004-09-06 18:29 mysql_find_rows.sh
-rw-r--r-- 1 503 users 476 2004-09-06 18:29 mysql_fix_extensions.sh
-rw-r--r-- 1 503 users 10314 2004-09-06 18:29 mysql_fix_privilege_tables.sh
-rw-r--r-- 1 503 users 32270 2004-09-06 18:29 mysqlhotcopy.sh
-rw-r--r-- 1 503 users 14964 2004-09-06 18:29 mysql_install_db.sh
-rw-r--r-- 1 503 users 6308 2004-09-06 18:29 mysql_secure_installation.sh
-rw-r--r-- 1 503 users 17268 2004-09-06 18:29 mysql_setpermission.sh
-rw-r--r-- 1 503 users 13640 2004-09-06 18:29 mysql_tableinfo.sh
-rw-r--r-- 1 503 users 3116 2004-09-06 18:29 mysql_zap.sh

[Choozo]

# chmod +x scripts/mysql_install_db.sh
# scripts/mysql_install_db.sh --user=mysql

[arioch]

Got:


scripts/mysql_install_db.sh --user=mysql
scripts/mysql_install_db.sh: line 86: my_print_defaults: command not found
Didn't find @libexecdir@/mysqld
You should do a 'make install' before executing this script


Make install? When I didn't install from source? Hmmmm doesn't add up...

When I typed "make install" in "/usr/local/mysql" (and the scripts dir) I got:

"no rule to create target "install". stop." (not surprising).

[Choozo]

You probably need to do a chmod +x on all the files in scripts/

As you could see now, you got a step further by making mysql_install_db.sh executable.

[arioch]

Didn't work. I got the same message as in my previoue post, and that's after I reinstalled my entire system and tried agagin! I searched the net, thoroughly, and absolutely nobody seems to have my problem.

I'm getting sick of this, I've looked at several MySQL installation howto's, and nothing mentions anything resembling my problem. It just runs:(

[Choozo]

Now why don't you just opt for the MySQL that comes ready configured with your distro during istallation - or do an apt-get mysql (or whatever that deb package is named)?

Guessing at Debian from your .sig

[arioch]

1) SimplyMEPIS is installed as a livecd = No package selection.

2) Apt disperses the installationfiles out all over the system like a shotgunblast, making the work with the DB annoying from the CL. This way, I know everything starts in "/usr/local/mysql".

I'm following the recipe to the point. Why am I having this problem? The system says the dir and the file doesn't even exist, but it does. I thought Linux was supposed to make sence ...

Why does Linux deny the existence of a dir that I'm actually standing in? And a file that actually exists? - Even as root!

This gives me the Windows-shakes.

[Choozo]

Well, I wouldn't blame "Linux" for this but chalk it off as a quirk with Mepis. :p

Try adding /usr/local/mysql to both 'root' and 'your_username' $PATH environment variables, and try again.

E.g. export PATH=$PATH:/usr/local/mysql

Cheers :)

[sheds]

My mandrake disto came with mysql. Maybe you can try installing from the cd instead of having to go through all this trouble. It's a suggestion. :)

[Choozo]

Originally posted by sheds
My mandrake disto came with mysql. Maybe you can try installing from the cd instead of having to go through all this trouble. It's a suggestion. :) Please read what have already been suggested and tried one more time?

[voidinit]

Actually, you should really read the readme documentation very, very closely. It will point you to a file called install-binary or something similar. In that file it basically says:

root@yourbox:~#cd /usr/local/mysql
root@yourbox:mysql#adduser mysql

## Go through the process of adding the user mysql, but do no reset passwd.

root@yourbox:mysql#chown -R root:mysql .
root@yourbox:mysql#chown -R mysql:mysql data/
root@yourbox:mysql#pwd
/usr/local/mysql
root@yourbox:mysql#scripts/mysql-install-db
root@yourbox:mysql#bin/safe_mysqld&
root@yourbox:mysql#bin/mysqladmin -u root password 'newpassword'

[arioch]

Actually, I just recently managed to install LAMP after a complete re-install of the OS. To begin with, it still didn't work, even though it worked flawlessly on my laptop with the exact same procedure, OS and MySQL version :confused:. A new version of MySQL (4.1) recently got released, and with that, I got it running on my desktop as well, without getting the "no such..." message. :confused:

I've never had this kind of completely logic-defying problem with Linux before. Either the dir/file is there or it isn't.

Thanx for the responses.