Re: Tool for shifting tables from Mysql to Postgresql

-character-set -- Jaime Crespo MySQL Java Instructor Software Developer Warp Networks http://warp.es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Mysql to Postgresql

/mysqldump.html#option_mysqldump_compatible Anyway, most of the times you will need a more manual migration, with human intervention (custom scripts) and migrating the data through something like CSV (SELECT... INTO OUTFILE). -- Jaime Crespo MySQL Java Instructor Software Developer Warp Networks http

Re: contact gives empty result

/control-flow-functions.html#function_ifnull Anyway, you should get rid of misplaced NULL fields, as they also affect performance. -- Jaime Crespo MySQL Java Instructor Software Developer Warp Networks http://warp.es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: CURRENT insert ID

) values ('test data'); Query OK, 1 row affected (0.00 sec) mysql select id from mytable where id is null; -- OMG!!! ++ | id | ++ | 1 | ++ 1 row in set (0.00 sec) --8--8--8--8--8--8--8--8--8--8--8-- -- Jaime Crespo MySQL Java Instructor

Re: Loading Unicode Data to mySQL

/connector-odbc-configuration-connection-parameters.html Charsets can be a mess if you have several layers and only one of them fails, but if you understand fully all of MySQL parameters is not so difficult. -- Jaime Crespo MySQL Java Instructor Software Developer Warp Networks http://warp.es

Re: How to unstall MySQL 5.1 on Ubuntu 8.04 LTS

the official guide: http://dev.mysql.com/doc/refman/5.1/en/installing-binary.html MySQL works flawlessly on Ubuntu. -- Jaime Crespo MySQL Java Instructor Warp Networks http://warp.es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: RHEL Auto Start / stop mysql???

/5.1/en/automatic-start.html -- Jaime Crespo MySQL Java Instructor Warp Networks http://warp.es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: MySQL Replication

: row and statement-based. Please, have a look at the manual page: http://dev.mysql.com/doc/refman/5.1/en/replication-formats.html -- Jaime Crespo MySQL Java Instructor Warp Networks http://warp.es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: MySQL Replication

in the replication process, it stops. You have to solve the issues manually and then start the replication again. This usually occurs due to the synchronous/distributed nature of the replication. -- Jaime Crespo MySQL Java Instructor Warp Networks http://warp.es -- MySQL General Mailing List

Re: MySQL Replication

if MySQL gives some support to handle this (auto-increment-offset, replicate-ignore-table), you should mostly handle it at business logic (application server) layer, not in the MySQL database. Alternatively, as Johan pointed, have a look at the semi-synchronous replication. -- Jaime Crespo MySQL

Re: Missing database file names

and the REPAIR command should be able to regenerate an MYI file from a .MYD and .frm files. After all, MDI file only contains the disk version of the indexes. Beware of possible issues if using different server version, though. -- Jaime Crespo MySQL Java Instructor Warp Networks http://warp.es -- MySQL

Re: auto_increment without primary key in innodb?

) --8 Regards, -- Jaime Crespo MySQL Java Instructor Warp Networks http://warp.es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: optimization

. There also exists a tool to get introduced into MySQL server variables tuning: Tuning primer - https://launchpad.net/mysql-tuning-primer It is also a very general tool, but it could be helpful for a starting point. Regards, -- Jaime Crespo MySQL Java Instructor Warp Networks http://warp.es

Re: Table level locking when inserting auto-increment PK to InnoDB

there is a manual page discussing the changes done for the 5.1 version: http://dev.mysql.com/doc/refman/5.1/en/innodb-auto-increment-handling.html -- Jaime Crespo MySQL Java Instructor Warp Networks http://warp.es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: mysql load balancing

between master writes and slaves see the data). I am sorry I cannot help you, but please, share here if you found something useful AND with good performance. Merry Xmas! -- Jaime Crespo MySQL Java Instructor Warp Networks http://warp.es -- MySQL General Mailing List For list archives: http

Re: mysql load balancing

