[said_fox]

Yes sqlYog is an amazing tool to deal with MySQL server. It allows me to deal with MySQL Server easily without need to run the Apache Web Server in order to run phpMyadmin when the required task is only dealing with MySQL Server.

I used to use sqlYog since it was free 🙄 currently I use the latest free version but just yesterday I downloaded the last trial version of sqlYog.

I found it becomes so better and reable.

[said_fox]

I have done that ” table>Change table type to>InnoDB”, but also nothing.

When I try to “Manage Relationships” a message is prompt tell

“The Selected table does not have InnoDB table Handler

You cannot manage relationships for the table”

:huh:

[said_fox]

Ok, I had already choosed the table type from the advanced table properties, and the situation remains as it is. i.e No InnoDB table type formed. So I'd like to ask, if there any thing may be related with MySQL server itself can adjacet this.

This's a copy of my.ini

#This File was made using the WinMySQLAdmin 1.4 Tool

#22/01/2003 01:24:20 Õ

#Uncomment or Add only the keys that you know how works.

#Read the MySQL Manual for instructions

[mysqld]

basedir=C:/MYSQL

#bind-address=127.0.0.1

datadir=C:/MYSQL/data

#language=C:/MYSQL/share/your language directory

#slow query log#=

#tmpdir#=

#port=3306

#set-variable=key_buffer=16M

[WinMySQLadmin]

Server=C:/MYSQL/bin/mysqld-max.exe

user=saidool9

password=foxhjh2

QueryInterval=10

# You can write your other MySQL server options here

# …

#

innodb_data_home_dir=c:ibdata

# Datafiles must be able to

# hold your data and indexes

innodb_data_file_path=ibdata1:200M;ibdata2:200M

# Set buffer pool size to 50 – 80 %

# of your computer's memory

set-variable=innodb_buffer_pool_size=100M

set-variable=innodb_additional_mem_pool_size=10M

innodb_log_group_home_dir=c:iblogs

# .._log_arch_dir must be the same

# as .._log_group_home_dir

innodb_log_arch_dir=c:iblogs

innodb_log_archive=0

set-variable=innodb_log_files_in_group=3

# Set the log file-size to about

# 15 % of the buffer pool size

set-variable=innodb_log_file_size=10M

set-variable=innodb_log_buffer_size=8M

# Set ..flush_log_at_trx_commit to

# 0 if you can afford losing

# a few last transactions

innodb_flush_log_at_trx_commit=1

set-variable=innodb_file_io_threads=4

set-variable=innodb_lock_wait_timeout=50

The above is a copy of my.ini file in windows

[Author]

Posts