Error 1837

2017-05-04 Thread Ruben Cardenal
Hi, On a fresh new master-slave very simple setup with just a Magento 1.5 DB under MySQL 5.6.35, I'm getting this error with a memory table: 2017-05-03 07:08:37 1109 [Note] Slave I/O thread: connected to master 'replica@10.0.15.183:3306',replication started in log 'FIRST' at position 4 2017-05-

Re: ssh basics

2015-03-08 Thread Ruben Safir
On Sun, Mar 08, 2015 at 08:03:05PM +, Thufir wrote: > On Sun, 08 Mar 2015 08:43:41 -0400, Ruben Safir wrote: > > > > gmail sucks > > > You prefer yahoo mail? Just curious. > Your not curious. > > -Thufir > > > -- > MySQL G

Re: ssh basics

2015-03-08 Thread Ruben Safir
On Sun, Mar 08, 2015 at 12:20:10PM +, Thufir wrote: > On Sun, 08 Mar 2015 10:47:17 +0100, Reindl Harald wrote: > > > > oh my god... https://www.google.at/search?q=ssh+tunnel > Yah know ssh and mysql wasn't invented 20 minutes ago. They are basic tools for GNU users for almost

Re: forum vs email

2014-12-17 Thread Ruben Safir
room for computer terminals. Ruben On Thu, Dec 11, 2014 at 09:23:02AM +, Mark Goodge wrote: > On 10/12/2014 23:40, Reindl Harald wrote: > > > >Am 10.12.2014 um 18:38 schrieb h...@tbbs.net: > >>>>>>2014/12/10 09:00 +0100, Johan De Meersman >>>>

Re: MySQL dying?

2014-11-24 Thread Ruben Safir
On 11/24/2014 12:19 PM, Johan De Meersman wrote: > > > - Original Message - >> From: "Ruben Safir" >> Subject: Re: MySQL dying? > >> abandoned. What would you have done in those days when we handled so >> much mail in this list that the

Re: MySQL dying?

2014-11-24 Thread Ruben Safir
On 11/24/2014 12:19 PM, Johan De Meersman wrote: > > > - Original Message - >> From: "Ruben Safir" >> Subject: Re: MySQL dying? > >> abandoned. What would you have done in those days when we handled so >> much mail in this list that the

Re: MySQL dying?

2014-11-24 Thread Ruben Safir
On 11/24/2014 10:00 AM, Johan De Meersman wrote: > > - Original Message - >> From: "Ruben Safir" >> Subject: Re: MySQL dying? >> >> Well, this mailing list is dead. This is a mailing list that used to >> handle 70+ questions a day, or more.

Re: MySQL dying?

2014-11-24 Thread Ruben Safir
Well, this mailing list is dead. This is a mailing list that used to handle 70+ questions a day, or more. Ruben > There's a lot of haters (some with more valid reasons to hate, others with > little or no reason), but it cannot be denied that Oracle did not let MySQL > die.. >

Re: MySQL dying?

2014-11-22 Thread Ruben Safir
On Wed, Dec 05, 2012 at 12:41:09PM +0100, Johan De Meersman wrote: > - Original Message - > > From: "Anthony Pace" > > > > I have heard that due to Oracle taking over, the OS community is > > shifting to other type of DB's . > > I think the question has long been answered. However, out o

Re: Indexes issue importing tablespaces

2014-10-10 Thread Ruben Cardenal
, Rubén. El 2014-10-10 14:19, Wagner Bianchi escribió: > Did you check if an ANALYZE TABLE is enough in this case? > > -- > WAGNER BIANCHI > MOBILE: +55.31.8654. [2]9510 > > Em 10/10/2014, às 09:06, Ruben Cardenal escreveu: > >> Hi, >> >> I have t

Indexes issue importing tablespaces

2014-10-10 Thread Ruben Cardenal
Hi, I have this problem among several different instaces of 5.6.20. I take all the steps as stated in http://dev.mysql.com/doc/refman/5.6/en/tablespace-copying.html and get no errors neither warnings, neither in the cli or the mysql log. (13:23:02) [borrame] > alter table creditLine discard

C++ API

2011-03-06 Thread Ruben Safir
OK - I see there is more than one C++ API for MYSQL. Which one would someone recommend and why? Ruben -- http://www.mrbrklyn.com - Interesting Stuff http://www.nylxs.com - Leadership Development in Free Software -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

