Re: Migration from SQL Server

2014-07-14 Thread Carlos Proal
Workbench provides some migration features and supports SQL Server http://www.mysql.com/products/workbench/migrate/ On Mon, Jul 14, 2014 at 4:47 PM, Felipe Coutinho wrote: > Hello, > > I'm a web developer and I'm developing a web application on Rails. I'm > gonna use MySQL at production (I'm u

Re: sort order

2012-05-30 Thread Carlos Proal
Hi Wes, have you double checked you character set and collation ?? http://dev.mysql.com/doc/refman//5.5/en/charset-charsets.html The collation is which determines the sorting order. Carlos Proal On Wed, May 30, 2012 at 4:02 PM, Wes James wrote: > I have mysql 5.1.62-0ubuntu0.11.1

Re: file privilege

2012-01-30 Thread Carlos Proal
Correct. Carlos On Tue, Jan 31, 2012 at 12:03 AM, kalin m wrote: > > > thanks carlos. so if i go with: > > "grant file on user " > > that wont infringe on the all other privileges the user already has, > correct? > > > thanks.. > > &g

Re: file privilege

2012-01-30 Thread Carlos Proal
Hi, You have look at the "user" table which has global privileges, "db" is specific to each database. Carlos On Mon, Jan 30, 2012 at 10:56 PM, kalin m wrote: > > > hi... > > so i have this user in the user table in the mysql db that has all the > privileges but "grant". now i need for that us

Re: SSIS and MySQL

2011-11-14 Thread Carlos Proal
David Afaik, the connector is pure .net application, so there is no 32/64 bits distinction; you can use it in either architectures. Carlos On Mon, Nov 14, 2011 at 9:23 AM, David Stoltz wrote: > Hi Folks, > > I'm in need to connect from my SQL 2008R2 (64 bit) server, to my MySQL > database ser

Re: problem

2011-05-02 Thread Carlos Proal
Swaroop: How are you handling the connections to db ? only one, with a pool, something adhoc ?. It looks like the connection is only one and expires after a time out and you get the error that there is no connection. Carlos On 5/2/2011 3:15 PM, Andrés Tello wrote: Seems more a java issue th

Re: performance debian lenny and vmware

2011-03-27 Thread Carlos Proal
. Carlos Proal On 3/27/2011 1:14 PM, Rafael Valenzuela wrote: Hi all: I have installed mysql 5.0 on a debian lenny 64 bits, in vmware,but I see that there are problems with mysql performance the server is too very slow. any solution? or any idea? -- MySQL General Mailing List For list

Re: Query precision issue

2010-10-25 Thread Carlos Proal
-with-float.html Carlos Proal On 10/25/2010 12:15 PM, Sairam Krishnamurthy wrote: All, I have simple query like 'select * from table1 where column1=-107.689878'. This returns an empty set. But there is data corresponding to this value of column. When I looked more into it, it

Re: How to extend innodb files?

2010-09-27 Thread Carlos Proal
You have to round the size of the last data file (ibdata4) and add the new ones. You can find more information on the manual: http://dev.mysql.com/doc/refman/5.1/en/innodb-configuration.html http://dev.mysql.com/doc/refman/5.1/en/adding-and-removing.html Carlos On 9/28/2010 12:59 AM, Vokern wr

Re: BLOB data gets encoded as utf8! (Anyone?)

2010-08-30 Thread Carlos Proal
is a limit), so i strongly recommend using prepared statements for blobs with any database. Hope this helps. Carlos Proal On 8/28/2010 1:04 AM, Andreas Iwanowski wrote: Has no one encountered this before? There has got to be a solution, and I still haven't found it... So if you have any i

Re: Anyone can help resolve this problem?

2010-05-30 Thread Carlos Proal
On 5/30/2010 5:44 PM, Lancer wrote: > Hi there. Sorry for my poor english. > Iinstalled MySQL 5.5 m3 though original RPM package and I modified the MySQL > root password. When Iinstall WordPress, I got the error message like 'Error > establishing adatabase connection'. But when I clear MySQL root

