Ошибка Навикат Помогите Плз

[spirit2011 2]

Люди создаю так как сказано: 1) Открывам navicat;

2) Создаём базу данных l2jr;

3) Открываем его и видим раздел "Backups";

4) Открываем этот раздел и переносим туда файл .psc ;

5) Там появляется сам бекап;

6) Жмём на его 2 раза и жмём старт;

И начинается заливка базы данных.

а у меня ошибка [Msg] Decompressing...

[Msg] 1289 - The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working

[Msg] Importing Data...

[Msg] Finished - Stopped before completion

--------------------------------------------------

Розкажите плз как убрать проблему поточнеє)

http://s010.radikal.ru/i311/1105/05/ba4c13d3cafe.png

[anngray 0]

you need MySQL built with 'InnoDB' to have it working

запусти мускул с поддержкой'InnoDB'

[spirit2011 2]

как ето? можеш поточнеє! я вобщето устанавливал аппсервер) можеш помоч мой скайп o_o_spirit аська 612544828

[anngray 0]

посмотри тут

[spirit2011 2]

дай свой скайп или асю плз помоги)

[anngray 0]

проверь my.ini на наличие этих строк

 

# Uncomment the following if you are using InnoDB tables

#skip-innodb

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

 

Пути могут отличатся

[spirit2011 2]

у меня етих строк вобще нету)

[spirit2011 2]

#*** INNODB Specific options ***

 

 

# Use this option if you have a MySQL server with InnoDB support enabled

# but you do not plan to use it. This will save memory and disk space

# and speed up some things.

skip-innodb

 

# Additional memory pool that is used by InnoDB to store metadata

# information. If InnoDB requires more memory for this purpose it will

# start to allocate it from the OS. As this is fast enough on most

# recent operating systems, you normally do not need to change this

# value. SHOW INNODB STATUS will display the current amount used.

innodb_additional_mem_pool_size=8M

 

# If set to 1, InnoDB will flush (fsync) the transaction logs to the

# disk at each commit, which offers full ACID behavior. If you are

# willing to compromise this safety, and you are running small

# transactions, you may set this to 0 or 2 to reduce disk I/O to the

# logs. Value 0 means that the log is only written to the log file and

# the log file flushed to disk approximately once per second. Value 2

# means the log is written to the log file at each commit, but the log

# file is only flushed to disk approximately once per second.

innodb_flush_log_at_trx_commit=2

 

# The size of the buffer InnoDB uses for buffering log data. As soon as

# it is full, InnoDB will have to flush it to disk. As it is flushed

# once per second anyway, it does not make sense to have it very large

# (even with long transactions).

innodb_log_buffer_size=16M

 

# InnoDB, unlike MyISAM, uses a buffer pool to cache both indexes and

# row data. The bigger you set this the less disk I/O is needed to

# access data in tables. On a dedicated database server you may set this

# parameter up to 80% of the machine physical memory size. Do not set it

# too large, though, because competition of the physical memory may

# cause paging in the operating system. Note that on 32bit systems you

# might be limited to 2-3.5G of user level memory per process, so do not

# set it too high.

innodb_buffer_pool_size=256M

 

# Size of each log file in a log group. You should set the combined size

# of log files to about 25%-100% of your buffer pool size to avoid

# unneeded buffer pool flush activity on log file overwrite. However,

# note that a larger logfile size will increase the time needed for the

# recovery process.

innodb_log_file_size=128M

 

# Number of threads allowed inside the InnoDB kernel. The optimal value

# depends highly on the application, hardware as well as the OS

# scheduler properties. A too high value may lead to thread thrashing.

innodb_thread_concurrency=50

Вот ето у меня

[anngray 0]

#*** INNODB Specific options ***

 

 

# Use this option if you have a MySQL server with InnoDB support enabled

# but you do not plan to use it. This will save memory and disk space

# and speed up some things.

skip-innodb

 

# Additional memory pool that is used by InnoDB to store metadata

# information. If InnoDB requires more memory for this purpose it will

# start to allocate it from the OS. As this is fast enough on most

# recent operating systems, you normally do not need to change this

# value. SHOW INNODB STATUS will display the current amount used.

innodb_additional_mem_pool_size=8M

 

# If set to 1, InnoDB will flush (fsync) the transaction logs to the

# disk at each commit, which offers full ACID behavior. If you are

# willing to compromise this safety, and you are running small

# transactions, you may set this to 0 or 2 to reduce disk I/O to the

# logs. Value 0 means that the log is only written to the log file and

# the log file flushed to disk approximately once per second. Value 2

# means the log is written to the log file at each commit, but the log

# file is only flushed to disk approximately once per second.

innodb_flush_log_at_trx_commit=2

 

# The size of the buffer InnoDB uses for buffering log data. As soon as

# it is full, InnoDB will have to flush it to disk. As it is flushed

# once per second anyway, it does not make sense to have it very large

# (even with long transactions).

innodb_log_buffer_size=16M

 

# InnoDB, unlike MyISAM, uses a buffer pool to cache both indexes and

# row data. The bigger you set this the less disk I/O is needed to

# access data in tables. On a dedicated database server you may set this

# parameter up to 80% of the machine physical memory size. Do not set it

# too large, though, because competition of the physical memory may

# cause paging in the operating system. Note that on 32bit systems you

# might be limited to 2-3.5G of user level memory per process, so do not

# set it too high.

innodb_buffer_pool_size=256M

 

# Size of each log file in a log group. You should set the combined size

# of log files to about 25%-100% of your buffer pool size to avoid

# unneeded buffer pool flush activity on log file overwrite. However,

# note that a larger logfile size will increase the time needed for the

# recovery process.

innodb_log_file_size=128M

 

# Number of threads allowed inside the InnoDB kernel. The optimal value

# depends highly on the application, hardware as well as the OS

# scheduler properties. A too high value may lead to thread thrashing.

innodb_thread_concurrency=50

Вот ето у меня

 

скачай последний mysql

[spirit2011 2]

можеш дать ссилку на мускула для виндовс7 ????

[spirit2011 2]

Можеш мне скайп дать по тививеру поможеш плз)

[dLs.project 0]

Спирит че ты как телка все те подовай на тарелочке!!??? В зубы гугл и удачи,те уже все разьяснили! Остается тока найти что не составляет проблемы!!!!!!!!

[dLs.project 0]

http://l2ua.ru/forum/60-3891-1

 

Держи... И прости что так налетел на тя!) Просто не в настроении...

[spirit2011 2]

спс зделал)

[SmokiMo 892]

Автоматическое сообщение

 

 

Эта тема была перемещена из "Форум для новичков" в "Архив".