cant select more than 1000 records

[bart]

Hi all
command "select * from table" whith 3000 records give me only 1000
rows
I can't figure out what is wrong. I think that something wrong is with
my my.cnf but can't find which varaible I have to change. Can you
sugest something?

[mysqld]
skip-locking
set-variable = max_user_connec tions=100
set-variable = max_connections =150
set-variable = key_buffer=128M
set-variable = join_buffer=4M
#set-variable = record_buffer=1 M
set-variable = sort_buffer=5M
set-variable = table_cache=102 4
set-variable = myisam_sort_buf fer_size=32M
set-variable = thread_cache_si ze=128
set-variable = wait_timeout=45
set-variable = connect_timeout =10
set-variable = interactive_tim eout=60
set-variable = max_allowed_pac ket=16M
set-variable = max_connect_err ors=10
set-variable = flush_time=600
innodb_data_hom e_dir = /var/lib/mysql/
innodb_data_fil e_path = ibdata1:10M:aut oextend
set-variable = innodb_addition al_mem_pool_siz e=5M

[querycache]
#query_cache_li mit = 1M
query_cache_siz e = 32M
query_cache_typ e = 1
thread_concurre ncy=4

[mysqldump]
quick
set-variable= max_allowed_pac ket=16M

[mysqlhotcopy]
interactive-timeout

[isamchk]
set-variable = key=16M
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M

[myisamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M

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

[Peter]

What interface are you using for retrieving data? Are you using mySQL
control center? In this case, you must edit the connection and set-up the
limit to "unlimited" . By default, mySQLcc only retrieves 1000 records.

HPEter
<ba**@sonik.p l> wrote in message
news:a4******** *************** **@posting.goog le.com...

Hi all
command "select * from table" whith 3000 records give me only 1000
rows
I can't figure out what is wrong. I think that something wrong is with
my my.cnf but can't find which varaible I have to change. Can you
sugest something?

[mysqld]
skip-locking
set-variable = max_user_connec tions=100
set-variable = max_connections =150
set-variable = key_buffer=128M
set-variable = join_buffer=4M
#set-variable = record_buffer=1 M
set-variable = sort_buffer=5M
set-variable = table_cache=102 4
set-variable = myisam_sort_buf fer_size=32M
set-variable = thread_cache_si ze=128
set-variable = wait_timeout=45
set-variable = connect_timeout =10
set-variable = interactive_tim eout=60
set-variable = max_allowed_pac ket=16M
set-variable = max_connect_err ors=10
set-variable = flush_time=600
innodb_data_hom e_dir = /var/lib/mysql/
innodb_data_fil e_path = ibdata1:10M:aut oextend
set-variable = innodb_addition al_mem_pool_siz e=5M

[querycache]
#query_cache_li mit = 1M
query_cache_siz e = 32M
query_cache_typ e = 1
thread_concurre ncy=4

[mysqldump]
quick
set-variable= max_allowed_pac ket=16M

[mysqlhotcopy]
interactive-timeout

[isamchk]
set-variable = key=16M
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M

[myisamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M

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