Re: How to put table definition into another table using SQL?

2010-05-11 Thread Carlos Proal
Hi Mike, you need to query the information_schema schema/database that contains the database dictionary. You can read the manual or a beautiful diagram here: http://www.xcdsql.org/Misc/MySQL_INFORMATION_SCHEMA.html Have a nice day Carlos Proal On 5/11/2010 11:06 AM, mos wrote: At 10:53 AM

Re: Innodb buffer pool usage

2010-03-16 Thread Carlos Proal
nd disadvantages, but as a new DBA is good to get involved in this concepts and comparisons between dbms. Carlos Proal On 3/16/2010 12:46 AM, Machiel Richards wrote: Hi all Maybe someone can assist me with this one. A while back I requested some inf

Re: Dumping table contents to stdout in tab-separated value format

2010-02-20 Thread Carlos Proal
I dont know if this can help, but if you are on unix/linux you can call cat after the dump and easily you can get the output to the stdout ie: $ mysqldumptempfile.txt... && cat tempfile.txt Carlos On 2/20/2010 9:03 PM, Yang Zhang wrote: Hi, I'm interested in piping out the contents of a

Re: Help with the World.sql sample database

2010-02-11 Thread Carlos Proal
On 2/11/2010 11:47 AM, kebede teferi wrote: Could any one lead me to a true link where I can download the world.sql sample database? Thanks. http://dev.mysql.com/doc/index-other.html Carlos Proal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Forgot the root passwd on Mysql intalled on a windows machine

2010-02-02 Thread Carlos Proal
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html Have a nice day Carlos On 2/2/2010 10:22 AM, ishaq gbola wrote: Hi Guys, I have forgotten the root password on mysql database installed on a windows machine, how can I reset this password. I have tried un-installing and re-

Re: I NEED HELP ON 'SOURCE(\.) MYSQL

2010-02-01 Thread Carlos Proal
Error 2 is "No such file or directory" So, probably the file is not in the right path or you need to explicitly provide the path to the file. Carlos On 2/1/2010 5:38 PM, kebede teferi wrote: Hi, I'm very new to this and I need help. What I want to do is to execute a source command stateme

Re: How to change mysql default database directory

2010-01-28 Thread Carlos Proal
using Windows. Thanks in advance. *From:* Carlos Proal *To:* mysql@lists.mysql.com *Sent:* Fri, January 29, 2010 10:16:31 AM *Subject:* Re: How to change mysql default database directory Absolutely, check for the var

Re: Sharding

2010-01-28 Thread Carlos Proal
Chandra Prajapati wrote: Hi Carlos, Have you tried and benchmark hivedb. any body reviewed hivedb. Please share the experience. Krishna On Fri, Jan 22, 2010 at 11:47 PM, Carlos Proal <mailto:carlos.pr...@gmail.com>> wrote: Hi Krishna Depending on your programming language, yo

Re: How to change mysql default database directory

2010-01-28 Thread Carlos Proal
Absolutely, check for the variable "datadir" on the config file (my.ini on windows and my.cnf on *nix). Carlos On 1/28/2010 9:12 PM, Lucky Wijaya wrote: Hi all, I've installed MySQL on 320GB Harddisk (partitioned into 3 partitions). I want to know if there's a way to change MySQL default d

Re: Good source for sample data?

2010-01-28 Thread Carlos Proal
Google for "data generator", there are free and commercial solutions available. Carlos On 1/28/2010 5:52 PM, Brian Dunning wrote: Hey all - I need a few million sample contact records - name, company, address, email, web, phone, fax. ZIP codes and area codes and street addresses should be

Re: Sharding

2010-01-22 Thread Carlos Proal
Hi Krishna Depending on your programming language, you can use http://www.hivedb.org/ Also you can try the "new" Spider Storage Engine http://spiderformysql.com/ I have not tried this one but seems interesting and there are a couple reviews by Giuseppe Maxia that can help you: http://datachar

Re: innodb recovery