C++ Connect Installation

2011-03-05 Thread Ruben Safir
lding CXX object driver/CMakeFiles/mysqlcppconn.dir/mysql_art_resultset.o /home/ruben/src/mysql-connector-c++-1.0.5/driver/mysql_art_resultset.cpp: In member function ‘std::string sql::mysql::MyVal::getString()’: /home/ruben/src/mysql-connector-c++-1.0.5/driver/mysql_art_resultset.cpp:57: error: ‘snp

SELECT command denied to user 'user'@'localhost' for table 'table'

2009-06-16 Thread Ruben Rubio
5=0 OR column5=6 OR column5=12 OR column5=13 OR column5=14)) The user has SELECT privileges: GRANT USAGE ON *.* TO 'user'@'localhost' IDENTIFIED BY PASSWORD '*xxx' GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE ON `database`.* TO 'user'@'localhost'

Selecting doubles in a table and setting all but the first

2006-05-23 Thread Ruben Goethals
lution for 1 LicenseNumber, but for all the ones form the first query at once or twice, but not in 2068 times)Much appreciated any help!!!   Cheers, Ruben Goethals +32-(0)479/316655 [EMAIL PROTECTED]www.e-builds.com  

Re: Network drive

2005-07-07 Thread Ruben Carvalho
want to resume what was said here: - Even if it was possible, RDBMS over a network is not recommended - if you're working behind a firewall, you'd better open a port for your db server - adding SSL can help making it more secure --- [EMAIL PROTECTED] wrote: > Ruben Carvalho <[

Re: Network drive

2005-07-06 Thread Ruben Carvalho
ld then call the database running behind the proxy? --- [EMAIL PROTECTED] wrote: > Ruben Carvalho <[EMAIL PROTECTED]> wrote on > 07/06/2005 12:54:24 > PM: > > > Well, thank you very much for your explanation. > > > > My problem is I would like to have the d

Re: Network drive

2005-07-06 Thread Ruben Carvalho
EMAIL PROTECTED] wrote: > Ruben Carvalho <[EMAIL PROTECTED]> wrote on > 07/06/2005 11:06:10 > AM: > > > I think I haven't understood your question. I > guess > > that in case of a network failure you can have the > > same behavior as a power shut

Re: Network drive

2005-07-06 Thread Ruben Carvalho
I think I haven't understood your question. I guess that in case of a network failure you can have the same behavior as a power shutdown. About the networked drives? Anyone? --- Martijn Tonies <[EMAIL PROTECTED]> wrote: > Hi Ruben, > > > I would like to make a

Network drive

2005-07-05 Thread Ruben Carvalho
Hello everyone, I would like to make a short, quick and simple question. Is it possible to have the following line: innodb_data_home_dir="X:/data/" in a my.ini config file? I'm using windows XP, mysql 4.1.12, X: is a mapped network drive to a Linux folder using samba, all the permissions are s

Re: Triggers

2005-06-17 Thread Ruben Oliveira
yes there is : http://www.postgresql.org/docs/7.4/interactive/sql-createtrigger.html FOR EACH ROW FOR EACH STATEMENT This specifies whether the trigger procedure should be fired once for every row affected by the trigger event, or just once per SQL statement. If neither is specified, F

DELETE FROM statement seems not to use my index...

2005-01-17 Thread Ruben Edna
Here is create table def: CREATE TABLE `tblmainupdateinfo` ( `MainID` int(11) unsigned NOT NULL default '0', `ClientID` int(11) unsigned NOT NULL default '0', `UpdateInfo` tinyint(4) unsigned NOT NULL default '0', PRIMARY KEY (`MainID`,`ClientID`), KEY `ClientID` (`ClientID`) ) ENGINE=MyISAM

Re: Comparing Tables

2004-10-07 Thread Ruben Safir Secretary NYLXS
see IS NOT On Thu, Oct 07, 2004 at 07:22:23PM -0700, Jason Williard wrote: > I know that it is possible to do this, though I don't know how. > > I have 2 tables containing information about trouble tickets. One of the tables > (table2) contains information about every ticket ever received, in

Re: MySQL Databases in Subdirectories?

2004-10-07 Thread Ruben Safir Secretary NYLXS
How does that help? The database itself should be allowed to organize everything. Ruben On Thu, Oct 07, 2004 at 04:57:39PM -0700, Justin Smith wrote: > Is it possible to create a database in a lower-level subdirectory of > MySQL's data directory? We have almost 100,000 sites, a

