Re: Granting all to a user with a db name prefix

Paco Zarabozo A. wrote: Hello All, I'm trying to GRANT ALL to a user only on DBs that math a prefix, but i can't find the way to so it on the documentation. Let's assume the username is "john". I want him to have all privileges only on databases with the prefix john, so he can: - create and

RE: Replication Problem

David, that error is only when doing a stop/shutdown. So it doesnt make a lot of sense that would be the problem. Here's the log where I did a stop and start. 060724 20:54:25 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown 060724 20:54:25 [ERROR] Error readin

RE: Replication Problem

Another suggestion, look for other files on the system ending in .MYD or put a query through that you know has updated a particular table/database and do a find looking for a file that has been updated in the last 5 minutes. See which ones have. Regards

RE: Replication Problem

David, It is pointing correctly. Plus, I can use a mysql browser and 3rd party tools on the slave server and read the databases/tables properly. I've tried stopping and restarting. I've rebooted... I'm baffled too, obviously. lol Thanks! Brett I am absolutely baffled as to how the

RE: Replication Problem

Hi Brett, I am absolutely baffled as to how the binlog/relaylog can be updated but the dbs/tables etc. are not being touched. The only other thing is to check the datadir on your server. Is it actually pointing to where you think it is? You can do a >SHOW VARIABLES LIKE 'datadir'; and check it

RE: Replication Problem

David, Thanks for attempting to help. When I look at my show slave status, its updating. When I look at the FMSbuilding-relay-bin, its updating! It has the information that's taken place on the master server. I can see information in the FMSbuilding-relay-bin on the slave server that I did

Granting all to a user with a db name prefix

Hello All, I'm trying to GRANT ALL to a user only on DBs that math a prefix, but i can't find the way to so it on the documentation. Let's assume the username is "john". I want him to have all privileges only on databases with the prefix john, so he can: - create and drop databases starting ON

RE: mysql + LVS

Hello, Just to make sure we separate the two... > mysql cluster that preforms reads on all the slaves, and writes only on the master. The above can be used to describe a typical use case for MySQL Replication. In a MySQL Cluster there is no need to load-balance your reads and writes. Thanks,

mysql + LVS

How stable has it become to run an instance of mysql ontop of a LVS cluster to produce a massively parrallel system to be used for huge databases? Back in the day i remember tyring to do it with mosix, not sure where they are now a days. but either way i am looking for some current information on

replicated queries are not placed in the binary log of dual master replication set up

Hi, I'm building a dual master set up that looks something like this: master A <-> master B || slave A slave B Replication between the masters works. Replication between the slaves and their respective masters works (ie, inserts on master A are repl

Re: Compilation Failure

Hi Ben, all! Ben Clewett wrote (re-ordered): Chris, Chris White wrote: On Monday 24 July 2006 08:36 am, Ben Clewett wrote: Making all in storage/archive if gcc -DHAVE_CONFIG_H -I. -I. -I../.. -I../../include -I../../include -DDBUG_OFF -O2 -mpowerpc64 -mminimal-toc -maix64 -Wa,

mysql_stmt_bind_param error