2010-01-20 Thread Carlos Proal
Hi Johny Do you have the my.cnf configuration file ?? that can simplify things. Carlos On 1/20/2010 3:32 AM, Johny Brawo wrote: Hello! I got all data files (ibdata1, ib_logfile, etc) recovevered from mine old Debian 3.1 box (and i dont know MySQL version :( ). I want to get that DB running a

Re: Quick help with Insert

2010-01-19 Thread Carlos Proal
Hi !! You need a left join and then an insert. Please read: http://dev.mysql.com/doc/refman/5.1/en/join.html or google for tutorials on left join And tell me if you have further questions Carlos On 1/19/2010 1:00 PM, Intell! Soft wrote: Hey Not really quick ;> - But nobody knows an a

Re: MySQL Replication Delete is not gettting replicated

2010-01-18 Thread Carlos Proal
lly? Thanks in advance. -- Regards, Manasi Save Quoting Carlos Proal : I dont see anything unusual or missing on your config file and as the only thing missing are deletes, i think that might be a permission issue. Can you check out the grants for your replication users and see if they hav

Re: MySQL Replication Delete is not gettting replicated

2010-01-18 Thread Carlos Proal
I dont see anything unusual or missing on your config file and as the only thing missing are deletes, i think that might be a permission issue. Can you check out the grants for your replication users and see if they have full permissions granted ? mysql> show grants for x; where is xxx

Re: Record old passwords ?

2010-01-18 Thread Carlos Proal
On 1/18/2010 6:52 PM, Colin Streicher wrote: On January 18, 2010 01:34:15 pm Tompkins Neil wrote: Hi I'm in the process of designing a login system to a secure web page using MySQL. One of the features is we need to record and ensure that the user password is different from any of the last

Re: HELP! "RESET MASTER" hosed replication

2009-12-23 Thread Carlos Proal
have lost some event in some unfortunate case, but anyway it is probably for now to put slave back on track, check and eventually resync. Ciao Claudio On 23 dec 2009 21:35, "Carlos Proal" <mailto:carlos.pr...@gmail.com>> wrote: The issue is that replication relies o

Re: HELP! "RESET MASTER" hosed replication

2009-12-23 Thread Carlos Proal
The issue is that replication relies on this logs !!!, so when you deleted them . Generally speaking you have to: > stop the slave > sync the master with the slave (there are several ways to do this and depending how busy is your master) >grab the master status (position) >change the sla

Re: Removing MySQL to install new version

2009-11-12 Thread Carlos Proal
Yes, you only have to delete the directories. Carlos On 11/12/2009 8:16 AM, Miguel Cardenas wrote: Hello I noticed that mysql 6 alpha is no longer available so I want to remove it from my laptop and install the latest 5.x version. I have just restored my Linux system image so my database is c

Re: MySQL alternative to PostgreSQL's pgpool2?

2009-10-25 Thread Carlos Proal
Hi Tomasz There are several solutions for this, one of them, maybe the most popular, is MySQL proxy, take a look to see if solves your issues. http://forge.mysql.com/wiki/MySQL_Proxy Carlos* * On 10/25/2009 12:41 PM, Tomasz Chmielewski wrote: With PostgreSQL, I can use pgpool2[1] tool as a

Re: Some MySQL questions

2009-10-08 Thread Carlos Proal
On 10/8/2009 4:19 PM, John Oliver wrote: 1) When I select * from whatever; is there a way to have the results go by one screen at a time? You can limit output by delimiting your search ie select * from users limit x,y; x=offset y=rows after the ofset 2) In reference to the above, is ther

Re: recovery help needed

2009-08-25 Thread Carlos Proal
You have to reset the permissions. http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html Carlos On 8/25/2009 7:12 PM, Joe wrote: We have an inaccessible MySQL v5.0.45 DB (w/Innodb) we really need some help regaining access to. While attempting to adjust/add remote user access, we

Re: error 135

