MySql 4.0.13 Doesn"t Work for me

MySql 4.0.13 Doesn"t Work for me

am 16.07.2003 00:21:00 von blakech

--_----------=_105830766036660
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset="iso-8859-1"

I downloaded MySql 4.0.13 for windows, unzipped it, installed it, and
tried starting it up using "mysqld --standalone". It executes but
doesn't load. This is on a computer running Windows 2000 Professional. I
put your software on a zip drive, 100 MB. I set the appropriate options
to reflect this in c:winnt/my.ini. Each time I execute the server with
"mysqld --standalone" it deposits an error message in a file with an
extension .err in my data directory, in which there is a message saying
it could not write some file like ibdata1; I don't remember the exact
name. That file is also in the data directory, but 0 bytes long. I
cannot give you this .err file because I subsequently deleted the error
file and all the expanded, installed mysql software files (after spending
an hour trying to get it to work), and only then looked on your website
to find where I could report the problem to you. However, I recall that
the .err file included error message #112, saying disk is full, but the
disk is NOT full, there is 38 meg of space left (on the zip drive). It
says it is trying to write a 10 MB file but is only writing 0 bytes. I
am sure there is 38 meg left. I created the my.ini file from your sample
my-small.cnf. In the my.ini file, I first tried NOT including the Innodb
options in the .ini file, then I included them (using 10MB as the size of
the dbdata1 file - or whatever it was called). It does not work in
either case. I also tried placing that the file on C: drive, and it
didn't work. Very frustrating day. mysqld never installed itself, as
demonstrated by using mysqlshow. I ran mysqld once with the --debug
option, and a trace file was made. I do not see anything significant
pertinent to the problem in the trace file, but I have attached it in
case you can find something in there. Note that I have used 2 earlier
versions of mysql successfully. So I am going back to the previous
version. A further comment on that - the FIRST version of Mysql I used
allowed me to install and run it from a drive OTHER THAN C:. The next
version, 3.23 I believe it was, would NOT let me do that. I don't like
this. I was hoping this would be fixed in 4.01.
- Blake Chapman
--

blakech@fastmail.fm

--
http://www.fastmail.fm - Or how I learned to stop worrying and
love email again

--_----------=_105830766036660
Content-Disposition: attachment; filename="mysqld.trace"
Content-Transfer-Encoding: base64
Content-Type: application/unknown; name="mysqld.trace"