I tried to execute the example code (see below) from the function mysql_stmt_execute I found in mysql 4.1 documentation (http://dev.mysql.com/doc/refman/4.1/en/mysql-stmt-execute.html). This source code runs perfect under linux red hat with version 4.1.7 but it prints out an error if I try to run i

RE: Replication Problem

Hi Brett, I am a little bit lost as to why this is happening. The only suggestion I have at this point is to go through the replication troubleshooting in this chapter and see if something there is causing the problem. Looking at what you have done and the docs, I don't think this will help. This

mysqldump large file (>2GBs) : some tests

Hello This is kind of a follow up of the previous thread "Got errno 27 on write. file too large" and kind of a survey. The problem was : on a solaris 9, 64 bits and mysql 4.1.7, I could not mysqldump in a file more than 2G . Thank you to the people that help me. I make a new thread since my

RE: a struggle with float type display and width

I searched some more and then I found Bug # 10897 - FLOAT and DOUBLE obeying precision and scale. No documentation. http://bugs.mysql.com/bug.php?id=10897 Regards, Martin. > > Hi, > > I've recently changed MySQL versions and I am puzzled by the difference in > display of float values. >

a struggle with float type display and width

Hi, I've recently changed MySQL versions and I am puzzled by the difference in display of float values. CREATE TABLE test ( id int unsigned NOT NULL auto_increment, val1 float default NULL, val2 float(3,3) default NULL, val3 float(5,3) default NULL, val4 float(10,6) default NULL, PRIM

Re: Compilation Failure

Chris, Previous version which did compile was 4.1.9. May be glibc was not required for this version. Glibc is not native to AIX so I can see some fun ahead. Thanks, Regards, Ben Chris White wrote: On Monday 24 July 2006 08:36 am, Ben Clewett wrote: Making all in storage/archive

Re: Segmentation fault error accrued when gcc -o test -L/usr/lib/mysql -lmysqlclient test.c

On Sunday 23 July 2006 10:26 pm, ali asghar torabi parizy wrote: > while ((row = mysql_fetch_row(res_set)) != NULL) { while (row = mysql_fetch_row(res_set)) would do the same thing, NULL check shouldn't be necessary. > for (i=0; i

Re: Compilation Failure

On Monday 24 July 2006 08:36 am, Ben Clewett wrote: > Making all in storage/archive > if gcc -DHAVE_CONFIG_H -I. -I. -I../.. -I../../include > -I../../include -DDBUG_OFF -O2 -mpowerpc64 -mminimal-toc -maix64 > -Wa,-many -MT azio.o -MD -MP -MF ".deps/azio.Tpo" -c -o azio.o azio.c; >

Compilation Failure

Dear List, I compiled 5.1.6 on Linux, works perfectly. Been running for a few weeks, now want to port to live server. Same compilation on AIX 5.2.0.0, I get: Making all in storage/archive if gcc -DHAVE_CONFIG_H -I. -I. -I../.. -I../../include -I../../include -DDBUG_OFF -O2 -m

RE: Synro MySQL databases

Hello, Does this change need to occur at exactly the same moment? Might want to take a look at replication for starters if you are not familiar with the technology. http://dev.mysql.com/doc/refman/5.0/en/replication.html SQLyog also offers some interesting synching http://www.webyog.com/sqlyog

Re: Synro MySQL databases

On Monday 24 July 2006 16:16, Brian E Boothe wrote: > HI all i have a question, I have A server MySQL database in our > office location that stores Contact information / inventory etc... and > also we have a Internet Site > NOw what id like to perform is Whenver Someone changes something in the

Synro MySQL databases

HI all i have a question, I have A server MySQL database in our office location that stores Contact information / inventory etc... and also we have a Internet Site NOw what id like to perform is Whenver Someone changes something in the office to our Database, it also changes on our website ,,

Need Restore Help

I have a backup that was created by a MySQL 5 server using MySQLDump. When I try to restore the database using the following command: mysql -u root -p -D BPA < c:\backup\mydata.sql I get the error: ERROR 1064 (42000) at line 29765: You have an error in your SQL syntax; check the manual that c

MySQLHotCopy

I read in the manual that MySQLHotCopy would be better than MySQLDump for backing up MyISAM tables. However, I cannot find a .exe in the bin directory by that name. I found a script by that name in a 4.1 installation that I have, but I don't think it's the latest version. Is this a script? I

RE: Replication Problem

David, I could try and create a table. But I've got it set just for the one database "FMS". The error log, last night, was showing this (I think I had it in my first post) 060723 21:01:11 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=20

Will UPDATE block on SELECT?

I would like to know whether a SELECT query would block an Update on the same table. The table is of InnoDB type. Since InnoDB tables apply row level locks should the Update queries be blocked until the select query completes? I experienced such a scenario wherein an update query had to wait unt

RE: Replication Problem

Hi Brett, Just about to go when your email rocked up 8-) Like you, I can't see any reason why it is not replicating according to the logs. Have you tried to create a database on the master and see if it appears on the slave? What commands are being replicated at this time? You can use the mysqlbi

RE: Replication Problem

David, mysql> show master status\g +---+--+--+--+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +---+--+--+--+ | FMSweb-bin.01 | 903763 | |

RE: Replication Problem

Hi Brett, Can you please do the following : >SHOW MASTER STATUS; (on the master) and >SHOW SLAVE STATUS; (on the slave) Thanks P.S I will be going to bed soon so don't worry if you don't hear anything, I'll look at it first thing in the morning. -

RE: Replication Problem

Dave, I tried reset slave as you mentioned - no change. Nothing updating. Same error. Brett Aah, sorry, I didn't explain myself very well 8-( At the mysql prompt RESET SLAVE; This tells the slave to reset itself back, and forget the current settings (eg. the log position etc., not the maste

Re: Struggling with the logic

As mentioned before you really should sue the date data type in mysql, or alternativly use an int and store the date as seconds since the epox, so that you can do simple math for this type of query. Any other way of storing dates is basically shooting yourself in the foot. That said, if you ch

Re: Searching through an alphabetical range

Depending on the size of your table, it can be faster using SELECT lastname FROM employee WHERE lastname BETWEEN 'm' AND 'z' GROUP BY lastname; On a table with 2,5 Mill. records the speed diff is over 1000% on my system. ViSolve DB Team wrote: Hello Paul, You can try this: SELECT DISTINCT

Re: Select Query taking time

Ratheesh K J wrote: Hello All, I run a select query to see its speed. It took around 5 seconds. Now i run the same query simultaneously twice usng two instances of the client tool. It took 10 seconds for both the queris to complete. Its not 5 secs + 5 secs. Both the queries were running til

RE: undefined reference to `mysqlpp::Connection::Connection(bool)'

Hi Ali, I'll repeat what I've already said, it is the ld command that is having the problem. If you don't know what the ld command is or does, you need to look elsewhere for the answer as this is beyond the scope of this list. As I have previously mentioned, try $ man ldconfig Your problem i

RE: undefined reference to `mysqlpp::Connection::Connection(bool)'

Hi.thanks logan. I am begeener to MySQL. I have installed Suse10 and MySQL and mysql++ in my pc. i trying too many pathes in gcc cammand but that error continued. I am getting the following error. # gcc -o custom1 -lmysqlclient -L /usr/local/my

RE: undefined reference to `mysqlpp::Connection::Connection(bool)'

Hi Ali, Your problem is as it states /usr/lib/gcc/i586-suse-linux/4.0.2/../../../../i586-suse-linux/bin/ld: cannot find -lmysqlclient collect2: ld returned 1 exit status The linker, ld, does not know where to find the library libmysqlclient.so. You need to tell the linker using either ldconfig

undefined reference to `mysqlpp::Connection::Connection(bool)'

Hi, I am begeener to MySQL. I have installed Suse10 and MySQL and mysql++ in my pc. i want to connect to MySQL through C. When I am compiling the program, I am getting the following error. #gcc -o custom1 -lmysqlclient -lz custom1.cpp /usr

Re: Struggling with the logic

At 17:31 -0700 23/7/06, [EMAIL PROTECTED] wrote: The logic is that it follows the natural spoken format, i.e. "July 23, 2006"; which became the written standard; which... Hmmm. Is 'July the 23rd, 2006' any more natural to say than 'the 23rd of July, 2006'? I think we probably say either, equal

Re: Select Query taking time

On Monday 24 July 2006 09:06, Duncan Hill wrote: > On Monday 24 July 2006 09:05, Ratheesh K J wrote: > > Hello All, > > > > I run a select query to see its speed. It took around 5 seconds. Now i > > run the same query simultaneously twice usng two instances of the client > > tool. It took 10 second

Re: Select Query taking time

On Monday 24 July 2006 09:05, Ratheesh K J wrote: > Hello All, > > I run a select query to see its speed. It took around 5 seconds. Now i run > the same query simultaneously twice usng two instances of the client tool. > It took 10 seconds for both the queris to complete. Its not 5 secs + 5 > secs.

Select Query taking time

Hello All, I run a select query to see its speed. It took around 5 seconds. Now i run the same query simultaneously twice usng two instances of the client tool. It took 10 seconds for both the queris to complete. Its not 5 secs + 5 secs. Both the queries were running till 10 secs when i saw usi

Re: Struggling with the logic

Hi Chris, John all! Chris' explanation is nearly correct: Chris Sansom wrote: At 15:43 +0100 23/7/06, John Berman wrote: I have a table called: submissions and each record has an approvedate field which stores the date mm/dd/ Why? If you're storing the date in this format [[...]] Joh