2009-08-10 Thread Carlos Proal
This might help http://dev.mysql.com/doc/refman/5.0/en/repair.html Carlos On 8/10/2009 11:51 PM, Ron wrote: Hi All, why do i have this error. i have recently setup a mysql cluster, i now have around 60 tables on it. when i create a new one, it gives me this error. ERROR 1005 (HY000): Can't

Re: Remote connection

2009-08-04 Thread Carlos Proal
Are you sure that root has granted access to connect remotely ?? Carlos On 8/4/2009 3:09 PM, Hugo Leonardo Ferrer Rebello wrote: Hello Guys, I have a big doubt. I'm trying to access the mysql database remotely, but I can't. I have changed the skip-networking option on my.cnf fi

Re: Copy 70GB ibdata, etc. and server won't start now

2009-07-14 Thread Carlos Proal
se are not relevant for your purpose, right ? Carlos On 7/14/2009 9:08 PM, Daevid Vincent wrote: -Original Message----- From: Carlos Proal [mailto:carlos.pr...@gmail.com] Sent: Tuesday, July 14, 2009 5:13 PM Another thing you can do is simply erase the innodb logs. If the dbms

Re: Copy 70GB ibdata, etc. and server won't start now

2009-07-14 Thread Carlos Proal
Uppps i mean...useless instead of useful. On 7/14/2009 7:11 PM, Carlos Proal wrote: Another thing you can do is simply erase the innodb logs. If the dbms really was shutdown properly then the logs are useful, they will be recreated again and you can go forward with your demo. Carlos On 7

Re: Copy 70GB ibdata, etc. and server won't start now

2009-07-14 Thread Carlos Proal
Another thing you can do is simply erase the innodb logs. If the dbms really was shutdown properly then the logs are useful, they will be recreated again and you can go forward with your demo. Carlos On 7/14/2009 6:23 PM, Daevid Vincent wrote: Not sure what you mean "start it against the USB

Re: Problem with configuring 32-bit MySQL 5.0 on Windows Vista x64

2009-07-13 Thread Carlos Proal
Did you deleted the data dir (inside Program Files) after uninstall ?? i think that is was not empty and when the new install tries to set up finds it and get messy (maybe because the 32 and 64 bit issue). Carlos On 7/13/2009 11:07 PM, Edward Diener wrote: I had previously installed the 64-b

Re: Copy 70GB ibdata, etc. and server won't start now

2009-07-13 Thread Carlos Proal
On 7/13/2009 9:19 PM, Daevid Vincent wrote: Both systems are UTC time so I don't get the issue with the sequence number is in the future business either. If I ever do get mysqld to start using the "innodb_force_recovery = 4" line, then as you know, I can't alter/update/insert. And it seems any a

Re: XAMMP-MySQL crashing

2009-07-11 Thread Carlos Proal
will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. "Carlos Proal" wrote in message news:4a58c79b.2090...@gmail.com... You have to take a look on the error log, a file named hostname.err (hostname=your machine n

Re: XAMMP-MySQL crashing

2009-07-11 Thread Carlos Proal
You have to take a look on the error log, a file named hostname.err (hostname=your machine name) and should be located inside the mysql dir on the xammp dir. That file will give an insight about the problem, or you can post the error here to get help. Carlos On 7/11/2009 11:52 AM, Gary wr

Re: What to Download????

2009-07-11 Thread Carlos Proal
, obviously a nice development IDE like Eclipse or Netbeans :) Carlos Proal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Password Reset Not Working

2009-05-14 Thread Carlos Proal
On Thu, May 14, 2009 at 6:44 PM, Carlos Proal wrote: Check how many root rows do you have on the user table (select * from user where user='root';), some times there are several rows with different grants and probably you are going through and invalid rule. I checked and when I

Re: Password Reset Not Working

2009-05-14 Thread Carlos Proal
at 6:31 PM, Carlos Proal wrote: Hi Carlos Try this mysql> update user set password=password('letmein') where user='root'; This way the password is saved encrypted, thats the way is compared when you try to log in. Thanks for the reply! I followed both methods i

Re: Password Reset Not Working

