Access MySQL Enterprise Monitor UI Remotely

Hi all, How can I access MySQL Enterprise Monitor webpage remotely. I don't want to access it through the localhost, but would like to access it like this: https://192.1.1.1:18443. Where can I change the settings so that the tomcat can listen for incoming connections from my network card, rath

replication issue from ec2 to my network ..

Hi, I have configured replication from EC2 mysql instance to another mysql instance on our network via vpn in between. Sometimes it is showing no errors on the slave but the slave falls behind . When I issue the commands stop slave ; start slave ; it again catches up with the master. What is t

Fwd: strange mysql update ..

Any update from anybody ? -- Forwarded message -- From: umapathi b Date: Thu, Sep 8, 2011 at 4:28 AM Subject: Re: strange mysql update .. To: Ananda Kumar Cc: mysql@lists.mysql.com Here is the o/p after the update .. user_id: 16078845 drivers_license

Re: strange mysql update ..

password: test1140dl certificate_number: NULL login: test114...@1140dl.com - Umapathi On Thu, Sep 8, 2011 at 4:23 AM, Ananda Kumar wrote: > Can you lets us know what is the output of > > select * from user_info where user_id=16078845; > > > On Thu, Sep 8, 2011 at 1

strange mysql update ..

I wanted to change the login_date of one user . The original data of that user is like this .. select * from user_info where user_id = 16078845 \G *** 1. row *** user_id: 16078845 drivers_license: TEST1140DL login_date: 2011-06-

Efficient use of sub queries?

I was wondering if any one could point out potential problems with the following query or if there was a better alternative >From a list of users I want to return all who don't have all the specified user_profile options or those who do not have at least one preference set to 1. The following quer

Performing subtraction between fields

Hello, For simplicity's sake, let's say I have three fields, A, B and C, all of which are integers. I'd like the value of C to be equal to A less B (A-B). Is there a way I can perform this calculation? I'm guessing it would happen when I INSERT a row and specify the values fo

Re: Fwd: Re: Help Save MySQL

suggest using Monty (if he aggrees) letter as base and start spreeding the word. Bruno B. B. Magalhães Sócio-Diretor de Negócios e Tecnologia BLACKBEAN CONSULTORIA Rua Real Grandeza 193/210, Botafogo Rio de Janeiro, RJ, 22281-035, Brasil +55 (21) 9996-1093 +55 (21) 2266-0597

Fwd: Re: Help Save MySQL

ing to the media like TechCrunch.com, BusinessWeek, ZD.Net, etc. Without society's engagement we won't acomplish anything! Regards, Bruno B. B. Magalhães Sócio-Diretor de Negócios e Tecnologia BLACKBEAN CONSULTORIA Rua Real Grandeza 193/210, Botafogo Rio de Janeiro, RJ, 22281-035, B

Re: Help saving MySQL

: Until the last consequences. More info at: http://www.yachtingmagazine.com/article.jsp?ID=170610 Best Regards, Bruno B. B. Magalhães BLACKBEAN CONSULTORIA Rua Real Grandeza 193, Sala 210, Botafogo Rio de Janeiro, RJ, 22281-035, Brasil +55 (21) 9695-2263 +55 (21) 2266-0597 www.blackbean.com.br Esta

Re: Help Save MySQL

Maybe a three-years consul composed from and elected by the community (by community I mean the people that contributed with funds, not the user community) by voting? Regards, Bruno B. B. Magalhães BLACKBEAN CONSULTORIA Rua Real Grandeza 193, Sala 210, Botafogo Rio de Janeiro, RJ, 22281-035

Re: Help Save MySQL

ative... Course, there are many others management problems and legal issues to solve, but if anybody would join me I would be the first one! And also would be a REMARKABLE adventure and maybe the next step for the open source initiatives around the world... Best Regards Bruno B. B. Magalhães BLAC

Re: right join troubles

On 09/19/2009 10:07 AM, Thomas Spahni wrote: On Sat, 19 Sep 2009, b wrote: I'm trying to select all members who have not registered for an event. I have tables 'members', 'events', and 'events_members', the latter a join table with event_id and member_id c

right join troubles