to coordinate the db servers (sharding, replication, ndb), the kind of applications you are going to deploy and how much scability you need. I hope that helps. Regards, -- Jaime Crespo MySQL Java Instructor Warp Networks http://warp.es -- MySQL General Mailing List For list archives: http

Re: different 5.0 and 5.1 about long_query_time

, -- Jaime Crespo MySQL Java Instructor Warp Networks http://warp.es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: How normal mysql server 5.1 uses multiple cores

cluster on a single host? Anyway, I suppose performance loses on distributed joins and so on would outcome multiple-core benefits. And for most queries, the bottleneck is usually on disk access, not processor. Has anybody done any serious testing on this? -- Jaime Crespo MySQL Java Instructor

Re: OPTIMIZE TABLE

of load balancing while performing administrative tasks. If you could have a pre-production host to test these kind of operations it would be great! Each application is a world on its own. You can read more info here: url:http://dev.mysql.com/doc/refman/5.1/en/optimize-table.html -- Jaime Crespo

Re: Find neighboring rows

. -- Jaime Crespo MySQL Java Instructor Warp Networks http://warp.es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Choose certain columns in mysqldump?

] INTO OUTFILE '/var/www/folder/table_name.txt' FROM table_name WHERE [any, filter, you, want] ORDER BY [any, order, you, want] -- Jaime Crespo MySQL Java Instructor Warp Networks http://warp.es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Using IF in a query to set a variable then sort on said variable

function is the way to go. Anyway, check for performance issues: in that case, precalculating and storing an aditional field would be the best way (it could be done with a trigger, for example). -- Jaime Crespo MySQL Java Instructor Warp Networks http://warp.es -- MySQL General Mailing List

Re: Using IF in a query to set a variable then sort on said variable

to achieve similar results. -- Jaime Crespo MySQL Java Instructor Warp Networks http://warp.es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: MYSQL slow query log in table.

2009/10/7 Brown, Charles cbr...@bmi.com: Hello All. I would like to implement  MYSQL slow query log in table. Can someone kindly assist me with the table definition and implementation. SHOW CREATE TABLE mysql.slow_log; http://dev.mysql.com/doc/refman/5.1/en/log-tables.html -- Jaime Crespo

Re: troubles with complex UTF-8 characters

.). -- Jaime Crespo MySQL Java Instructor Warp Networks http://warp.es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Mysql 4.1 vs 5.0

Benching Somebody knows why 4.1 is faster than 5.0 mysql versions Ing. Jaime Fuentes R. 997500459 2421905-2423252 Enviado desde mi BlackBerry de Claro. -Original Message- From: Brent Baisley brentt...@gmail.com Date: Tue, 2 Jun 2009 12:32:39 To: Rayr...@stilltech.net Cc: mysql

Re: too many connections

You have to use mysql 64bits on S.O. 64bits --Mensaje original-- De: Martin Gainty Para: Kinney, Gail Para: 'mysql@lists.mysql.com' Enviado: 19 Sep 2008 10:51 Asunto: RE: too many connections in my.cnf configuration file try upping the number of connections max_connections=3072 to

mysql x64en server 64 bits

. Jaime Fuentes R. Peru Arpotu escribió: All, I have a customer who has been on MySQL for about 8 years, but they are moving their business elsewhere. They are moving their database into an Oracle shop, and want me to export their MySQL data into a format that's easily imported into Oracle. Does

Re: procedure locks all statemens

the max_connection parameter is 2048. what could be happened? and what to solve this ? Jaime Fuentes R.

Rows inserted into a table producing errno: 13

Hi I am running mysql version 4.0.27 on Red Hat Enterprise Linux 3 i had a myisam table with .frm, .MYD and .MYI files with no permissions for user mysql. I inserted several rows without getting any error message, but when i restarted mysqld, everything disapered and i get error message

HELP: mysql stoped sudenly , Database page corruption on disk or a failed

is running on windows 2003 and the ibdata1of innodb is 20 GB Thanks in advance Jaime 070228 17:44:04 InnoDB: Page checksum 75769562, prior-to-4.0.14-form checksum 3189442283 InnoDB: stored checksum 4088203197, prior-to-4.0.14-form stored checksum 0 InnoDB: Page lsn 0 36808, low 4 bytes of lsn