2009-05-14 Thread Carlos Proal
Hi Carlos Try this mysql> update user set password=password('letmein') where user='root'; This way the password is saved encrypted, thats the way is compared when you try to log in. Carlos On 5/14/2009 5:28 PM, Carlos Williams wrote: I noticed today that I strangely was unable to login

Re: Duplicate values inserted!

2008-11-17 Thread Carlos Proal
Seems fine to me, i guess the problem is somewhere else. Maybe you should try a full trace in Eclipse to detect the issue. Carlos jean claude babin wrote: Hello, I'm using Eclipse 3.3 and I use a model class HandlereplyModel.java to insert values to a mysql database using mysql5.0 server.Whe

Re: Create table

2008-04-14 Thread Carlos Proal
Hi. group is a reserved word i think you must enclose the table name with single quotes (as when you created the table) in order to avoid the confusion. Carlos Krishna Chandra Prajapati wrote: Hi, I have created a table name group. CREATE TABLE `group` ( `group_id` int(11) NOT NULL,

Re: Table crashes

2007-10-24 Thread Carlos Proal
The manual is your friend for everything, besides any additional book like Paul Dubois (cool book). But, in order to help you, we need more information about the crash: errors, version, table type, hardware, logs, etc. in that way we can offer solutions to your specific issue. feel free to s

Re: mysql dump help!

2007-07-23 Thread Carlos Proal
o 'shell>' shell> shell>mysqldump -u root -ppassword test > test.sql; ERROR 1064 <4200>: You have an error in your SQL syntax; checkthe manual that corresponds to your MySQL server version for the right syntax to use near 'mysqldump -u root -ppassword test &g

Re: Lost Connection

2007-07-23 Thread Carlos Proal
This can be a serious issue, maybe a sign of some kind of data corruption. If you lost the connection, probably the server is restarting (you can check that on the error log), do this happen only with this table ? Carlos krishna chandra prajapati wrote: Hi All, I have connect to mysql-ser

Re: mysql dump help!

2007-07-23 Thread Carlos Proal
Can you email us the complete command and the error ? Carlos Red Hope wrote: Well, that went over my head. :) I understand what you're telling me, how to get there, but not how to do it. bleh. When I start up MySQL Command Line Client, I'm always prompted at "mysql>". So I told it to swi

Re: mysql dump help!

2007-07-23 Thread Carlos Proal
e, if not, move to the mysql/bin directory and then you can run it without any problem. Hope that help. Carlos Red Hope wrote: Oh boy, and here's the big stupid question. How do I get to the shell prompt? Sorry! Yea, I'm that newbie. :) Thank you, Lillian --- Carlos Proal <[

Re: mysql dump help!

2007-07-23 Thread Carlos Proal
One common error is trying to do this inside the mysql console, instead of the shell prompt, i think thats your problem because at least the first one is correct. Carlos Red Hope wrote: Hey y'all, I've been fussing with the MySQL dump procedure to backup my stuff. I'm on MySQL 5.0.41 and I

Re: error in login

2007-07-09 Thread Carlos Proal
Hola Hector, el problema son las 2 tuplas que mencionas, ya que debido a su jerarquia pueden hacer un conflicto que te evita conectarte correctamente, en tu caso si deseas que el usuario se conecte desde donde sea (%) elimina la tupla de la tabla user donde aparezca el localhost, esto puede s

Re: How do you allow external computers to access server instance?

2007-06-22 Thread Carlos Proal
Mysql restricts access outside the server after the installation (on not all, but several cases) so i suggest to connect to the mysql database as root and review the host values on the user table, that can give you an idea of who is allowed and from where is allowed ...remeber that % means an

Re: Is it possible to either update or insert in a single query?

2007-04-12 Thread Carlos Proal
Have you look at replace ? http://dev.mysql.com/doc/refman/5.0/en/replace.html Carlos Douglas Pearson wrote: Apologies if this is a dumb question, but is it possible to write a single query that either updates certain columns in a row, or adds an entirely new row if there is none already? I s

Re: insert data in to columns base on the selection of the list box.

2007-04-03 Thread Carlos Proal
Can you tell us what exactly is your problem ? ie returned error, logic, or what ? My first impression es that your insert is wrong, because inserts cant have "where" conditions (it makes no sense) probably you want to do a completely new insert including the column1 or maybe you want an u

Thank you for the free ride

2007-04-02 Thread Carlos Proal
crew (just to mention a few). See ya at the conference :) Carlos Proal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Creating a Table With a Default