Re: RETURNED MAIL: DATA FORMAT ERROR

2004-09-14 Thread Ruben Safir Secretary NYLXS
What is this? On Tue, Sep 14, 2004 at 10:28:53AM +0200, [EMAIL PROTECTED] wrote: > Your message was undeliverable due to the following reason(s): > > Your message could not be delivered because the destination computer was > not reachable within the allowed queue period. The amount of time > a me

Checking for live connections

2004-09-14 Thread Ruben Safir Secretary NYLXS
Is there a way of checking for live connections prior to using mysql_connect in the C API (asside from mysql_ping) Ruben -- __ Brooklyn Linux Solutions So many immigrant groups have swept through our town that Brooklyn, like Atlantis, reaches mythological

Segfault in mysql_real_escape_string

2004-09-06 Thread Ruben Safir Secretary NYLXS
Hello I'm getting a segmentation fault in the mysql function mysql_real_escape_string and I don't have a clue why. What am I missing? #include /* Headers for MySQL usage */ #include #include #include // #define INSERT_STATEMENT "INSERT INTO patient (idno,first,last,medrec) VALUES(NULL,?,?,

strmov

2004-09-05 Thread Ruben Safir Secretary NYLXS
What is the definition of strmov in C? It seems to be a MYSQL library sprecific function in m_string.h and is used in some of the documentations examples. ruben -- __ Brooklyn Linux Solutions So many immigrant groups have swept through our town that Brooklyn, like

Re: Help needed with MySQL C API-based client (segfault)

2004-09-04 Thread Ruben Safir Secretary NYLXS
The docs say to look at examples in the source directory, but those aren't yet clear to me to understand. Ruben > > /* client.c */ > > #include > #include > > int main() > { > /* declare > structures and variables */ > char query[255];

Re: why use MySql instead of Firebird or SQL Server express?

2004-07-26 Thread Ruben
Mysql is easier to install than Firebird and runs in more Operative Systems than SQL Server. Steve Richter wrote: In light of the licensing restrictions on using MySql in a commercial package, why would MySql be prefered over Firebird or SQL Server 2005 express edition. Both appear to be no charg

Re: 4.1 Beta

2004-06-01 Thread Ruben
there isn't a file with that name because there are several examples for different kinds of hardware setup, just rename the example that you think is right for you c:\mysql\ my-huge.cnf my-large.cnf my-medium.cnf my-small.cnf to c:\my.cnf Boyd E. Hemphill wrote: I just installed 4.0.18 under Win

Showing multiple query results on multiple pages, help with this script!!!!

2003-11-14 Thread Emilio Ruben Estevez
Hi, im using this script to show the query results, basically it shows multiple results in multiple pages, when more than one result are found it shows the first one and on the bottom of the pages it shows the number of pages that remains, but fot some strange reason when you click on the first or

Showing multiple results in multiple pages, this scripts doesnt work!

2003-11-14 Thread Emilio Ruben Estevez
Hi, im using this script to show the query results, basically it shows multiple results in multiple pages, when more than one result are found it shows the first one and on the bottom of the pages it shows the number of pages that remains, but fot some strange reason when you click on the first

how to change border color and type of mysql_row command!!!!?

