Как запустить mysql через командную строку?

Question

[Денис]

выводит сообщение: Системная ошибка 1067.

у меня установлен Денвер..так же установил службу через командную строку :
"C:\WebServers\usr\local\mysql-5.5\bin\mysqld" --install "mysqld" defaults-file="C:\WebServers\usr\local\mysql-5.5\my.ini"...
Служба была успешно установлена, но при запуске выводит сообщение: "Системная ошибка. Системная ошибка 1067. Процесс был неожиданно завершен." Как это можно побороть?

вот что было в логах:
150818 0:01:11 [Note] Plugin 'FEDERATED' is disabled.
150818 0:01:11 InnoDB: The InnoDB memory heap is disabled
150818 0:01:11 InnoDB: Mutexes and rw_locks use Windows interlocked functions
150818 0:01:11 InnoDB: Compressed tables use zlib 1.2.3
150818 0:01:11 InnoDB: Error: unable to create temporary file; errno: 2
150818 0:01:11 [ERROR] Plugin 'InnoDB' init function returned error.
150818 0:01:11 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
150818 0:01:11 [ERROR] Unknown/unsupported storage engine: InnoDB
150818 0:01:11 [ERROR] Aborting

150818 0:01:11 [Note] C:\WebServers\usr\local\mysql-5.5\bin\mysqld: Shutdown complete

вот основные настройки в файле my.ini:
[client]
port = 3306
socket = /tmp/mysql5.sock
character-sets-dir = /usr/local/mysql-5.5/share/charsets

# Êîäèðîâêà êîíñîëè mysql.exe ïî óìîë÷àíèþ.
default-character-set = cp1251

# The MySQL server
[mysqld]
basedir=C:\\WebServers\\usr\\local\\mysql-5.5
datadir=C:\\WebServers\\usr\\local\\mysql-5.5\\data
# Îáðàáîòûâàòü çàïðîñû ÒÎËÜÊÎ ñ ëîêàëüíîé ìàøèíû (ïîâûøàåò áåçîïàñíîñòü).
# Åñëè âû õîòèòå, ÷òîáû MySQL-ñåðâåð áûë äîñòóïåí èç ñåòè,
# óáåðèòå ñëåäóþùóþ íèæå äèðåêòèâó.
bind-address = 127.0.0.1
port = 3306

# Âíóòðåííÿÿ êîäèðîâêà òàáëèö íà ñåðâåðå.
character-set-server = utf8

# Êîäèðîâêà êëèåíòà ïî óìîë÷àíèþ (ïðåîáðàçîâàíèå èç cp1251 â utf8 è îáðàòíî
# ïðîèñõîäèò àâòîìàòè÷åñêè).
init-connect = "set names cp1251"

tmpdir = /tmp
socket = /tmp/mysql.sock
skip-external-locking
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 128K

#skip-networking
server-id = 1

# Uncomment the following if you want to log updates
#log-bin=mysql-bin

# binary logging format - mixed recommended
#binlog_format=mixed

# Causes updates to non-transactional engines using statement format to be
# written directly to binary log. Before using this option make sure that
# there are no dependencies between transactional and non-transactional
# tables such as in the statement INSERT INTO t_myisam SELECT * FROM
# t_innodb; otherwise, slaves may diverge from the master.
#binlog_direct_non_transactional_updates=TRUE

# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = C:\\mysql\\data\\
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = C:\\mysql\\data\\
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 16M
#innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 5M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[myisamchk]
key_buffer_size = 8M
sort_buffer_size = 8M

[mysqlhotcopy]
interactive-timeout

Answer 1

[Rsa97]

tmpdir = /tmp
socket = /tmp/mysql.sock

Попробуйте найти в Windows такие пути.