I'm trying to select all members who have not registered for an event. I have tables 'members', 'events', and 'events_members', the latter a join table with event_id and member_id columns. The closest I've gotten is with this query: SELECT m.id, m.first_name, m.last_name FROM members AS m RIGH

Re: UNIQUE KEY vs UNIQUE INDEX

On 07/30/2009 02:23 PM, Joerg Bruehe wrote: Hi ! mos wrote: At 09:13 AM 7/30/2009, b wrote: Are UNIQUE KEY& UNIQUE INDEX two ways of specifying the same thing? If not, what are the differences? Feel free to tell me to RTFM but please post manual chapters. I've been looking but hav

UNIQUE KEY vs UNIQUE INDEX

Are UNIQUE KEY & UNIQUE INDEX two ways of specifying the same thing? If not, what are the differences? Feel free to tell me to RTFM but please post manual chapters. I've been looking but haven't been able to find anything. -- MySQL General Mailing List For list archives: http://lists.mysql.co

Re: MySQL Windows version

russbucket wrote: > > I agree with you, but phpMyAdmin is not available for Windows that I'm aware > of. The person I'm helping today is a windows user and except for a little > Access Experience does not do databases well. I have the database set up in > mysql so thats what I am hoping to get h

Re: COUNT from 2 tables

On 07/08/2009 06:11 PM, Gary Smith wrote: Create a view or sub select, denormalizing the data and then group it. select month, sum(login) as num_logins, sum(download) as num_downloads from ( select monthname(s.created) as month_name , if(ifnull(s.id, 0)> 0, 1, 0) as login , if(ifnull(d.id, 0)>

Re: COUNT from 2 tables

On 07/08/2009 03:33 PM, Gary Smith wrote: Off the top of my head, try this. SELECT MONTHNAME(s.created) AS month, sum(if(ifnull(s.id,0)> 0, 1, 0)) AS num_logins, sim(if(ifnull(d.id, 0)> 0, 1, 0)) AS num_downloads FROM sessions AS s LEFT JOIN downloads AS d ON d.session_id = s.id GROUP BY month

COUNT from 2 tables

I'm trying to get a count for columns in 2 tables at once. I have sessions and downloads tables and would like to get some basic stats. mysql> describe sessions; +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra

Re: Database Import from Oracle

Hi guys, the easiest is to use MySQL Migration Toolkit, I've sucessfuly used it with SQL Server (2000 and 2008) and Oracle 9i, all with simple structures and simple data, but worked VERY well... Regards, Bruno B. B. Magalhães Sócio-Diretor de Negócios e Tecnologia BLACKBEAN CONSUL

Re: What's wrong with user defined variable in this MySQL 5.1 example?

mos wrote: At 03:14 AM 1/19/2009, b wrote: mos wrote: I'm using MySQL 5.1.30 (WinXP) and user defined variables don't seem to be working properly if the Select statement is sorted. Here is a simple example: CREATE TABLE `tmp` ( `Purch_Date` date DEFAULT NULL,

Re: What's wrong with user defined variable in this MySQL 5.1 example?

INE=MyISAM DEFAULT CHARSET=latin1 Here are the values that I entered in this order: Purch_DateProduct 2007-01-01A 2007-01-04B 2008-05-04B 2008-12-04B 2001-01-04D 2001-01-04C Now here is the Select statement that is failing: set @num:=0;select @num:=...@num+1, Purch_Dat

help refactoring query

I'm having some difficulty getting my head around a particular query. I'd like to make this a view once I get something working. However, all I've been able to come up with uses a sub-query. So, no view on the horizon. I have 3 tables: users id, (etc. the usual) disciplines id, name (

Cache Hosts - Which are tempting max_connect_errors?

Hi, Is there a way in 4.X or 5.0 to tell which hosts are running up the counter towards max_connect_errors? We'd like to be able to monitor this and act accordingly? I've seen that they suggest to set it to 9 in 13.5.5.2 FLUSH Syntax to avoid it. I'm just wondering why they didn't

SssS Generic modeling...

:00:00','0','-00-00 00:00:00','1','-00-00 00:00:00'); What would be followed by (a trigger perheaps or the application it self) the queries: ALTER TABLE `TB1` ADD `CL11` INTEGER(20) NOT NULL DEFAULT NULL AUTO_INCREMENT

MySQL Magazine Summer Issue Released

The next issue of MySQL Magazine is now available for download. Get it while it is hot! At forty-two great pages it is our biggest and best issue yet. This issue is anchored by the first annual MySQL Usage Survey results. Downloads at the MySQL Magazine homepage: http://www.mysqlzine.net Thanks

Re: integer

I think you'll find that's BIGINT, max INT is 11 Moon's Father wrote: The maximum width is int(20). On Thu, May 22, 2008 at 5:15 PM, Saravanan <[EMAIL PROTECTED]> wrote: what kind of datatype it is int(50) parent_id| int(50) is that big int? Saravanan --- On Thu, 5/22/08, Norb

Re: [mysql] Re: SELECT to return 0 instead of NULL?

> > On Fri, May 23, 2008 at 8:23 AM, Tuc at T-B-O-H.NET <[EMAIL PROTECTED]> wrote: > > Hi, > > > >I'm running a query : > > > > SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='hotspot'; > > > >But if the

SELECT to return 0 instead of NULL?

Hi, I'm running a query : SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='hotspot'; But if there aren't any rows in "radacct" for the UserName of "hotspot", it returns a NULL. Is there a way to change it to return 0 instead? (I can't change the application, but I can cha

Call for Articles for MySQL Magazine - Summer Issue

Hey everyone!! Just wanted you to know that it's "that time". The summer issue of MySQL Magazine will be coming out July the 15th. That means that it is time to start gathering the articles. If you have interest in having your words read by thousands of people and having fame and fortune com

Re: Practical hierarchies

e or recursive query? For example: SELECT RECURSIVE * FROM ProductsCategories USING ProductCategoryParentID = ProductCategoryID Is this syntax factive? Best regards, Bruno B. B. Magalhães BLACKBEAN CONSULTORIA Rua Real Grandeza 193/210, Botafogo Rio de Janeiro, RJ, 22281-035, Brasil +55 (2

Practical hierarchies

logsCategoriesIndexD` (` CatalogCategoryCreatedOn `,`CatalogCategoryModifiedOn`,`CatalogCategoryRemovedOn`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 Pros: SQL friendly so much less processing and queries required, very export / inport friendly Cons: Fixed deep and a little bit more difficult

Re: Migration from 32-bit to 64-bit MySQL

Olaf Stein wrote: Probably not AFAIK it should work in theory if you have no floating point columns but I would not try it. Why cant you take a dump, you can do it table by table, you will have some downtime though. One option might be to use a 64bit slave and make that the master and then add

Re: Migration from 32-bit to 64-bit MySQL

Mike wrote: I would like to move from 32-bit to 64-bit MySQL within the next year. Unfortunately, there is not a lot of documentation on migration or anything else regarding 64bit MySQL. My current setup consists of one master and two slaves (all using 32bit and MySQL 5.0). I am looking to add a

Re: Performance

nt_id,bap_sat.transactions.client_unit_id 1 Seems that the transactions table is the sort of the problem, as it's using file sort and where... But my myisam sort cache is big, I thing it's about 80MB or so... Thank you everybody for your help!!! Best Regards, Bruno B B Magalhae

Performance

mn to maintain the index small? Most of the financials reports today takes about 8 to 12 seconds to be generated for one month (course that I have to sum previous months totals to give the balance). Thanks in advance... Regards, Bruno B B Magalh'aes -- MySQL General Mai

Re: How hard is it to move from on server to another?

A simple rsync should do the trick. How long will depend on how much data you have. I would just shut down the server, copy over the data directory and start the new server up. Should be a piece of cake. Keith David Ruggles wrote: I have a MySQL 5.x box and I am thinking about moving it to

Re: Spring 2008 MySQL Magazine released!!

Brown wrote: On Tue, Apr 15, 2008 at 2:20 PM, B. Keith Murphy <[EMAIL PROTECTED]> wrote: Hey everyone, I just posted the Spring issue of the MySQL Magazine. This issue contains a great group of articles that you will want to read. In addition, Sheeri Cabral did a fabulous job with a n

Spring 2008 MySQL Magazine released!!

Hey everyone, I just posted the Spring issue of the MySQL Magazine. This issue contains a great group of articles that you will want to read. In addition, Sheeri Cabral did a fabulous job with a new layout for the magazine. It is as always FREE!!. Available for download from http://www.my

Re: procedure locks all statemens

When it selects values from the myisam table it is locking the entire table. Saravanan wrote: Hi Lists, i have created a procedure. It selects values from a myisam table and updates an innodb table one by one ( not as huge update it clearly use where clause). but whenever I run the procedure

Re: MySQL for Datamining

Sorry I can't recommend anything offhand, but this type of message does not need to go to the internals mailing list. Thanks, Keith Haitham Kaddoura wrote: Hi, does anyone use the or know a data mining package in MySQL? -- Keith Murphy editor: MySQL Magazine http://www.mysqlzine.ne

Re: Certified MySQL Associate (CMA) certification value

have at least a baseline of knowledge. If you're looking for a job, you could hardly go wrong with it, IMO. [...] Yeah, I think that I'm going for the certification, although I can't imagine what kind of job I could land -- junior DB admin? I don't have a college degree :

Re: suggestion for disk configuration

, from small to quite big (tables with about 2M rows). I've got a SAS disk array and I was wondering what the best configuration could be: 1) raid 10 2) raid 5 3) a combination (e.g., raid10 for the data and raid 5 for the logs). Any suggestion or link? Thanks, Luca -- B. Keith M

Re: mysql replication

will resync from last known state. I believe that if the logging on master was switched off, it will have no record of the changes made to database and I will need top recopy the database, but just to confirm or if there is any simpler way. Thanks -- B. Keith Murphy Paragon Consulting

Re: turn a slave back into its own master

_ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping -- B. Keith Murphy Paragon Consulting Services http://www.paragon-cs.com 850-63

Re: Computerworld reporter would like to hear from you ASAP today, on MySQL,acquisition by Sun...

le, PHONE NUMBER, > e-mail address and what you do for a living -- whether programmer, > consultant, etc. My name is Billy B. Bilano. I am the Director of Information Technology at "a Major US Bank". If you need anything more, please contact me directly by emailing [EMAIL PROTECTED]

Upcoming Mandatory Changes post-Sun Acquisition

our TIME AND ATTENTION!!! p.S> SELECT visit.my.bloglog ON internets AT www.bilano.biz WHEN PRIORITY = "now"; -- Mr. Billy B. Bilano, MSCE, CCNA, CISSP, and now QISP <http://www.bilano.biz/> Expert Sysadmin Since 2003! 'C:\WINDOWS, C:\WINDOWS\GO, C:\PC\CRAWL' -- R

MySQL Magazine Spring Issue -- Call for Articles

have some submissions on php development with MySQL. Hope to hear from you soon! keith -- B. Keith Murphy Paragon Consulting Services http://www.paragon-cs.com 850-637-3877 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.

MySQL Magazine - Winter Issue released

I just posted the latest edition of MySQL Magazine. It is available for free download from http://www.mysqlzine.net. Take a look! Keith -- B. Keith Murphy Paragon Consulting Services http://www.paragon-cs.com 850-637-3877 -- MySQL General Mailing List For list archives: http

Re: Red Hat EL and Datbase Setup

vity contained in this communication. -- B. Keith Murphy Paragon Consulting Services http://www.paragon-cs.com 850-637-3877 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: automation question

ng to scale efforts so I don't have to manually do things. thanks, Keith B. Keith Murphy wrote: Martin, Martin Gainty wrote: 3 ideas come to mind- cron and or cruisecontrol for off-hours scripting ant for handling cross-platform scripting maven for implementing dependency checking as w

Re: automation question

> technologies (I am modestly familier with "expect" and have touched > "dsh"). > > Thoughts?? > > thanks, > > keith > > > -- > B. Keith Murphy > > Paragon Consulting Services > http://www.paragon-cs.com > 850-637-3877 > >

automation question

o put some serious thought into automating some things. I was wondering what experience others have had with any technologies (I am modestly familier with "expect" and have touched "dsh"). Thoughts?? thanks, keith -- B. Keith Murphy Paragon Consulting Services htt

Re: best practice MySQl backup onto tape

ter than a traditional dump/restore and are much more compact. These tools (and a number of others) are located at maatkit.sourceforge.net.net. Hope that helps. Keith -- B. Keith Murphy Paragon Consulting Services http://www.paragon-cs.com 850-637-3877 -- MySQL General Mailing List For l

Re: SQL analysis tool - open source?

.com/[EMAIL PROTECTED] -- B. Keith Murphy Paragon Consulting Services http://www.paragon-cs.com 850-637-3877 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Replication Falls Out Of Sync With LOAD DATA

a LOT. It's so simple that I suspect something else. But then again, I don't know what you mean by "out of sync" :) On Nov 28, 2007 4:32 PM, B. Keith Murphy <[EMAIL PROTECTED]> wrote: What versions of MySQL are you using on both the master adn the slaves? Ke

Re: Replication Falls Out Of Sync With LOAD DATA

What versions of MySQL are you using on both the master adn the slaves? Keith Michael Stearne wrote: We have replication set up for 1 master and 4 slaves. When resynced everything appears to work fine. Come back a couple hours later and the machines are out of sync. The only thing I can think

Re: preferred way to backup a 20GB MySQL database

I would echo what Dan says. In addition, from the slave server, you might look at running the new mysql-parallel-dump tool that Baron Schwartz has developed. It essentially does a dump with a thread running (by default) for each CPU core you have. A dual core box will run two threads and dum

Re: Spfile in Mysql......

This has probably already been over-talked about :) but I will throw my two cents in. I would be very much opposed to a situation where changes made on-the-fly are stored permanently in the my.cnf file. If I decide to keep a change to a server setting I am very much capable of doing it myself

Re: mysql replication....

bruce wrote: hi... a quick question that i haven't found an answer to. i can use "replicate-do-db=foo" in a my.cnf file for replication, to replicate the master foo db on the slave. but this requires that i use/have a my.cnf set on the slave. is there a way to dynamically set this attribute/pa

Re: Replication vs. mysql-table-sync

Michael Stearne wrote: Is mysql-table-sync design to be used as a fix for when your replication is out of sync OR can it be used instead of replication? Thanks, Michael You need to use replication not mysql-table-sync for replication. mysql-table-sync is use to get it back in sync. keith

Re: innodb rollback question

erable failure. - Original Message From: B. Keith Murphy <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Sent: Friday, November 16, 2007 10:29:17 AM Subject: innodb rollback question I have something to throw out. I just got done importing 140 million rows from a myisam table to a innodb tabl

Re: Problem with master/slave replication

Ryan, show slave status after it stops copying should give you some type of error information about the failure. What does it show? Keith Ryan Klein wrote: I am having an issue that I cannot determine the cause. We have a master server that is actually a production server and a slave server

innodb rollback question

I have something to throw out. I just got done importing 140 million rows from a myisam table to a innodb table. While it worked I had a thought about 3/4ths of the way through. What if the transaction had been canceled about 130 million rows in? It would have taken weeks to roll back. Th

Re: Mysql and filesystems question

file systems I have come across for MySQL Production. On 10/28/07, *B. Keith Murphy * <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote: In production we use both reiserfs and xfs. I am migrating our data partitions for mysql because it has faster write rates than reiserfs

Re: Mysql and filesystems question

In production we use both reiserfs and xfs. I am migrating our data partitions for mysql because it has faster write rates than reiserfs. You need to stop using fedora and at least use CentOS. Fedora is not stable for production work. Just my two cents :) Keith Ali Nebi wrote: Hi, i wan

MySQL Magazine "Call for articles"

Hey everyone, I am starting on putting together the Winter issue of the MySQL Magazine. This will be our third issue and it is getting better each time! Here is your opportunity to contribute to the community. I am accepting ideas/outlines/proposals for articles for this issue through Nove

Re: open_files_limit problem.

- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- B. Keith Murphy Database Administrator iContact 2635 Meridian Parkway, 2nd Floor Durham, North Carolina 27713 blog: http://blog.paragon-cs.com (o) 919-433-0786 (c) 850-637-3877

Re: how to restore mysql database after Crash

Recover your files first and then you can see where you can go. I suppose you now have backup plans in place now? Keith David Winslow wrote: Hey, Environment: Windows 2003 server Mysql 5.0 server Problem: Our server crashed and the c drive was formatted. Unfortunately we did not

Re: mysql user password funkyness

Thanks everyone for the replies. The problem revolved around '%' vs 'localhost'. To me, it seems logical that '%' would include localhost..not really true. So, I have it figured out. thanks, Keith - Original Message - From: "B. Keith Murphy"

mysql user password funkyness

---+ There are other privileges for the appropriate databases but they really aren't relevant. thanks, Keith -- B. Keith Murphy Database Administrator iContact 2635 Meridian Parkway, 2nd Floor Durham, North Carolina 27713 blog: http://blog.paragon-cs.com (o) 919-433-0786 (c) 850-637-3877

MySQL Magazine Issue Two released

Just wanted to let everyone know that the second issue of the MySQL magazine has been uploaded. It is available from http://www.paragon-cs.com/mag/mysqlmag.html Our featured articles include: MySQL Maintenance script -a multi-threaded tool for database maintenance MySQL Table Checksum How-To

Re: make a slave db a master db

ster db, so what are the steps that i need to take to make one of the slaves as a stand alone master db. regards anandkl -- B. Keith Murphy Database Administrator iContact 2635 Meridian Parkway, 2nd Floor Durham, North Carolina 27713 blog: http://www.paragon-cs.com/wordpress (o) 919-433-0786 (c) 850-637-3877

Re: run out of memory

, Worcester, England, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- B. Keith Murphy Database Administrator iContact 2635 Mer

Re: run out of memory

chas trying to use lots of memory in 64-bit systems? Thanks Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- B. Keith Murphy Database Administrator iContact 2635 Meridian Parkway, 2nd Floor Durh

Re: Enterprise Wide Deployment

e.com/Enterprise-Wide-Deployment-tf4265688.html#a12139896 Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- B. Keith Murphy Databa

Re: run out of memory

startup successfully. Why this mysqld can't support large memory usage?How to improve it? Thanks! --jen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- B. Keith Murphy Database Adm

Re: innodb to be removed? and...

find any trace in the net yet) and what about potential future storage engines in mysql, or will there be myisam as the one and only feature blown one? Thanks in advance, Christian Parpart. -- B. Keith Murphy Database Administrator iContact 2635 Meridian Parkway, 2nd Floor Durham, North Carolina 27713 (o) 919-433-0786 (c) 850-637-3877

Re: performance of extended insert vs. load data

of? FWIW these are 95% innodb (5% myisam are static reference tables & can be done in advance). thanks! -- B. Keith Murphy Database Administrator iContact 2635 Meridian Parkway, 2nd Floor Durham, North Carolina 27713 (o) 919-433-0786 (c) 850-637-3877

speeding imports

hanks, Keith -- B. Keith Murphy Database Administrator iContact 2635 Meridian Parkway, 2nd Floor Durham, North Carolina 27713 (o) 919-433-0786 (c) 850-637-3877

Next MySQL Magazine --call for articles

. If you want to send me some ideas for articles you can either reply to this email address or bmurphy at paragon-cs.com. Thanks again, Keith -- B. Keith Murphy Database Administrator iContact 2635 Meridian Parkway, 2nd Floor Durham, North Carolina 27713 (o) 919-433-0786 (c) 850-637-3877

mysqldump/restore

take the time to sit there and hit the up-arrow to retrieve the command and then type in the new file name. Is there some way to automate this data import? Thanks, Keith -- B. Keith Murphy Database Administrator iContact 2635 Meridian Parkway, 2nd Floor Durham, North Carolina 27713 (o) 919-433-0786 (c) 850-637-3877

Re: off-topic unsubscribe concern

ists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- B. Keith Murphy Database Administrator iContact 2635 Meridian Parkway, 2nd Floor Durham, North Carolina 27713 (o) 919-433-0786 (c) 850-637-3877

Re: user backup tool

I think it was Baron's toolkit I was thinking of... the command mysql-show-grants seems to do the trick. Thanks, Keith - Original Message - From: "B. Keith Murphy" <[EMAIL PROTECTED]> To: "mysql" Sent: Wednesday, June 27, 2007 4:11:54 PM (GMT-

user backup tool

I know there is a tool out there to grab the user info from the mysql database and store it like versioning control. I thought it was in Baron's toolkit but unless I have had too much caffeine and can't read I don't see it on his website. What am I thinking of? Thanks, keith

Re: toutrial needed

Weiqi, You might want to take a look at the book "MySQL Tutorial". It is in a second edition and available from Amazon. In addition there are numerous guides available on the Internet. Devshed (http://www.devshed.com/c/b/MySQL/) for example has 90 articles on mysql. Of course many o

Re: acquire mysql knowledge in short time

ist archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- B. Keith Murphy Database Administrator iContact 2635 Meridian Parkway, 2nd Floor Durham, North Carolina 27713 (o) 919-433-0786 (c) 850-637-3877

How to parition a table with a VARCHAR Primary Key?

Hi, I'm struggling with getting my tables partitioned. All the tables I want to partition have a single primary key id which is a varchar. They also have a created datetime field to let me know when each record was added to the db. Ex: CREATE TABLE `document` ( `document_id` varchar(50) NOT NUL

MySQL Magazine - Issue 1 available NOW!!!!

Everyone, I have just uploaded the first issue MySQL Magazine to http://paragon-cs.com/mag/issue1.pdf Please take a look at it. There is a great deal of information here and I think it is worth some time. Feedback is always welcome. thanks, Keith Murphy -- MySQL General Mailing List F

SAN backend for DB's

So here is the brief situation. We have a coraid (www.coraid.com) SAN unit - the 1520 I believe. It is ATA-over-ethernet. Right now we have a about 500 gigs of data spread across five servers. To simplify things I would like to implement the coraid on the backend of these servers. Then al

Connection time out/slow response from server

Hi, Running 4.1.22 created from FreeBSD ports on FreeBSD 5.5 . I run under TCP Wrappers. Even if 1 foreign machine attempts to contact us on the tcp port, the database becomes incredibly sluggish or unresponsive at all. Is there something I can do to prevent this from h

Re: Integrity on large sites

OK. Going to try this again. After reading through these emails I think I have learned a little more about the way you are thinking. I DO NOT want to start some kind of flame war. However, I disagree very strongly with what you are saying. Yes, you are right, sharding does require more com

Re: Integrity on large sites

Sometimes partitioning is absolutely necessary. If you can't run a cluster - how else can you really scale writes to the database? Some companies can't use clustering because in 5.0.x (the "non-beta" release) clustering is all done in memory - all tables have to be in memory (just like the ol

Re: time taken by mysqldump

Have you considered replicating to a backup server and then dumping from it? No matter your processors with a 100gb db it is going to take a significant amount of time. Keith Ananda Kumar wrote: Hi All, We have database of around 100GB, and planning to take dump using mysqldump. Can you

TCPWrappers and database unavailibility

Hi, Running 4.1.22 created from FreeBSD ports on FreeBSD 5.5 . I run under TCP Wrappers. Even if 1 foreign machine attempts to contact us on the tcp port, the database becomes incredibly sluggish or unresponsive. phpmyadmin shows " MySQL said: #2003 - The server is not

Re: How to limit usage of mysql server's memory/cpu for each databases ?

Halid Faith wrote: I use mysql4.1.22, php4.4.6 and apache2.0.59. I want to put an quota for each databases and mysql users. How can I do that mysql will limit each database's memory usage? Because some mysql users sometimes use much memory while doing a sql query. Also How can I put an quota fo

Re: Deleted Root Account

I have had exactly the kind of trouble you are talking about. Sorry I didn't see the messages until just now. Had to manually remove crap too even though I purged (rpms - centos I think). Hopefully this will help others down the road. Keith John Kebbel wrote: Even though I complet

Re: Enforcing Data Format

Baron Schwartz wrote: Hi, Tim Milstead wrote: Hello, Is it possible to enforce data formatting in fields using something like a regular expression? varchar is great but does not stop someone putting in the wrong reference number. I suspect the answer is no, you have to do it at a higher le

Re: Summer issue - MySQL e-zine

. Otherwise, if you create a logo in some type of graphics format (png would be appreciated though) I can bring it into my layout work. If you have interest let me know and I will email you a pdf of the cover. thanks, Keith B. Keith Murphy wrote: Everyone, I have received quite a bit of

  1   2   3   4   5   6   >