VEAxICAgIDogPm15X2xvYWRfcGF0aA0KVEAxICAgIDogfCBlbnRlcjogcGF0
aDogZTpcc3FsXCAgcHJlZml4OiANClRAMSAgICA6IHwgZXhpdDogdG86IGU6
XHNxbFwNClRAMSAgICA6IDxteV9sb2FkX3BhdGgNClRAMSAgICA6ID5teV9s
b2FkX3BhdGgNClRAMSAgICA6IHwgZW50ZXI6IHBhdGg6IGU6XHNxbFxkYXRh
XCAgcHJlZml4OiBlOlxzcWxcDQpUQDEgICAgOiB8IGV4aXQ6IHRvOiBlOlxz
cWxcZGF0YVwNClRAMSAgICA6IDxteV9sb2FkX3BhdGgNClRAMSAgICA6ID5t
eV9sb2FkX3BhdGgNClRAMSAgICA6IHwgZW50ZXI6IHBhdGg6IDExOTE5LTYu
cGlkICBwcmVmaXg6IGU6XHNxbFxkYXRhXA0KVEAxICAgIDogfCBleGl0OiB0
bzogZTpcc3FsXGRhdGFcMTE5MTktNi5waWQNClRAMSAgICA6IDxteV9sb2Fk
X3BhdGgNClRAMSAgICA6ID5teV9sb2FkX3BhdGgNClRAMSAgICA6IHwgZW50
ZXI6IHBhdGg6IGVuZ2xpc2hcICBwcmVmaXg6IGU6XHNxbFxzaGFyZVwNClRA
MSAgICA6IHwgZXhpdDogdG86IGU6XHNxbFxzaGFyZVxlbmdsaXNoXA0KVEAx
ICAgIDogPG15X2xvYWRfcGF0aA0KVEAxICAgIDogPl9teW1hbGxvYw0KVEAx
ICAgIDogfCBlbnRlcjogU2l6ZTogMzYNClRAMSAgICA6IHwgZXhpdDogcHRy
OiBiMDVlYTANClRAMSAgICA6IDxfbXltYWxsb2MNClRAMSAgICA6ID5fbXlt
YWxsb2MNClRAMSAgICA6IHwgZW50ZXI6IFNpemU6IDM2DQpUQDEgICAgOiB8
IGV4aXQ6IHB0cjogYjA2NWYwDQpUQDEgICAgOiA8X215bWFsbG9jDQpUQDEg
ICAgOiBpbmZvOiBteXNxbGQgIFZlciA0LjAuMTMtbWF4LWRlYnVnIGZvciBX
aW45NS9XaW45OCBvbiBpMzINCg0KVEAxICAgIDogPnNldF9kZWZhdWx0X2No
YXJzZXRfYnlfbmFtZQ0KVEAxICAgIDogfCBlbnRlcjogY2hhcmFjdGVyIHNl
dDogbGF0aW4xDQpUQDEgICAgOiB8ID5pbml0X2R5bmFtaWNfYXJyYXkNClRA
MSAgICA6IHwgfCA+X215bWFsbG9jDQpUQDEgICAgOiB8IHwgfCBlbnRlcjog
U2l6ZTogNjQNClRAMSAgICA6IHwgfCB8IGV4aXQ6IHB0cjogYjA2NzA4DQpU
QDEgICAgOiB8IHwgPF9teW1hbGxvYw0KVEAxICAgIDogfCA8aW5pdF9keW5h
bWljX2FycmF5DQpUQDEgICAgOiB8ID5nZXRfY2hhcnNldHNfZGlyDQpUQDEg
ICAgOiB8IHwgaW5mbzogY2hhcnNldHMgZGlyPSdlOlxzcWxcc2hhcmVcY2hh
cnNldHNcJw0KVEAxICAgIDogfCA8Z2V0X2NoYXJzZXRzX2Rpcg0KVEAxICAg
IDogfCA+bXlfZm9wZW4NClRAMSAgICA6IHwgfCBteTogTmFtZTogJ2U6XHNx
bFxzaGFyZVxjaGFyc2V0c1xJbmRleCcgIEZsYWdzOiAwICBNeUZsYWdzOiAw
DQpUQDEgICAgOiB8IHwgPl9teW1hbGxvYw0KVEAxICAgIDogfCB8IHwgZW50
ZXI6IFNpemU6IDI4DQpUQDEgICAgOiB8IHwgfCBleGl0OiBwdHI6IGIwNWYx
MA0KVEAxICAgIDogfCB8IDxfbXltYWxsb2MNClRAMSAgICA6IHwgfCBleGl0
OiBzdHJlYW06IDc1Y2MxMA0KVEAxICAgIDogfCA8bXlfZm9wZW4NClRAMSAg
ICA6IHwgPmluaXRfZHluYW1pY19hcnJheQ0KVEAxICAgIDogfCB8ID5fbXlt
YWxsb2MNClRAMSAgICA6IHwgfCB8IGVudGVyOiBTaXplOiAxMjgNClRAMSAg
ICA6IHwgfCB8IGV4aXQ6IHB0cjogYjA2NzkwDQpUQDEgICAgOiB8IHwgPF9t
eW1hbGxvYw0KVEAxICAgIDogfCA8aW5pdF9keW5hbWljX2FycmF5DQpUQDEg
ICAgOiB8IHRlc3Q6IG15X29uY2VfbWFsbG9jIDQwNjAgYnl0ZSBtYWxsb2Nl
ZA0KVEAxICAgIDogfCA+bXlfZmNsb3NlDQpUQDEgICAgOiB8IHwgbXk6IHN0
cmVhbTogNzVjYzEwICBNeUZsYWdzOiAwDQpUQDEgICAgOiB8IHwgPl9teWZy
ZWUNClRAMSAgICA6IHwgfCB8IGVudGVyOiBwdHI6IGIwNWYxMA0KVEAxICAg
IDogfCB8IDxfbXlmcmVlDQpUQDEgICAgOiB8IDxteV9mY2xvc2UNClRAMSAg
ICA6IHwgPl9teWZyZWUNClRAMSAgICA6IHwgfCBlbnRlcjogcHRyOiBiMDY3
OTANClRAMSAgICA6IHwgPF9teWZyZWUNClRAMSAgICA6IDxzZXRfZGVmYXVs
dF9jaGFyc2V0X2J5X25hbWUNClRAMSAgICA6ID5pbml0X2R5bmFtaWNfc3Ry
aW5nDQpUQDEgICAgOiB8ID5fbXltYWxsb2MNClRAMSAgICA6IHwgfCBlbnRl
cjogU2l6ZTogMjU2DQpUQDEgICAgOiB8IHwgZXhpdDogcHRyOiBiMDRjMDgN
ClRAMSAgICA6IHwgPF9teW1hbGxvYw0KVEAxICAgIDogPGluaXRfZHluYW1p
Y19zdHJpbmcNClRAMSAgICA6ID5nZXRfY2hhcnNldHNfZGlyDQpUQDEgICAg
OiB8IGluZm86IGNoYXJzZXRzIGRpcj0nZTpcc3FsXHNoYXJlXGNoYXJzZXRz
XCcNClRAMSAgICA6IDxnZXRfY2hhcnNldHNfZGlyDQpUQDEgICAgOiA+bXlf
c3RhdA0KVEAxICAgIDogfCBteTogcGF0aDogJ2U6XHNxbFxzaGFyZVxjaGFy
c2V0c1xkZWM4LmNvbmYnLCBzdGF0X2FyZWE6IDEyZjk1MCwgTXlGbGFnczog
MA0KVEAxICAgIDogPG15X3N0YXQNClRAMSAgICA6ID5nZXRfY2hhcnNldHNf
ZGlyDQpUQDEgICAgOiB8IGluZm86IGNoYXJzZXRzIGRpcj0nZTpcc3FsXHNo
YXJlXGNoYXJzZXRzXCcNClRAMSAgICA6IDxnZXRfY2hhcnNldHNfZGlyDQpU
QDEgICAgOiA+bXlfc3RhdA0KVEAxICAgIDogfCBteTogcGF0aDogJ2U6XHNx
bFxzaGFyZVxjaGFyc2V0c1xkb3MuY29uZicsIHN0YXRfYXJlYTogMTJmOTUw
LCBNeUZsYWdzOiAwDQpUQDEgICAgOiA8bXlfc3RhdA0KVEAxICAgIDogPmdl
dF9jaGFyc2V0c19kaXINClRAMSAgICA6IHwgaW5mbzogY2hhcnNldHMgZGly
PSdlOlxzcWxcc2hhcmVcY2hhcnNldHNcJw0KVEAxICAgIDogPGdldF9jaGFy
c2V0c19kaXINClRAMSAgICA6ID5teV9zdGF0DQpUQDEgICAgOiB8IG15OiBw
YXRoOiAnZTpcc3FsXHNoYXJlXGNoYXJzZXRzXGdlcm1hbjEuY29uZicsIHN0
YXRfYXJlYTogMTJmOTUwLCBNeUZsYWdzOiAwDQpUQDEgICAgOiA8bXlfc3Rh
dA0KVEAxICAgIDogPmdldF9jaGFyc2V0c19kaXINClRAMSAgICA6IHwgaW5m
bzogY2hhcnNldHMgZGlyPSdlOlxzcWxcc2hhcmVcY2hhcnNldHNcJw0KVEAx
ICAgIDogPGdldF9jaGFyc2V0c19kaXINClRAMSAgICA6ID5teV9zdGF0DQpU
QDEgICAgOiB8IG15OiBwYXRoOiAnZTpcc3FsXHNoYXJlXGNoYXJzZXRzXGhw
OC5jb25mJywgc3RhdF9hcmVhOiAxMmY5NTAsIE15RmxhZ3M6IDANClRAMSAg
ICA6IDxteV9zdGF0DQpUQDEgICAgOiA+Z2V0X2NoYXJzZXRzX2Rpcg0KVEAx
ICAgIDogfCBpbmZvOiBjaGFyc2V0cyBkaXI9J2U6XHNxbFxzaGFyZVxjaGFy
c2V0c1wnDQpUQDEgICAgOiA8Z2V0X2NoYXJzZXRzX2Rpcg0KVEAxICAgIDog
Pm15X3N0YXQNClRAMSAgICA6IHwgbXk6IHBhdGg6ICdlOlxzcWxcc2hhcmVc
Y2hhcnNldHNca29pOF9ydS5jb25mJywgc3RhdF9hcmVhOiAxMmY5NTAsIE15
RmxhZ3M6IDANClRAMSAgICA6IDxteV9zdGF0DQpUQDEgICAgOiA+Z2V0X2No
YXJzZXRzX2Rpcg0KVEAxICAgIDogfCBpbmZvOiBjaGFyc2V0cyBkaXI9J2U6
XHNxbFxzaGFyZVxjaGFyc2V0c1wnDQpUQDEgICAgOiA8Z2V0X2NoYXJzZXRz
X2Rpcg0KVEAxICAgIDogPm15X3N0YXQNClRAMSAgICA6IHwgbXk6IHBhdGg6
ICdlOlxzcWxcc2hhcmVcY2hhcnNldHNcbGF0aW4yLmNvbmYnLCBzdGF0X2Fy
ZWE6IDEyZjk1MCwgTXlGbGFnczogMA0KVEAxICAgIDogPG15X3N0YXQNClRA
MSAgICA6ID5nZXRfY2hhcnNldHNfZGlyDQpUQDEgICAgOiB8IGluZm86IGNo
YXJzZXRzIGRpcj0nZTpcc3FsXHNoYXJlXGNoYXJzZXRzXCcNClRAMSAgICA6
IDxnZXRfY2hhcnNldHNfZGlyDQpUQDEgICAgOiA+bXlfc3RhdA0KVEAxICAg
IDogfCBteTogcGF0aDogJ2U6XHNxbFxzaGFyZVxjaGFyc2V0c1xzd2U3LmNv
bmYnLCBzdGF0X2FyZWE6IDEyZjk1MCwgTXlGbGFnczogMA0KVEAxICAgIDog
PG15X3N0YXQNClRAMSAgICA6ID5nZXRfY2hhcnNldHNfZGlyDQpUQDEgICAg
OiB8IGluZm86IGNoYXJzZXRzIGRpcj0nZTpcc3FsXHNoYXJlXGNoYXJzZXRz
XCcNClRAMSAgICA6IDxnZXRfY2hhcnNldHNfZGlyDQpUQDEgICAgOiA+bXlf
c3RhdA0KVEAxICAgIDogfCBteTogcGF0aDogJ2U6XHNxbFxzaGFyZVxjaGFy
c2V0c1x1c2E3LmNvbmYnLCBzdGF0X2FyZWE6IDEyZjk1MCwgTXlGbGFnczog
MA0KVEAxICAgIDogPG15X3N0YXQNClRAMSAgICA6ID5nZXRfY2hhcnNldHNf
ZGlyDQpUQDEgICAgOiB8IGluZm86IGNoYXJzZXRzIGRpcj0nZTpcc3FsXHNo
YXJlXGNoYXJzZXRzXCcNClRAMSAgICA6IDxnZXRfY2hhcnNldHNfZGlyDQpU
QDEgICAgOiA+bXlfc3RhdA0KVEAxICAgIDogfCBteTogcGF0aDogJ2U6XHNx
bFxzaGFyZVxjaGFyc2V0c1xjcDEyNTEuY29uZicsIHN0YXRfYXJlYTogMTJm
OTUwLCBNeUZsYWdzOiAwDQpUQDEgICAgOiA8bXlfc3RhdA0KVEAxICAgIDog
PmdldF9jaGFyc2V0c19kaXINClRAMSAgICA6IHwgaW5mbzogY2hhcnNldHMg
ZGlyPSdlOlxzcWxcc2hhcmVcY2hhcnNldHNcJw0KVEAxICAgIDogPGdldF9j
aGFyc2V0c19kaXINClRAMSAgICA6ID5teV9zdGF0DQpUQDEgICAgOiB8IG15
OiBwYXRoOiAnZTpcc3FsXHNoYXJlXGNoYXJzZXRzXGRhbmlzaC5jb25mJywg
c3RhdF9hcmVhOiAxMmY5NTAsIE15RmxhZ3M6IDANClRAMSAgICA6IDxteV9z
dGF0DQpUQDEgICAgOiA+Z2V0X2NoYXJzZXRzX2Rpcg0KVEAxICAgIDogfCBp
bmZvOiBjaGFyc2V0cyBkaXI9J2U6XHNxbFxzaGFyZVxjaGFyc2V0c1wnDQpU
QDEgICAgOiA8Z2V0X2NoYXJzZXRzX2Rpcg0KVEAxICAgIDogPm15X3N0YXQN
ClRAMSAgICA6IHwgbXk6IHBhdGg6ICdlOlxzcWxcc2hhcmVcY2hhcnNldHNc
aGVicmV3LmNvbmYnLCBzdGF0X2FyZWE6IDEyZjk1MCwgTXlGbGFnczogMA0K
VEAxICAgIDogPG15X3N0YXQNClRAMSAgICA6ID5nZXRfY2hhcnNldHNfZGly
DQpUQDEgICAgOiB8IGluZm86IGNoYXJzZXRzIGRpcj0nZTpcc3FsXHNoYXJl
XGNoYXJzZXRzXCcNClRAMSAgICA6IDxnZXRfY2hhcnNldHNfZGlyDQpUQDEg
ICAgOiA+bXlfc3RhdA0KVEAxICAgIDogfCBteTogcGF0aDogJ2U6XHNxbFxz
aGFyZVxjaGFyc2V0c1x3aW4xMjUxLmNvbmYnLCBzdGF0X2FyZWE6IDEyZjk1
MCwgTXlGbGFnczogMA0KVEAxICAgIDogPG15X3N0YXQNClRAMSAgICA6ID5n
ZXRfY2hhcnNldHNfZGlyDQpUQDEgICAgOiB8IGluZm86IGNoYXJzZXRzIGRp
cj0nZTpcc3FsXHNoYXJlXGNoYXJzZXRzXCcNClRAMSAgICA6IDxnZXRfY2hh
cnNldHNfZGlyDQpUQDEgICAgOiA+bXlfc3RhdA0KVEAxICAgIDogfCBteTog
cGF0aDogJ2U6XHNxbFxzaGFyZVxjaGFyc2V0c1xlc3RvbmlhLmNvbmYnLCBz
dGF0X2FyZWE6IDEyZjk1MCwgTXlGbGFnczogMA0KVEAxICAgIDogPG15X3N0
YXQNClRAMSAgICA6ID5nZXRfY2hhcnNldHNfZGlyDQpUQDEgICAgOiB8IGlu
Zm86IGNoYXJzZXRzIGRpcj0nZTpcc3FsXHNoYXJlXGNoYXJzZXRzXCcNClRA
MSAgICA6IDxnZXRfY2hhcnNldHNfZGlyDQpUQDEgICAgOiA+bXlfc3RhdA0K
VEAxICAgIDogfCBteTogcGF0aDogJ2U6XHNxbFxzaGFyZVxjaGFyc2V0c1xo
dW5nYXJpYW4uY29uZicsIHN0YXRfYXJlYTogMTJmOTUwLCBNeUZsYWdzOiAw
DQpUQDEgICAgOiA8bXlfc3RhdA0KVEAxICAgIDogPmdldF9jaGFyc2V0c19k
aXINClRAMSAgICA6IHwgaW5mbzogY2hhcnNldHMgZGlyPSdlOlxzcWxcc2hh
cmVcY2hhcnNldHNcJw0KVEAxICAgIDogPGdldF9jaGFyc2V0c19kaXINClRA
MSAgICA6ID5teV9zdGF0DQpUQDEgICAgOiB8IG15OiBwYXRoOiAnZTpcc3Fs
XHNoYXJlXGNoYXJzZXRzXGtvaThfdWtyLmNvbmYnLCBzdGF0X2FyZWE6IDEy
Zjk1MCwgTXlGbGFnczogMA0KVEAxICAgIDogPG15X3N0YXQNClRAMSAgICA6
ID5nZXRfY2hhcnNldHNfZGlyDQpUQDEgICAgOiB8IGluZm86IGNoYXJzZXRz
IGRpcj0nZTpcc3FsXHNoYXJlXGNoYXJzZXRzXCcNClRAMSAgICA6IDxnZXRf
Y2hhcnNldHNfZGlyDQpUQDEgICAgOiA+bXlfc3RhdA0KVEAxICAgIDogfCBt
eTogcGF0aDogJ2U6XHNxbFxzaGFyZVxjaGFyc2V0c1x3aW4xMjUxdWtyLmNv
bmYnLCBzdGF0X2FyZWE6IDEyZjk1MCwgTXlGbGFnczogMA0KVEAxICAgIDog
PG15X3N0YXQNClRAMSAgICA6ID5nZXRfY2hhcnNldHNfZGlyDQpUQDEgICAg
OiB8IGluZm86IGNoYXJzZXRzIGRpcj0nZTpcc3FsXHNoYXJlXGNoYXJzZXRz
XCcNClRAMSAgICA6IDxnZXRfY2hhcnNldHNfZGlyDQpUQDEgICAgOiA+bXlf
c3RhdA0KVEAxICAgIDogfCBteTogcGF0aDogJ2U6XHNxbFxzaGFyZVxjaGFy
c2V0c1xncmVlay5jb25mJywgc3RhdF9hcmVhOiAxMmY5NTAsIE15RmxhZ3M6
IDANClRAMSAgICA6IDxteV9zdGF0DQpUQDEgICAgOiA+Z2V0X2NoYXJzZXRz
X2Rpcg0KVEAxICAgIDogfCBpbmZvOiBjaGFyc2V0cyBkaXI9J2U6XHNxbFxz
aGFyZVxjaGFyc2V0c1wnDQpUQDEgICAgOiA8Z2V0X2NoYXJzZXRzX2Rpcg0K
VEAxICAgIDogPm15X3N0YXQNClRAMSAgICA6IHwgbXk6IHBhdGg6ICdlOlxz
cWxcc2hhcmVcY2hhcnNldHNcd2luMTI1MC5jb25mJywgc3RhdF9hcmVhOiAx
MmY5NTAsIE15RmxhZ3M6IDANClRAMSAgICA6IDxteV9zdGF0DQpUQDEgICAg
OiA+Z2V0X2NoYXJzZXRzX2Rpcg0KVEAxICAgIDogfCBpbmZvOiBjaGFyc2V0
cyBkaXI9J2U6XHNxbFxzaGFyZVxjaGFyc2V0c1wnDQpUQDEgICAgOiA8Z2V0
X2NoYXJzZXRzX2Rpcg0KVEAxICAgIDogPm15X3N0YXQNClRAMSAgICA6IHwg
bXk6IHBhdGg6ICdlOlxzcWxcc2hhcmVcY2hhcnNldHNcY3JvYXQuY29uZics
IHN0YXRfYXJlYTogMTJmOTUwLCBNeUZsYWdzOiAwDQpUQDEgICAgOiA8bXlf
c3RhdA0KVEAxICAgIDogPmdldF9jaGFyc2V0c19kaXINClRAMSAgICA6IHwg
aW5mbzogY2hhcnNldHMgZGlyPSdlOlxzcWxcc2hhcmVcY2hhcnNldHNcJw0K
VEAxICAgIDogPGdldF9jaGFyc2V0c19kaXINClRAMSAgICA6ID5teV9zdGF0
DQpUQDEgICAgOiB8IG15OiBwYXRoOiAnZTpcc3FsXHNoYXJlXGNoYXJzZXRz
XGNwMTI1Ny5jb25mJywgc3RhdF9hcmVhOiAxMmY5NTAsIE15RmxhZ3M6IDAN
ClRAMSAgICA6IDxteV9zdGF0DQpUQDEgICAgOiA+Z2V0X2NoYXJzZXRzX2Rp
cg0KVEAxICAgIDogfCBpbmZvOiBjaGFyc2V0cyBkaXI9J2U6XHNxbFxzaGFy
ZVxjaGFyc2V0c1wnDQpUQDEgICAgOiA8Z2V0X2NoYXJzZXRzX2Rpcg0KVEAx
ICAgIDogPm15X3N0YXQNClRAMSAgICA6IHwgbXk6IHBhdGg6ICdlOlxzcWxc
c2hhcmVcY2hhcnNldHNcbGF0aW41LmNvbmYnLCBzdGF0X2FyZWE6IDEyZjk1
MCwgTXlGbGFnczogMA0KVEAxICAgIDogPG15X3N0YXQNClRAMSAgICA6ID5f
bXltYWxsb2MNClRAMSAgICA6IHwgZW50ZXI6IFNpemU6IDIxMA0KVEAxICAg
IDogfCBleGl0OiBwdHI6IGIwNGQ1MA0KVEAxICAgIDogPF9teW1hbGxvYw0K
VEAxICAgIDogPl9teWZyZWUNClRAMSAgICA6IHwgZW50ZXI6IHB0cjogYjA0
YzA4DQpUQDEgICAgOiA8X215ZnJlZQ0KVEAxICAgIDogPnVuaXJlZ19pbml0
DQpUQDEgICAgOiB8ID5jYWxjX2RheW5yDQpUQDEgICAgOiB8IHwgZXhpdDog
eWVhcjogMjAwMyAgbW9udGg6IDcgIGRheTogMTUgLT4gZGF5bnI6IDczMTc3
Ng0KVEAxICAgIDogfCA8Y2FsY19kYXlucg0KVEAxICAgIDogPHVuaXJlZ19p
bml0DQpUQDEgICAgOiA+aW5pdF9lcnJtZXNzYWdlDQpUQDEgICAgOiB8ID5y
ZWFkX3RleHRzDQpUQDEgICAgOiB8IHwgPmZuX2Zvcm1hdA0KVEAxICAgIDog
fCB8IHwgZW50ZXI6IG5hbWU6IGVycm1zZy5zeXMgIGRpcjogZTpcc3FsXHNo
YXJlXGVuZ2xpc2hcICBleHRlbnNpb246ICAgZmxhZzogNA0KVEAxICAgIDog
fCB8IHwgPmRpcm5hbWVfcGFydA0KVEAxICAgIDogfCB8IHwgfCBlbnRlcjog
J2Vycm1zZy5zeXMnDQpUQDEgICAgOiB8IHwgfCA8ZGlybmFtZV9wYXJ0DQpU
QDEgICAgOiB8IHwgfCA+dW5wYWNrX2Rpcm5hbWUNClRAMSAgICA6IHwgfCB8
IHwgPmRpcm5hbWVfcGFydA0KVEAxICAgIDogfCB8IHwgfCB8IGVudGVyOiAn
ZTpcc3FsXHNoYXJlXGVuZ2xpc2hcJw0KVEAxICAgIDogfCB8IHwgfCA8ZGly
bmFtZV9wYXJ0DQpUQDEgICAgOiB8IHwgfCB8ID5jbGVhbnVwX2Rpcm5hbWUN
ClRAMSAgICA6IHwgfCB8IHwgfCBlbnRlcjogZnJvbTogJ2U6XHNxbFxzaGFy
ZVxlbmdsaXNoXCcNClRAMSAgICA6IHwgfCB8IHwgfCBleGl0OiB0bzogJ2U6
XHNxbFxzaGFyZVxlbmdsaXNoXCcNClRAMSAgICA6IHwgfCB8IHwgPGNsZWFu
dXBfZGlybmFtZQ0KVEAxICAgIDogfCB8IHwgPHVucGFja19kaXJuYW1lDQpU
QDEgICAgOiB8IHwgfCA+c3RybGVuZ3RoDQpUQDEgICAgOiB8IHwgfCA8c3Ry
bGVuZ3RoDQpUQDEgICAgOiB8IHwgPGZuX2Zvcm1hdA0KVEAxICAgIDogfCB8
ID5teV9vcGVuDQpUQDEgICAgOiB8IHwgfCBteTogTmFtZTogJ2U6XHNxbFxz
aGFyZVxlbmdsaXNoXGVycm1zZy5zeXMnICBGbGFnczogMzY4NjQgIE15Rmxh
Z3M6IDANClRAMSAgICA6IHwgfCA8bXlfb3Blbg0KVEAxICAgIDogfCB8ID5f
bXltYWxsb2MNClRAMSAgICA6IHwgfCB8IGVudGVyOiBTaXplOiAzMg0KVEAx
ICAgIDogfCB8IHwgZXhpdDogcHRyOiBiMDVmMTANClRAMSAgICA6IHwgfCA8
X215bWFsbG9jDQpUQDEgICAgOiB8IHwgZXhpdDogZmQ6IDQNClRAMSAgICA6
IHwgfCA+bXlfcmVhZA0KVEAxICAgIDogfCB8IHwgbXk6IEZkOiA0ICBCdWZm
ZXI6IDEyZjhlOCAgQ291bnQ6IDMyICBNeUZsYWdzOiA0DQpUQDEgICAgOiB8
IHwgPG15X3JlYWQNClRAMSAgICA6IHwgfCA+X215ZnJlZQ0KVEAxICAgIDog
fCB8IHwgZW50ZXI6IHB0cjogMA0KVEAxICAgIDogfCB8IDxfbXlmcmVlDQpU
QDEgICAgOiB8IHwgPl9teW1hbGxvYw0KVEAxICAgIDogfCB8IHwgZW50ZXI6
IFNpemU6IDEyODk1DQpUQDEgICAgOiB8IHwgfCBleGl0OiBwdHI6IGIwNzg2
MA0KVEAxICAgIDogfCB8IDxfbXltYWxsb2MNClRAMSAgICA6IHwgfCA+bXlf
cmVhZA0KVEAxICAgIDogfCB8IHwgbXk6IEZkOiA0ICBCdWZmZXI6IGIwN2Mx
NCAgQ291bnQ6IDQ3NCAgTXlGbGFnczogNA0KVEAxICAgIDogfCB8IDxteV9y
ZWFkDQpUQDEgICAgOiB8IHwgPm15X3JlYWQNClRAMSAgICA6IHwgfCB8IG15
OiBGZDogNCAgQnVmZmVyOiBiMDdjMTQgIENvdW50OiAxMTk0NyAgTXlGbGFn
czogNA0KVEAxICAgIDogfCB8IDxteV9yZWFkDQpUQDEgICAgOiB8IHwgPm15
X2Nsb3NlDQpUQDEgICAgOiB8IHwgfCBteTogZmQ6IDQgIE15RmxhZ3M6IDAN
ClRAMSAgICA6IHwgfCB8ID5fbXlmcmVlDQpUQDEgICAgOiB8IHwgfCB8IGVu
dGVyOiBwdHI6IGIwNWYxMA0KVEAxICAgIDogfCB8IHwgPF9teWZyZWUNClRA
MSAgICA6IHwgfCA8bXlfY2xvc2UNClRAMSAgICA6IHwgPHJlYWRfdGV4dHMN
ClRAMSAgICA6IDxpbml0X2Vycm1lc3NhZ2UNClRAMSAgICA6ID5sZXhfaW5p
dA0KVEAxICAgIDogPGxleF9pbml0DQpUQDEgICAgOiA+aGFzaF9pbml0DQpU
QDEgICAgOiB8IGVudGVyOiBoYXNoOiA3NWRmZjggIHNpemU6IDE2DQpUQDEg
ICAgOiB8ID5pbml0X2R5bmFtaWNfYXJyYXkNClRAMSAgICA6IHwgfCA+X215
bWFsbG9jDQpUQDEgICAgOiB8IHwgfCBlbnRlcjogU2l6ZTogMTI4DQpUQDEg
ICAgOiB8IHwgfCBleGl0OiBwdHI6IGIwNjc5MA0KVEAxICAgIDogfCB8IDxf
bXltYWxsb2MNClRAMSAgICA6IHwgPGluaXRfZHluYW1pY19hcnJheQ0KVEAx
ICAgIDogPGhhc2hfaW5pdA0KVEAxICAgIDogPmhhc2hfaW5pdA0KVEAxICAg
IDogfCBlbnRlcjogaGFzaDogNzYxMTQ4ICBzaXplOiA4MQ0KVEAxICAgIDog
fCA+aW5pdF9keW5hbWljX2FycmF5DQpUQDEgICAgOiB8IHwgPl9teW1hbGxv
Yw0KVEAxICAgIDogfCB8IHwgZW50ZXI6IFNpemU6IDY0OA0KVEAxICAgIDog
fCB8IHwgZXhpdDogcHRyOiBiMDRlNzANClRAMSAgICA6IHwgfCA8X215bWFs
bG9jDQpUQDEgICAgOiB8IDxpbml0X2R5bmFtaWNfYXJyYXkNClRAMSAgICA6
IDxoYXNoX2luaXQNClRAMSAgICA6ID5fbXltYWxsb2MNClRAMSAgICA6IHwg
ZW50ZXI6IFNpemU6IDEyOA0KVEAxICAgIDogfCBleGl0OiBwdHI6IGIwNTU0
OA0KVEAxICAgIDogPF9teW1hbGxvYw0KVEAxICAgIDogPm15X3NldHdkDQpU
QDEgICAgOiB8IG15OiBkaXI6ICdlOlxzcWxcZGF0YVwnICBNeUZsYWdzIDE2
DQpUQDEgICAgOiA8bXlfc2V0d2QNClRAMSAgICA6ID5zZXJ2ZXJfaW5pdA0K
VEAxICAgIDogfCBnZW5lcmFsOiBJUCBTb2NrZXQgaXMgMzMwNg0KVEAxICAg
IDogfCBpbmZvOiBzZXJ2ZXIgc3RhcnRlZA0KVEAxICAgIDogPHNlcnZlcl9p
bml0DQpUQDEgICAgOiA+aGFzaF9pbml0DQpUQDEgICAgOiB8IGVudGVyOiBo
YXNoOiA3NjFkYTggIHNpemU6IDIwDQpUQDEgICAgOiB8ID5pbml0X2R5bmFt
aWNfYXJyYXkNClRAMSAgICA6IHwgfCA+X215bWFsbG9jDQpUQDEgICAgOiB8
IHwgfCBlbnRlcjogU2l6ZTogMTYwDQpUQDEgICAgOiB8IHwgfCBleGl0OiBw
dHI6IGIwNTYxMA0KVEAxICAgIDogfCB8IDxfbXltYWxsb2MNClRAMSAgICA6
IHwgPGluaXRfZHluYW1pY19hcnJheQ0KVEAxICAgIDogPGhhc2hfaW5pdA0K
VEAxICAgIDogPm15c3FsX3JtX3RtcF90YWJsZXMNClRAMSAgICA6IHwgPm15
X2Rpcg0KVEAxICAgIDogfCB8IG15OiBwYXRoOiAnQzpcRE9DVU1FfjFcQkNI
QVBNfjFcTE9DQUxTfjFcVGVtcFwnIHN0YXQ6IDUyOCAgTXlGbGFnczogMTY4
NDM2NjQ0Ng0KVEAxICAgIDogfCB8ID5fbXltYWxsb2MNClRAMSAgICA6IHwg
fCB8IGVudGVyOiBTaXplOiAzMjQ4MA0KVEAxICAgIDogfCB8IHwgZXhpdDog
cHRyOiBmNDAwODANClRAMSAgICA6IHwgfCA8X215bWFsbG9jDQpUQDEgICAg
OiB8IHwgdGVzdDogZW9mOiAtMSAgZXJybm86IDINClRAMSAgICA6IHwgPG15
X2Rpcg0KVEAxICAgIDogfCA+bXlfZGlyZW5kDQpUQDEgICAgOiB8IHwgPl9t
eWZyZWUNClRAMSAgICA6IHwgfCB8IGVudGVyOiBwdHI6IGY0MDA4MA0KVEAx
ICAgIDogfCB8IDxfbXlmcmVlDQpUQDEgICAgOiB8IDxteV9kaXJlbmQNClRA
MSAgICA6IDxteXNxbF9ybV90bXBfdGFibGVzDQpUQDEgICAgOiA+aGFzaF9m
cmVlDQpUQDEgICAgOiA8aGFzaF9mcmVlDQpUQDEgICAgOiA+aGFzaF9pbml0
DQpUQDEgICAgOiB8IGVudGVyOiBoYXNoOiBiMDU3MTggIHNpemU6IDEyOA0K
VEAxICAgIDogfCA+aW5pdF9keW5hbWljX2FycmF5DQpUQDEgICAgOiB8IHwg
Pl9teW1hbGxvYw0KVEAxICAgIDogfCB8IHwgZW50ZXI6IFNpemU6IDEwMjQN
ClRAMSAgICA6IHwgfCB8IGV4aXQ6IHB0cjogYjA1Nzk4DQpUQDEgICAgOiB8
IHwgPF9teW1hbGxvYw0KVEAxICAgIDogfCA8aW5pdF9keW5hbWljX2FycmF5
DQpUQDEgICAgOiA8aGFzaF9pbml0DQpUQDEgICAgOiA+UXVlcnlfY2FjaGU6
OnJlc2l6ZQ0KVEAxICAgIDogfCBxY2FjaGU6IGZyb20gMCB0byAwDQpUQDEg
ICAgOiB8ID5RdWVyeV9jYWNoZTo6ZnJlZV9jYWNoZQ0KVEAxICAgIDogfCA8
UXVlcnlfY2FjaGU6OmZyZWVfY2FjaGUNClRAMSAgICA6IDxRdWVyeV9jYWNo
ZTo6cmVzaXplDQpUQDEgICAgOiA+UXVlcnlfY2FjaGU6OmluaXRfY2FjaGUN
ClRAMSAgICA6IHwgPlF1ZXJ5X2NhY2hlOjppbml0DQpUQDEgICAgOiB8IDxR
dWVyeV9jYWNoZTo6aW5pdA0KVEAxICAgIDogfCA+UXVlcnlfY2FjaGU6Om1h
a2VfZGlzYWJsZWQNClRAMSAgICA6IHwgPFF1ZXJ5X2NhY2hlOjptYWtlX2Rp
c2FibGVkDQpUQDEgICAgOiA8UXVlcnlfY2FjaGU6OmluaXRfY2FjaGUNClRA
MSAgICA6ID5oYXNoX2luaXQNClRAMSAgICA6IHwgZW50ZXI6IGhhc2g6IDc2
MTBmMCAgc2l6ZTogMTI4DQpUQDEgICAgOiB8ID5pbml0X2R5bmFtaWNfYXJy
YXkNClRAMSAgICA6IHwgfCA+X215bWFsbG9jDQpUQDEgICAgOiB8IHwgfCBl
bnRlcjogU2l6ZTogMTAyNA0KVEAxICAgIDogfCB8IHwgZXhpdDogcHRyOiBi
MGFiMDgNClRAMSAgICA6IHwgfCA8X215bWFsbG9jDQpUQDEgICAgOiB8IDxp
bml0X2R5bmFtaWNfYXJyYXkNClRAMSAgICA6IDxoYXNoX2luaXQNClRAMSAg
ICA6ID5mbl9mb3JtYXQNClRAMSAgICA6IHwgZW50ZXI6IG5hbWU6IDExOTE5
LTYgIGRpcjogLiAgZXh0ZW5zaW9uOiAuZXJyICBmbGFnOiAwDQpUQDEgICAg
OiB8ID5kaXJuYW1lX3BhcnQNClRAMSAgICA6IHwgfCBlbnRlcjogJzExOTE5
LTYnDQpUQDEgICAgOiB8IDxkaXJuYW1lX3BhcnQNClRAMSAgICA6IHwgPnN0
cmxlbmd0aA0KVEAxICAgIDogfCA8c3RybGVuZ3RoDQpUQDEgICAgOiA8Zm5f
Zm9ybWF0DQpUQDEgICAgOiA+YmVya2VsZXlfaW5pdA0KVEAxICAgIDogfCBi
ZGI6IGJlcmtlbGV5X2hvbWU6IGU6XHNxbFxkYXRhXA0KVEAxICAgIDogfCA+
aGFzaF9pbml0DQpUQDEgICAgOiB8IHwgZW50ZXI6IGhhc2g6IDc1ZGU2MCAg
c2l6ZTogMzINClRAMSAgICA6IHwgfCA+aW5pdF9keW5hbWljX2FycmF5DQpU
QDEgICAgOiB8IHwgfCA+X215bWFsbG9jDQpUQDEgICAgOiB8IHwgfCB8IGVu
dGVyOiBTaXplOiAyNTYNClRAMSAgICA6IHwgfCB8IHwgZXhpdDogcHRyOiBi
MGI5ZTANClRAMSAgICA6IHwgfCB8IDxfbXltYWxsb2MNClRAMSAgICA6IHwg
fCA8aW5pdF9keW5hbWljX2FycmF5DQpUQDEgICAgOiB8IDxoYXNoX2luaXQN
ClRAMSAgICA6IDxiZXJrZWxleV9pbml0DQpUQDEgICAgOiA+aW5ub2Jhc2Vf
aW5pdA0KVEAxICAgIDogfCA+X215bWFsbG9jDQpUQDEgICAgOiB8IHwgZW50
ZXI6IFNpemU6IDE1DQpUQDEgICAgOiB8IHwgZXhpdDogcHRyOiBiMGJiMjgN
ClRAMSAgICA6IHwgPF9teW1hbGxvYw0K


