how to create host table?

Hi there I am using MacOSX SERVER. When I want to start MySQL it says: [HostPowerBook:/] ilyas% mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) According to Mysql documentation this means that mysqld doesn't started. Just when I want to start mysql

MIT-Pthreads

What I also not understand is that one can also compile Mysql with MIT-Pthreads. What is a MIT-Pthread? Where can I read more about this? Thanks ilyas - Before posting, please check: http://www.mysql.com/manual.php (the m

binary or source

At www.mysql.com I can download the source or the binary for macosx. My question is what is the difference between the source and the binary? I haven't found a description of the installation with the binary or with the sourcecode. Thanks for any help... ilyas ---

uninstall on macosx

Mysql creates over 900 files at an installation. I want to reinstall my Mysql. How can I remove all these files? Where does Mysql creates files? Is it possible to install 2 versions of mysql on the same machine? ilyas - Befor

foreign keys

Is it in Mysql 4 possible to use foreign keys? If yes, how can I create two tables with foreign keys and use them? Thanks ilyas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.

auto_increment fields

How many auto_increment fields can I have in a database? Thanks ilyas filter:mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To r

select in create

Can I also use a select statement in a create statement. Something like this: create table mytable ( id int not null primary key (select max(id) from mytable2), name varchar(255) ); is this possible or is there an other way to do something like this? ilyas filter: mysql --

max(id) from two tables

Can I create an integer field which automaticly look after in two tables to have the biggest id from this tables and increment this maxid and store it? thanks ilyas filter: mysql - Before posting, please check: http://w

backup script

Has anyone a shell script example to backup all mysql databases at 3 o'clock at the night? Thanks... ilyas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (

Mysql command from the shell

hi list Can I also execute mysql commands from the shell. Something like this: % mysql -u root -pmypass --execute=use mydb; select * from mytable; Thanks.. ilyas - Before posting, please check: http://www.mysql.com/manua

searching in 2 databases?

Is it possible in Mysql to search in 2 databases with only one search statement? Thanks ilyas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list ar

How to store a session_id in mysql?

Hi... What is the best way in MySql to store a session_id in hex format. Can Integer also store hex values like: E4FA762685A23E002D86483AACE9BD7B Thanks Ilyas - Before posting, please check: http://www.mysql.com/manual.php

add->flush?

don't need to flush tables before searching only at this table! What is the reason of this behaviour? Thanks Ilyas Keser - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysq

shell script to backup

Hi all... I am a new Linux user. Does any one have a shell script to backup all Mysql databases? Thanks ilyas... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

sql-commands in a file

HI all; I have 3 databases. I want backup all this databases by giving one command. I use the backup command to backup my databases, it seems to be the fastest way. Can I write sql the sql-commands below in a file and execute them by giving only one command? use db1 backup table tab1, tab2 ta

backup

Hi list... What is the best way to backup a Mysql database? I read in the documentation that mysqlhotcopy is the best and quickest way to do this. But I can not start mysqlhotcopy... Error Message is: Can't locate DBI.pm in @INC (@INC contains: /System/Library/Perl/darwin /System/Library/Perl

backup

Hi list... What is the best way to backup a Mysql database? I read in the documentation that mysqlhotcopy is the best and quickest way to do this. But I can not start mysqlhotcopy... Error Message is: Can't locate DBI.pm in @INC (@INC contains: /System/Library/Perl/darwin /System/Library/Perl