2007-03-28 Thread Carlos Proal
It makes no sense to use a default value with an auto_increment attribute, which means, the default value is the auto-incremented value. Carlos Al Sparks wrote: I'm trying to install ProBIND, and I'm running mysql 4.1.20. One of the ProBIND install scripts calls for tables to be created in

Re: Problem Installation

2007-02-27 Thread Carlos Proal
The log files are named "hostname.err" and must be located inside your data dir, which can be inside your /usr/local directory or in the /var/ Carlos Scott Johnson wrote: 20Hi; I had a working installation of MySQL, and then I zapped it. I found out the hard way that when you delete symli

Re: Growing innodb size

2007-02-24 Thread Carlos Proal
You need to "close" the size of ibdata1 and add the second file ibdata2 with the size you need (and i you like you can even add the autoextend option, but only to the last ibdata file added) for example, if you are aproaching the 1gb size on ibdata1, you specify the maximun size that you want fo

Re: Error: Duplicate entry 'xxxx-L' for key 6

2007-01-03 Thread Carlos Proal
i think you are in fact duplicating an entry on the index, probably one of your indexes on that table is length restricted and that cause that 2 fields that as a whole are different, they are not to the index length. My two cents. Carlos On 1/3/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:

Re: Show the engine/table type for the specific table...

2006-12-09 Thread Carlos Proal
show table status; Carlos On 12/10/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Hi friends, How to show the engine/table type of the one table in my database?? I want to know the engine/table type (InnoDB, MyIsam.) for the tables that I did in my database. Thanks. Wagner Bianch

Re: InnoDB: What happens when a single AUTOEXTEND file goes past 2GB?

2006-12-03 Thread Carlos Proal
Daniel, innodb data files keep growing as needed, it even be of 20Gb or more. If you want several data files (mainly because performance) you need to add them in the my.cnf following the instructions in: 14.2.7. Adding and Removing InnoDB Data and Log Files http://dev.mysql.com/doc/refman/5.0/en/

Re: Undelete a droped table

2006-11-07 Thread Carlos Proal
Only if you had enabled the "log" or "bin-log" options, and the log's history contains the information you need (depending on the log's creation date). Carlos On 11/7/06, Eric Lommatsch <[EMAIL PROTECTED]> wrote: Hello, I have accidently droped a table from one of my database's. The table was

Re: Error 1064 when importing 4.0 dump into 4.1 via command line

2006-09-26 Thread Carlos Proal
I dont think that is the problem but, what do you mean by a slow connection ?, you cant run the dos2unix command on the remote server ? The error ocurred on line 2, did you see any special word in that line ? can you share with us that line? , remember that each version may can reserve different

Re: Transactions in MySQL.

2006-09-25 Thread Carlos Proal
It only works with engines that support transactions like innodb and solid, i strongly sugget to read these links from the manual. http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-transactions.html http://dev.mysql.com/doc/refman/5.0/en/innodb-transaction-model.html Carlos On 9/25/06, [EMAIL

Re: about innodb_file_per_table

2006-09-25 Thread Carlos Proal
Besides some recent change on the engine, i remember that the initial size is 0 because the metadata remains on the main ibdata file(s), and grows as needed, there is no specific range of extending. Carlos On 9/25/06, Takanobu Kawabe <[EMAIL PROTECTED]> wrote: Hello. In InnoDB tables , some "

Re: Question Concerning (innodb_buffer_pool_size)

