mysql-proxy losting connection

2008-04-29 Thread Tiago Cruz
You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3325 Server version: 5.0.22-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> quit Bye 

Re: Stable MySQL Version

2007-12-05 Thread Tiago Cruz
On Wed, 2007-12-05 at 07:13 -0800, Amit Nair wrote: > Could some one please let me know a stable version of MySQL for my computer? Version 5.0.45. http://dev.mysql.com/downloads/mysql/5.0.html#win32 -- Tiago Cruz http://everlinux.com Linux User #282636 -- MySQL General Mailing List

Re: How to migrate from MySQL 3 to MySQL 5 (installed from sources)

2007-11-07 Thread Tiago Cruz
n old database, stop the old and restore on newer database. Just copy the datafiles can work on small upgrades (mysql 3 -> 4) but I don't know what is the problem of this, I prefer the basic: dump and restore. -- Tiago Cruz http://everlinux.com Linux User #282636 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

PHP+MySQL: localhost or 127.0.0.1?

2007-10-30 Thread Tiago Cruz
Now the question: Which one have better performance/ speedy? Thanks -- Tiago Cruz http://everlinux.com Linux User #282636 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: urgente

2007-10-17 Thread Tiago Cruz
t PATH groupadd mysql adduser -g mysql mysql mkdir /mysql5/bin-5.0.37/var chown -R mysql:mysql /mysql5/bin-5.0.37/var su - mysql mysql_install_db cp /mysql5/bin-5.0.37/share/mysql/mysql.server /etc/init.d/mysql5 /etc/init.d/mysql5 start mysqladmin -v password YOUR_PASSWORD PS: You

Re: Saving space disk (innodb)

2007-10-10 Thread Tiago Cruz
Thank you guys!! I have a lot of MyISAM and a lot of InnoDB on this database. I did one little "for" to run one "OPTIMIZE TABLE" in each table that I have, on my database. If this step don't save enough disk space, I'll do the Baron suggestion. Thank you all! - T

Saving space disk (innodb)

2007-10-10 Thread Tiago Cruz
_log_at_trx_commit=1 set-variable= innodb_lock_wait_timeout=5 set-variable= innodb_data_home_dir=/dbms/mysql/bin-4.0.17/var set-variable= innodb_data_file_path=ibdata1:1000M:autoextend set-variable= innodb_log_group_home_dir=/dbms/mysql/bin-4.0.17/var Thanks! -- Tiago Cruz http:/

Using MySQL date/time

2007-10-08 Thread Tiago Cruz
| | | cs_poem_align | varchar(10) | YES | | NULL| | | cs_sender_ip | varchar(15) | YES | MUL | NULL| | ++--+--+-+-+---+ 28 rows in set (0.01 sec) -- Tiago Cruz http://everl