2003-10-21 Thread Emilio Ruben Estevez
Hi, im using this script to show in a table the results of a query how can i change the border color and type is this posible?? if (mysql_num_rows($qry) > 0) { for ($i = 0; $i echo "" . mysql_field_name($qry, $i) . ""; } } ?> if (mysql_num_rows($qry) > 0) { for ($j = 0; $j

When inserting data it insert 2 records one correct and one blank!

2003-10-09 Thread Emilio Ruben Estevez
Hi, I have a page on a intranet where workers can insert data into a database, the thing is that when they type the info an press submit the page use the INSERT INTO db then when i check the data in the database i can see the record that the user entered and a second record that is all in

How can i make mysql to print date and time automatically?

2003-10-01 Thread Emilio Ruben Estevez
Hi, im develping an application, and was wondering how can i make mysql get time and date from pc and print it automatically in the time field and date field so the user dont have to worry about entering the coorect time and date. Is this posible, ive created a databse with fields hour(time) and

Re: MySQL & mail servers

2003-04-01 Thread Ruben Safir
Well To do selects on your mail archive? BTW - I've heard that Linux Magazine has developed into a handsom rag. Congradulations. I would never had thought it after seeing the first issue. Ruben On Tue, Apr 01, 2003 at 01:15:00PM -0800, Jeremy Zawodny wrote: > On Tue, Apr 01, 2003

Enum Columns

2003-04-01 Thread Ruben Safir
. Ruben -- __ Brooklyn Linux Solutions __ DRM is THEFT - We are the STAKEHOLDERS http://fairuse.nylxs.com http://www.mrbrklyn.com - Consulting http://www.inns.net <-- Happy Clients http://www.nylxs.com - Leadership Development in Free Software h

mysqlcc client

2003-02-02 Thread Ruben I Safir
. It just makes things hard and creates development chaos. There is no need to be on the bleeding edge all the time and to through backward compatability out the window. Frankly, I don't know why it even needs the Qt libraries. What is wrong with the standard X li

LWE - Dinner with Richard Stallman

2003-01-26 Thread Ruben I Safir
I wanted to thank Monty, Dave Axmart and the MYSQL team for coming to support the NYLXS - Free Software Institute in NYC this past week after LWE!! Monty - Your the greatest... but we all knew that Ruben -- __ Brooklyn Linux Solutions

Re: MYSQL Open Office

2003-01-24 Thread Ruben I Safir
> sql,query,queries,smallint What became of the discussion between Open Office.org and Monty at LWE? Ruben -- __ Brooklyn Linux Solutions __ DRM is THEFT - We are the STAKEHOLDERS http://fairuse.nylxs.com http://www.mrbrklyn.com - Consult

PostgreSQL-OOo

2003-01-11 Thread Ruben I Safir
>From the Open Office . org list On 2003.01.10 12:09 Josh Berkus wrote: Ruben, > Oh yes ... but it was in the short list of reasons to oppose using > Mysql > and it's what we call in Hebrew, Loshen Harah.. evil speach. Monty > and Dave > do not deserve this reputation.

(FROM THE OPEN OFFICE Mailing List) OOo...the Vision thing

2002-08-19 Thread Ruben I Safir
On 2002.08.20 01:09 Ruben Safir wrote: > > Of course. Monty would *love* you to get MySQL officially into > OpenOffice, and thereby secure a *huge* automatic userbase for MySQL... I doubt your installbase is a quarter of Monty's, and Monty doesn't need more users Everyo

Fwd: MYSQL/GNU-Linux CLasses by User Group in NYC [ruben@www2]

2002-08-04 Thread Ruben I Safir
SQL MYSQL On 2002.08.04 14:46 Ruben I Safir wrote: Revised Class Schedule Free Software Institute REVISED Class Schedule for August: Classes $300 individually perl 1 and 2 bundle $550 GNU/Linux 1 Unix 1 bunlde $550 -> Students talking GNU/Linux 1 are require to purchase a computer used for

MYSQL/GNU-Linux CLasses by User Group in NYC

2002-08-04 Thread Ruben I Safir
Revised Class Schedule Free Software Institute REVISED Class Schedule for August: Classes $300 individually perl 1 and 2 bundle $550 GNU/Linux 1 Unix 1 bunlde $550 -> Students talking GNU/Linux 1 are require to purchase a computer used for the rest of the corse work Complete program package -

Re: Permissions are now denied from the mysql client

2002-06-23 Thread Ruben I Safir
Of course it's running. I can only get in as the root user of the system On 2002.06.23 03:51 Brandon McCombs wrote: > > > Ruben I Safir wrote: > > > > I recently installed mysql on a new system and the client on works with root? > > > > Whats up? &g

Permissions are now denied from the mysql client

2002-06-22 Thread Ruben I Safir
I recently installed mysql on a new system and the client on works with root? Whats up? ruben@www2:~> !mys mysql -p Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) ruben@www2:~> -- __ Bro

mySQL and eVC++ app

2002-06-07 Thread Ruben Roberts
Hello, I created an eVC++ app for Pocket PC that uses libmySQL.lib, but it won't compile. It compiles when I comment out any references to any mySQL functions from the libmySQL dll. I initially used mysql++ but found out that it uses STL, which of course eVC++ doesn't support, so I was hopin

mySQL and eVC++ app

2002-06-07 Thread Ruben Roberts
Hello, I created an eVC++ app for Pocket PC that uses libmySQL.lib, but it won't compile. It compiles when I comment out any references to any mySQL functions from the libmySQL dll. I initially used mysql++ but found out that it uses STL, which of course eVC++ doesn't support, so I was hopin

mySQL and eVC++

2002-06-07 Thread Ruben Roberts
Hello, I created an eVC++ app for Pocket PC that uses libmySQL.lib, but it won't compile. It compiles when I comment out any references to any mySQL functions from the libmySQL dll. I initially used mysql++ but found out that it uses STL, which of course eVC++ doesn't support, so I was hopin

mySQL and eVC++

2002-06-07 Thread Ruben Roberts
Hello, I created an eVC++ app for Pocket PC that uses libmySQL.lib, but it won't compile. It compiles when I comment out any references to any mySQL functions from the libmySQL dll. I initially used mysql++ but found out that it uses STL, which of course eVC++ doesn't support, so I was hopin

Re: [hangout] Fwd: Re: Free Software Small Business and Government Demonstration [ruben@mrbrklyn.com]

2002-05-20 Thread Ruben I Safir
SQL > > > > One more point - > > Be sure to use the term GNU/Linux -- please > > thanks > > On 2002.05.20 22:33 Ruben I Safir wrote: > Can everyone PLEASE post this at the water cooler... > > Thanks > > > > GNU/LINUX BUSINESSDEMO

Re: ENUM Default values on NULL

2002-04-12 Thread Ruben I Safir
Your example is not the same, it sends only one value to a 2 value table. It definetely does not work if you send NULL INSERT VALUES(NULL) Ruben On 2002.04.12 14:10 Michael Stassen wrote: > > On Fri, 12 Apr 2002, Steve Katen wrote: > > > Ruben, > > > > If you lea

Re: ENUM Default values on NULL

2002-04-12 Thread Ruben I Safir
When I send a NULL it's rejected as bad data, which sort of makes sense On 2002.04.12 12:33 Steve Katen wrote: > Ruben, > > If you leave it as NOT NULL it should default to NO. "If an ENUM is > declared NOT NULL, the default value is the first element of the lis

Re: ENUM Default values on NULL

2002-04-12 Thread Ruben I Safir
sql > > ENUM can handle your needs. you should be able to just change your syntax > > to: FIELD ENUM('NO','YES') NULL > > > > under that syntax your default value will be NULL. > > > I need it to default to 'NO' not NULL -

Re: ENUM Default values on NULL

2002-04-12 Thread Ruben I Safir
> ENUM can handle your needs. you should be able to just change your syntax > to: FIELD ENUM('NO','YES') NULL > > under that syntax your default value will be NULL. We need it to default to 'NO' not NULL sql Ruben --

Re: ENUM Default values on NULL

2002-04-12 Thread Ruben I Safir
sql > > Hello > > I need a ENUM to default to a value when it gets a NULL. > > Can this be done. Right now is I set the column to > FIELD ENUM('NO','YES') NOT NULL > > It fails to insert when a NULL is entered. > > I want it to defa

Using MyODBC. Does ONE ADO query... Log shows THREE!!

2002-03-07 Thread Ruben Edna
ry SELECT * FROM tblProducts Ruben - 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 PROTECTE

Database files on user's personal

2001-12-06 Thread Ruben van Gogh
Hi, is it possible to put the mysql data base file on a users personal so that I can put a quota on it ?? Thanks, Ruben van Gogh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

User account

2001-09-04 Thread Ruben Domene
Hi all. I am beginner in mysql. I have installed mysql 3.23 under linux, and i want create one user for accessing to mysql. I have created the user: "gestor". If i am root when i execute: mysql i recived a error message: "ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)"

Persistant Connection

2001-02-09 Thread Ruben I Safir - Brooklyn Linux Solutions CEO
using DBI? Ruben -- Brooklyn Linux Solutions http://www.mrbrklyn.com http://www.brooklynonline.com 1-718-382-5752 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

NuSphere

2001-02-04 Thread Ruben I Safir - Brooklyn Linux Solutions CEO
What exactly is now the relationship between NuShpere and MYSQL/TSX. Who is working on the Gemini COde and the documentation? Ruben -- Brooklyn Linux Solutions http://www.mrbrklyn.com http://www.brooklynonline.com 1-718-382-5752