2006-08-15 Thread Carlos Proal
Yes of course you can and...you should As the my.cnf says # InnoDB, unlike MyISAM, uses a buffer pool to cache both indexes and # row data. The bigger you set this the less disk I/O is needed to # access data in tables. On a dedicated database server you may set this # parameter up to 80% of the

Re: Adding index -- Need help

2006-08-10 Thread Carlos Proal
Remember that if you dont use an index on a colum and you search by that criteria, there would be a whole table scan :(. Its recommended that you always index those columns that appear on a search and/or an order (where column_a='yyy' order by column_b) and those involved on joins; generally spea

Re: Out of memory (Needed xxx ...

2006-04-27 Thread Carlos Proal
on? Also, wouldn't I get a different error, i.e. > Packet Too Large? > > ________ > > From: Carlos Proal [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 26, 2006 4:59 PM > To: Robert DiFalco > Cc: mysql@lists.mysql.com > Subject: Re: Out of mem

Re: Out of memory (Needed xxx ...

2006-04-26 Thread Carlos Proal
r. > > > -----Original Message- > From: Carlos Proal [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 26, 2006 4:53 PM > Cc: mysql@lists.mysql.com > Subject: Re: Out of memory (Needed xxx ... > > Hi Robert, are you using the extended parameters to increase t

Re: Out of memory (Needed xxx ...

2006-04-26 Thread Carlos Proal
Hi Robert, are you using the extended parameters to increase the jvm heap memory ? ie. java -Xms256m -Xmx512m Carlos On 4/26/06, Robert DiFalco <[EMAIL PROTECTED]> wrote: > > Getting this error from JDBC while inserting a VERY large VARBINARY or > MEDIUMTEXT field, ~250MB. I'm guessing th

RE: Help understanding how the connection works

2004-08-02 Thread Carlos Proal
Hi, you cant connect to mysql with telnet, the service running in 3306 supports a dbms specific protocol so you need to use the "mysql" command aka mysql client to connect to mysql and execute any sql query. Carlos From: Gonçalo Silva Dias <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>,<[EMAIL PR

Re: Upgrading mySQL 3.23 to 4.0

2004-08-02 Thread Carlos Proal
supposedly ?, you can check if the mysqld daemon is running with: ps -ef | grep mysql if the daemon is running then the error is something else but my first bet is that is not running. Carlos From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Carlos Proal <[EMAIL PROTECTED]> CC:

innodb per table

2004-08-02 Thread Carlos Proal
How stable is this feature? , i have been using it for a few time and works fine, but im thinking to move my current productive enviroment this way and i dont know if its a good choice. Any advise is appreciated. Carlos _ Tired of s

RE: Lucene with MYSQL

2004-07-29 Thread Carlos Proal
g in something more "static" than doesnt update frequently then Lucene can be a good one. Lucene's faq and http://today.java.net/pub/a/today/2003/07/30/LuceneIntro.html are good references for more details. regards Carlos Proal > > Hope my 5 cents works to you :) > >

RE: Lucene with MYSQL

2004-07-29 Thread Carlos Proal
nstead of uniquely the Vectorial; on the other hand Lucene doesnt support concurrency which can be a serious problem in your application or maybe not. Hope my 5 cents works to you :) Carlos Proal Original Message Follows From: "leegold" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] S

RE: Need help creating table...

2004-04-06 Thread Carlos Proal
Hi, the table name and the column names dont have to be inclosed by ' '. Carlos Original Message Follows From: "Marvin Cummings" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject: Need help creating table... Date: Tue, 6 Apr 2004 12:29:48 -0400 _ From: Marvin Cummings [mailt

RE: MySQL Dump Command Does Not Consider Foreign Key Dependencies

2004-03-05 Thread Carlos Proal
i turn off the checks before a dump in order to restore it properly. In my scripts looks like: echo "SET FOREIGN_KEY_CHECKS=0;" > ${mysql_backup_directory}/${2}/${database_filename} mysqldump --opt -h $2 -P $3 -u $db_username --password=$db_password $1 >> ${mysql_backup_directory}/${2}/${databas

about bug 2654

2004-02-13 Thread Carlos Proal
Hi Mark et al, do you have any clue of when this bug is going to be fixed ? i saw at the bug system that it is a "non-critical" low priority bug, but i think this is major issue that most people using at least java & mysql require for some applications. Bug #2654 JDBC Exception: "Column 'colu

Innodb multiple tablespaces benchmark

2003-12-11 Thread Carlos Proal
Hi all, specially to Heikki. Its really amazing that multiple tablespaces are available before 2004, congratulations to Innodb Oy Inc. Right now im migrating from 4.1.0 to 4.1.1 but im figuring out if there is a downgrade in performance in order to use multiple tablespaces, obviously it must

Re: start innodb without transactions

2003-06-08 Thread Carlos Proal
?, this way i would have a quitely weekend, heheehe, no problem thanx a lot for your help. Carlos Original Message Follows From: "Carlos Proal" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Re: start innodb without transactions Date: Thu, 05 Jun 2003 23:40:16 -0500 Pr

start innodb without transactions

2003-06-06 Thread Carlos Proal
Hi all Is there any way to start mysql/innodb skipping transactions ?, i had a crash and i cant get the database to work. i tried the force_recovery option level 3: # 3 (SRV_FORCE_NO_TRX_UNDO) do not run transaction rollbacks after recovery; this way i can get it to work, but as the manual said i

Re: start innodb without transactions

2003-06-05 Thread Carlos Proal
t;Heikki Tuuri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject: Re: start innodb without transactions Date: Fri, 6 Jun 2003 04:23:57 +0300 Carlos, - Original Message - From: ""Carlos Proal"" <[EMAIL PROTECTED]> Newsgroups: mailing.datab

Innodb enable/disable keys

2003-01-19 Thread Carlos Proal
Hi, i have a simple question: The sql statement: alter table _table_name_ disable keys; has any action on "INNODB" tables ?, helps improving bulk inserts ?. thanx Carlos _ Help STOP SPAM: Try the new MSN 8 and get 2 months FR

Re: uploading 200,000 x 5 rows

2001-09-13 Thread Carlos Proal
> > > >Original Message Follows >From: "Rodney Broom" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Subject: Re: uploading 200,000 x 5 rows >Date: Thu, 13 Sep 2001 18:42:22 -0700 > >Hi Carlos, > >I'm glad to help, but I'd like to clarify several things, first. > >thanx a l

Re: uploading 200,000 x 5 rows

2001-09-13 Thread Carlos Proal
Original Message Follows From: "Rodney Broom" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject: Re: uploading 200,000 x 5 rows Date: Thu, 13 Sep 2001 18:42:22 -0700 Hi Carlos, I'm glad to help, but I'd like to clarify several things, first. thanx a lot ;) > ...with about 200,000

uploading 200,000 x 5 rows

2001-09-13 Thread Carlos Proal
Hi all, mysql-team i have a very very complicated problem , hope to be clear. i have a file report (.txt) with about 200,000 data about books (title, clasif, year, publisher, authors, subjects, etc etc) without tabs or separation, i built a parser to split each field and works fine. After e

Hardware advise

2001-06-20 Thread Carlos Proal
Hi all, i need to deploy a huge database (about 160 Gb) of information, mainly images and pdf documents, access will be aprox of 25 simultaneous connections in the worst case; so i need to choose the right hardware configuration and i need your help. We are thinking in a Sun Ultra 10

Installing in Solaris8 problem

2001-05-22 Thread Carlos Proal
Hi all, i have had several problems trying to install mysql on a Ultra60 sparc with Solaris8, i get the following messages running the configure script. I dont have any idea of why is this happenning, probably some related with 64 bits OS or something. Anyone have a clue ??? thanx friend

multiple databases performance

2001-02-14 Thread Carlos Proal
Hi all, glad to be back in the list :) I have a question related with a huge project, i could have these 2 schemes: 1) just one database with several tables database | tables DB_1 | user, profile, supplier, dept, etc... a lot of tables 2) several databases with few tables