rollback after crash on OS X

to begin looking for what could have happened. Any thoughts/suggestions? thanks, Jaime -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL vs Oracle

Hi all! I'm developing a system using both MySQL and Oracle for document processing. I issue a series of queries to the database, depending on the document size. For big documents, both databases behave in the same way but, when using small documents, MySQL finishes quickly while Oracle

Re: MySQL vs Oracle

Oracle sites to run as fast as MySQL. We're running MySQL 4.0.18 and Oracle 8i and 9i at the latest patch levels. Applying the appropriate patches on Oracle can make a big difference too. --Walt -Original Message- From: Jaime [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 16, 2004 4:59 AM

Unexpected subquery behaviour

Hi all! I'm using subqueries in MySQL 4.1.1 alpha. I use three subqueries and then want to get those combinations matching a given constraints. It is a very simple task, but I get less results than I expected. In fact, I tried to execute the same query in ORACLE and I get 23 results (in MySQL

Need help in querying two tables

it work for my need. hoping for your help. Jaime -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: How to perform the following Query in MySQL

, Jaime -Original Message- From: Sent: Wednesday, May 28, 2003 2:58 PM To: [EMAIL PROTECTED] Subject: How to perform the following Query in MySQL Hello, I am studying the possible migration of a system using another database engine to MySQL for various reasons. However, I have

How to perform the following Query in MySQL

? TIA Jaime - Jaime J. Maiz 630 979 2088 mailto:[EMAIL PROTECTED] IH 4F-310

need help with GROUP BY

FROM tablename WHERE detail LIKE '%pattern%'; However, this would produce several hits for a single account. I'd like it to produce only one hit *per* account and give me id where '%pattern%' was found and account where it was found on. It should only return *one* result per account. regards, Jaime

why is this slow?

is very low OR when select count(*) from eventlog where id number; would give a small number. Is there a way to increase the performance of my table/search? jaime - Before posting, please check: http://www.mysql.com

Re: why is this slow?

doesnot use index/keys? Does this mean, that there is absolutely no way to improve my query? Hmm.. I read lots of good stuffs with MySQL 4.x; is this already safe to use? regards, jaime Thomas On Mon, 11 Nov 2002 16:41:50 +0800 Jaime Teng [EMAIL PROTECTED] wrote: Hi, I have a mysql table

How stable is MySQL 4.x vs 3.23.x?

Hi, How stable is the new MySQL 4.x? I've read some really nice and powerful stuffs with MySQL 4. x and surely like to use them. Is this still in the 'use at your own risk' stage? or is it stable enough for use already? regards, Jaime

MySQL server and datadir in a different machine

. thank for your time. jaime - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe

slow search on INDEX?

get any improvement and it turned out even a lot slower. Why was it this way? thanks for your inputs. jaime - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

how to configure my.cnf

it have? Jaime # Example mysql config file. # Copy this file to c:/my.cnf to set global options # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password=my_password

Re: help with big table search

there was FULLTEXT; I was using and old PDF manual. Jaime At 06:42 PM 2/24/02 -0800, Jeff Kilbride wrote: I'm about to try a full text index in a very similar situation, which has the potential to grow fairly big. I'd also be interested in hearing how MySQL's full text index works for your large dataset

help with big table search

seconds). SOMETIMES, searching through this crossref were actually slower. I'd like to know how you people come up with a very good table and search. Eventlog is currently 200MB in size. Jaime - Before posting, please check

Re: How can run Mysql program from different user (NOT only root) ?

to open the same database? Jaime At 11:03 AM 1/2/02 +0800, Kevin Chan wrote: Dear all, How I can set a different user to run MySQL (only root can run this program now) ? Error message when run the program from user: bash-2.03$ ./mysql --host=192.10.0.113 bash: ./mysql: Permission denied

Need help with SELECT and JOIN pls

