| Bug #40102 | error of installation | ||
|---|---|---|---|
| Submitted: | 17 Oct 2008 11:06 | Modified: | 17 Oct 2008 14:56 |
| Reporter: | yang lin | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Installing | Severity: | S1 (Critical) |
| Version: | 5.1.28 | OS: | Windows (xp 5.1.2600) |
| Assigned to: | Sveta Smirnova | CPU Architecture: | Any |
| Tags: | error of installation | ||
[17 Oct 2008 11:06]
yang lin
[17 Oct 2008 11:08]
yang lin
I don't known why ,thanks giving me the reason best regards
[17 Oct 2008 11:30]
Sveta Smirnova
Thank you for the report. You wrote: F:\project\mysql>mysqld --defaults-file="f:\project\mysql\my.ini " 081017 12:48:41 [Warning] Changed limits: max_open_files: 2048 max_connections: 800 table_cache: 619 F:\project\mysql>cd bin F:\project\mysql\bin>mysqld --defaults-file="f:\project\mysql\my.ini " -standalo ne --console 081017 12:50:50 [Warning] Changed limits: max_open_files: 2048 max_connections: 800 table_cache: 619 081017 12:50:50 InnoDB: Error: unable to create temporary file; errno: 2 081017 12:50:50 [ERROR] Plugin 'InnoDB' init function returned error. 081017 12:50:50 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 081017 12:50:50 [ERROR] Unknown/unsupported table type: INNODB 081017 12:50:50 [ERROR] Aborting 081017 12:50:50 [Note] mysqld: Shutdown complete But you started server with same *ini file 2 times. It is not a bug if server does not start second time: it can not share same port and data directory with other instances. If I understood you wrong feel free to explain what is real problem and reopen the report.
[17 Oct 2008 13:32]
yang lin
error by MySQL
Attachment: error by MYSQL.JPG (image/pjpeg, text), 176.77 KiB.
[17 Oct 2008 13:34]
MySQL Verification Team
Which is the exactly server version of 5.1?. Thanks in advance.
[17 Oct 2008 13:44]
yang lin
Hello, dear Sveta by your direction , i restart the MYSQL , but it give some error ,i uploaded the picture as a attachment. I have re-installed this mysql 5.1 many times ,every time ,i deleted all the files .But after installation , the error also appeared . I installed the software in the same path and directory . I also don't know the port , because i am a greenhand. do i need re-install the MySQL any more ? thanks
[17 Oct 2008 13:46]
yang lin
mysql-essential-5.1.28-rc-win32.msi thanks
[17 Oct 2008 14:28]
yang lin
" f:\project\mysql>mysqld --install MySQL51 --defaults-file="f:\project\mysql\my.i ni " The service already exists! The current server installed: "F:\project\mysql\bin\mysqld" --defaults-file="F:\ project\mysql\my.ini" MySQL51 F:\project\mysql>mysqld --defaults-file="f:\project\mysql\my.ini " 081017 12:48:41 [Warning] Changed limits: max_open_files: 2048 max_connections: 800 table_cache: 619 F:\project\mysql>cd bin " by the indication , do i need to change the Number of "MAX_open_files " and "max_Connections ", "table_cache" ?? Do these numbers suit my Operation environment: Windows XP 5.1.2600 Apache apache_2.2.9-win32-x86-no_ssl-r2 Php php-5.2.6-Win32 MySQL 5.1.28-rc No other SQL database and VB 2005 ,for example and installed them: Apache: f:\project\apache PHP : f:\project\Php MySQL : f:\project\mysql Mysql database : f:\project\database and everyone can read and write the files ,no access limit . apache and Php are OK thanks
[17 Oct 2008 14:35]
yang lin
details from my.ini
Attachment: my.ini (application/octet-stream, text), 8.77 KiB.
[17 Oct 2008 14:51]
Sveta Smirnova
Thank you for the feedback. You usually don't need to manually start MySQL server: it is installed as service already. You can check if you have MySQL server running using Windows task manager. I almost sure you have mysql server running. Please open Windows tak manager (Ctrl+Alt+Del) and exmine if process named mysqld.exe or mysqld-nt.exe exists in the list of processes. Please read also installation instructions at http://dev.mysql.com/doc/refman/5.1/en/windows-installation.html
[17 Oct 2008 14:52]
yang lin
" # CLIENT SECTION # ---------------------------------------------------------------------- # # The following options will be read by MySQL client applications. # Note that only client applications shipped by MySQL are guaranteed # to read this section. If you want your own MySQL client program to # honor these values, you need to specify it as an option during the # MySQL client library initialization. # [client] port=3306 [mysql] default-character-set=utf8 # SERVER SECTION # ---------------------------------------------------------------------- # # The following options will be read by the MySQL Server. Make sure that # you have installed the server correctly (see above) so it reads this # file. # [mysqld] # The TCP/IP Port the MySQL Server will listen on port=3306 #Path to installation directory. All paths are usually resolved relative to this. basedir="F:/project/mysql/" #Path to the database root datadir="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/" " from the part of my.ini , i found the port 3306 shared by client and server. the server listen on this port ,client use this port . Was it that the one you described in the first article ? thanks
[17 Oct 2008 14:56]
yang lin
thanks very much . this just fits me , hehe.. i need to make a research... thanks very much .. have a good day ...