--_----------=_105830766036660
Content-Type: text/plain; charset=us-ascii

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org
--_----------=_105830766036660--

Re: MySql 4.0.13 Doesn"t Work for me

am 21.07.2003 07:34:54 von miguel solorzano

At 14:21 15/7/2003 -0800, blakech@fastmail.fm wrote:
Hi,


>I downloaded MySql 4.0.13 for windows, unzipped it, installed it, and
>tried starting it up using "mysqld --standalone". It executes but
>doesn't load. This is on a computer running Windows 2000 Professional. I
>put your software on a zip drive, 100 MB. I set the appropriate options
>to reflect this in c:winnt/my.ini.
> Each time I execute the server with
>"mysqld --standalone" it deposits an error message in a file with an
>extension .err in my data directory, in which there is a message saying
>it could not write some file like ibdata1;

This is an expected behavior of 4.0.XX server when the data file and its
log files not exist:

Microsoft Windows 2000 [Vers=E3o 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.

c:\mysql\bin>mysqld-nt --standalone --console
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
030721 2:19:19 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
030721 2:19:21 InnoDB: Log file .\ib_logfile0 did not exist: new to be=20
created

InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
030721 2:19:22 InnoDB: Log file .\ib_logfile1 did not exist: new to be=20
created

InnoDB: Setting log file .\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
030721 2:19:29 InnoDB: Started
mysqld-nt: ready for connections.
Version: '4.0.13-nt' socket: '' port: 3306

If you don't want the InnoDB table engine you need to provide
either in the command line start or in the \winnt\my.ini file
the option --skip-innodb:

c:\mysql\bin>mysqld-nt --standalone --console --skip-innodb
mysqld-nt: ready for connections.
Version: '4.0.13-nt' socket: '' port: 3306


> I don't remember the exact
>name. That file is also in the data directory, but 0 bytes long. I
>cannot give you this .err file because I subsequently deleted the error
>file and all the expanded, installed mysql software files (after spending
>an hour trying to get it to work), and only then looked on your website
>to find where I could report the problem to you. However, I recall that
>the .err file included error message #112, saying disk is full, but the
>disk is NOT full, there is 38 meg of space left (on the zip drive).

You can notice above that InnoDB tries to build 3 files with a size of
10+5+5 MB and probably the 38 MB you have free aren't enough for to
create them. If you don't need InnoDB then disable it like I showed
above.

> It
>says it is trying to write a 10 MB file but is only writing 0 bytes. I
>am sure there is 38 meg left. I created the my.ini file from your sample
>my-small.cnf. In the my.ini file, I first tried NOT including the Innodb
>options in the .ini file, then I included them (using 10MB as the size of
>the dbdata1 file - or whatever it was called). It does not work in
>either case.

Notice that in this case you need to create manually the directories
where InnoDB will create the data/logs files.

> I also tried placing that the file on C: drive, and it
>didn't work. Very frustrating day. mysqld never installed itself, as
>demonstrated by using mysqlshow. I ran mysqld once with the --debug
>option, and a trace file was made. I do not see anything significant
>pertinent to the problem in the trace file, but I have attached it in
>case you can find something in there. Note that I have used 2 earlier
>versions of mysql successfully. So I am going back to the previous
>version. A further comment on that - the FIRST version of Mysql I used
>allowed me to install and run it from a drive OTHER THAN C:.

You need to provide the below start options:

basedir=3Dyour_install_directory
datadir=3Dyour_data_directory

> The next
>version, 3.23 I believe it was, would NOT let me do that. I don't like
>this. I was hoping this would be fixed in 4.01.

You can use 4.0.13 on any place like the older versions, you only
need to care for to provide the datadir, basedir start options
either from the command line or in your configuration file.


--=20
Regards,

For technical support contracts, visit https://order.mysql.com/
Are you MySQL certified?, http://www.mysql.com/certification/

Miguel Angel Sol=F3rzano
S=E3o Paulo - Brazil


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=3Dgcdmb-bugs@m.gmane.org