' and 'WORLD'. take note that the sentence SHOULD contain ALL the three words not just one or two. I think this is a 'JOIN' question but I am not familiar how to use JOIN. can you show me the syntax? thanks for your help. Jaime

Re: help with timestamp...

(unix_timestamp(now()),data here); jaime At 11:25 PM 12/4/01 -0700, *Himerus* wrote: Can anyone give me a good link on how to put in a timestamp on a form that inserts directly into a sql database??? I keep trying it, but it's only coming thru as 00 , so on. Thanks. Newbie

Annoying DBD-mySQL error wont go away

-fetchrow ) {1}; It appeared to me that even if only one result is to be expected, mysql would throw more than one. or is this a problem with DBD-Mysql module? regards, Jaime - Before posting, please check: http://www.mysql.com

How to join MsQL queries?

Hi, I have the following queries: SELECT account FROM user where username = 'george'; then using the result from this query, i pass it onto the next: SELECT * FROM record WHERE account = 'result from above'; I am new to 'JOIN' and dont know the correct join syntax. THANKS, jaime

help renumbering unique

, if the numbers were 1,20,22,25,40,45,47. the new data will be 1,2,3,4,5,6,7,8,9. ? Jaime - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

any sequence generator function?

to change one of the field and sequence it and am doing it the hard way of updating one at a time. regards Jaime - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

help with crosstable SEARCH

include u.username = m.username in the WHERE field, it immediately produces the result in 0.0x seconds. Why does it hang on the 1st case? was it because there were cases wherein a row in masterlist is not present in user list that's causing it to croak? Jaime mysql describe masterlist

help me with select query

search registers result = 1604, 1621, 1622, 1662 search registers, tintin result = 1604 thanks jaime - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Help me improve my table search

' OR i.keyword = 'word2' OR i.keyword = 'word3') AND e.id = i.id ORDER by i.id DESC LIMIT 20; I dont like doing the above workaround as it would take another messy table, any suggestions? Jaime - Before posting, please

different subdir for database

Hi, I have mysql on NT4 (soon to be win2000). one question is that the database files all reside under drive c. NT does not have symbolic link is there a way to tell mysql that a particular database is located on a different folder? where is the documentation for this one? jaime

mysql, perl and retrieving long column

Hi, If I have a table: create table messages ( id int unsigned not null unique, datalongtext ); and I have a perl script: 1 $sth = $dbh-prepare( SELECT data FROM messages WHERE id = ?;); 2 $sth-execute($id); 3 $data = $sth-fetchrow; QUESTION: will the script stop at line 3 until

can I force SELECT to use a specified INDEX?

) ? Jaime - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED

Whats wrong here?

. Jaime - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql

help with index

is performance/speed in doing the following: select * from tablename where name = 'bill'; select * from tablename where age 30; select * from tablename where city = 'new york'; thanks jaime database,mysql - Before posting, please check

Re: help with index

on top of the previous index? alter table tablename add index (name,city); alter table tablename add index (age,city); alter table tablename add index (age,name); etc... thanks Jaime database,mysql - Before posting, please check

Re: running multiple mysqld's

and either communicate with two mysqld or use a backup database file you know what i mean. jaime At 03:02 AM 6/9/01 -0230, Neil Zanella wrote: Sorry about this questions but why would you want to run two copies of mysqld when it is capable of hosting as many different databases as you need

help with select

another select of entries with the same account. I already tried: select * from user u, user r where r.account=u.account and r.name='BILL'; i got no result but no error. jaime database,sql - Before posting, please check

need help with cross table update

wanted to fill it up based on the class value found in table1. I was trying to do something like this: UPDATE table2 set class=table1.class WHERE table1.username=table2.username obviously wrong. what is the correct syntax? thanks. jaime

help how to undo concat

= unconcat(columnname, 'string'); will actually delete 'string' pattern from columnname? thanks Jaime - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

View a return of Select

I have to check to MySQL is able to support our requirements and I would like to view a return of n columns like only one register, thats is posible with MySQL? For example i have 2 tables , 1 table have products and this table habe 3 colums ID , name, Id_price and the other table