Re: subquery error with no result
Would this work for you? SELECT msgdata FROM sent_sms WHERE momt = 'MT' AND binfo IN (SELECT binfo FROM sent_sms WHERE momt = 'DLR') David On 5/21/08 10:30 PM, "sangprabv" <[EMAIL PROTECTED]> wrote: > Hi, > I tried to look for records from a table with this query: > SELECT msgdata FROM sent_sms WHERE momt = 'MT'AND binfo = ( SELECT > binfo FROM sent_sms WHERE momt = 'DLR' ) > But MySQL returns this error: > #1242 - Subquery returns more than 1 row > I tried also with ANY, IN, EXISTS. > And modified the query into: > SELECT t1.msgdata FROM (SELECT binfo FROM sent_sms WHERE momt = 'DLR') AS t1 > WHERE momt = 'MT'. But none works. > What I want to view is, all records which has momt = 'MT' and binfo from > the same table where has momt = 'DLR' and has the same binfo. TIA > > Regards, > > > Willy > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
DB - Data update for Dev server
Hello all, I think I saw this on an earlier post but I can't find it now. What I need to do: 1 - update data nightly into Dev Server 2 - only copy Data do not overwrite structure 3 - only update specific tables Any advice is greatly appreciated. David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Installing MySQL on Windows Server 2003 Standard x64 Edition
I still get the same error. Not sure what I'm doing wrong. On 8/25/06 5:49 PM, "Greg Joss" <[EMAIL PROTECTED]> wrote: > Go to Control Panel>System>Advanced. Click Environmental Variables and Find > the PATH variable under System Variables and add the full path, i.e. > c:\Program Files\...\mysql\bin to the variable. > > -----Original Message- > From: David Lazo [mailto:[EMAIL PROTECTED] > Sent: Friday, August 25, 2006 2:54 PM > To: mysql@lists.mysql.com > Subject: Installing MySQL on Windows Server 2003 Standard x64 Edition > > I'm having problems with MySQLInstanceConfig.exe - Unable To Locate > Component > >This application has failed to start because LIBMYSQL.dll was not found. > Re-installing the application may fix this problem > > I have tried to re-install, but I get the same message. > > I read the following related threads but didn't help. > http://lists.mysql.com/win32/14799 > > http://lists.mysql.com/mysql/167676 > > > I looked for the file and it exists in: > /mysql/bin/ > /mysql/lib/debug/ > /mysql/lib/opt/ > > This is the download I'm using for the installation: > Windows Server 2003 (AMD64 / Intel EM64T)5.0.24 > > Please advise. > > > David. > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Installing MySQL on Windows Server 2003 Standard x64 Edition
I didn't add it anywhere because the file exists in mysql/bin folder c:/program files/mysql/bin Does it need to be somewhere else?? On 8/25/06 5:03 PM, "João Cândido de Souza Neto" <[EMAIL PROTECTED]> wrote: > It could seems stupid, but you tried to put this file on c:\windows\system32 > or the similar folder of your system? > > "David Lazo" <[EMAIL PROTECTED]> escreveu na mensagem > news:[EMAIL PROTECTED] >> I'm having problems with MySQLInstanceConfig.exe - Unable To Locate >> Component >> >> This application has failed to start because LIBMYSQL.dll was not found. >> Re-installing the application may fix this problem >> >> I have tried to re-install, but I get the same message. >> >> I read the following related threads but didn't help. >> http://lists.mysql.com/win32/14799 >> >> http://lists.mysql.com/mysql/167676 >> >> >> I looked for the file and it exists in: >> /mysql/bin/ >> /mysql/lib/debug/ >> /mysql/lib/opt/ >> >> This is the download I'm using for the installation: >> Windows Server 2003 (AMD64 / Intel EM64T)5.0.24 >> >> Please advise. >> >> >> David. >> >> > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Installing MySQL on Windows Server 2003 Standard x64 Edition
I'm having problems with MySQLInstanceConfig.exe - Unable To Locate Component This application has failed to start because LIBMYSQL.dll was not found. Re-installing the application may fix this problem I have tried to re-install, but I get the same message. I read the following related threads but didn't help. http://lists.mysql.com/win32/14799 http://lists.mysql.com/mysql/167676 I looked for the file and it exists in: /mysql/bin/ /mysql/lib/debug/ /mysql/lib/opt/ This is the download I'm using for the installation: Windows Server 2003 (AMD64 / Intel EM64T)5.0.24 Please advise. David. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Windows Server Configuration
Thanx again. For the time being, we will keep 4 drives with Dan's suggestion. OS and MySQL running from there. On 8/25/06 11:03 AM, "Dan Buettner" <[EMAIL PROTECTED]> wrote: > James, with just 4 drives, you can set up one big RAID 10 disk > (usually called a "logical disk", with Dell PERCs I think it's a > "container"), and then partition it for your different needs. > > If you have 4 73 GB disks, you probably have around 135 GB formatted > capacity with RAID 10; I'd do something like this for my own MySQL > server in that situation: > > 20 GB C partition for OS and software binaries > 10 GB D partition for MySQL temp space > 20-40 GB E partition for MySQL binary logs (if you're using them) > remainder F partiition for MySQL data directory > > Your needs will vary depending on whether this server does only MySQL > or other serving as well, how big your databases are, whether you want > to keep binary logs for some period of time, and how large those > binary logs are. > > I agree with David's response that you want redundancy for the OS as > well. Drives fail, plain and simple. The single best thing you can > do with servers is plan for hardware failure. Having your data on > redundant disks is great, but if your OS is on a single drive, when > (not if, when) that one fails, your data is redundant but still > unavailable. > > You may pay a small performance penalty having the OS on the same > physical drives with your MySQL, but I'd make that sacrifice for the > redundancy, no question. On the other hand if you want to add a > couple of drives and make a separate RAID 1 pair for the OS, go for > it. > > Best, > Dan > > On 8/25/06, JamesDR <[EMAIL PROTECTED]> wrote: -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Windows Server Configuration
Thanks for all the recommendations. On 8/22/06 1:11 PM, "Dan Buettner" <[EMAIL PROTECTED]> wrote: > I second what James recommends re: spindles and RAID 10. Better than > RAID 5 for live data in my opinion; RAID 5 is decent for archival > storage. > > You've got a pretty decent setup there otherwise - 4 CPU cores, 8 GB > RAM - and you want to make sure your disks can keep things fed. > > As far as splitting things up: a general recommendation is to put > logging (replication logging that is, not the error log necessarily) > onto its own partition, ideally its own disks. Also consider putting > MySQL's temp space on its own partition, ideally its own disks. Of > course suddenly you're looking at a lot of disks if you really go > whole-hog... > > The optimization section in the online manual is pretty decent, though > some of the numbers are a bit dated (I saw one note this morning that > said "if you have at least 256 MB RAM"...) Also Jeremy Zawodny's book > "High Performance MySQL" is a good read, both in terms of optimizing > your SQL/data strcuture and in choosing abnd setting up your hardware. > > (Third time today I've plugged that book - I don't own stock or > anything, really) > > Dan > > > On 8/22/06, JamesDR <[EMAIL PROTECTED]> wrote: >> David Lazo wrote: >>> We want to get: >>> >>> Windows Server 2003 R2, Standard x64 Edition >>> 2- Dual Core Intel Xeon 5080, 2x2MB Cache, 3.73GHz, 1066MHz FSB >>> 8GB 533MHz (8x1GB), Dual Ranked DIMMs >>> 3- 146GB, SAS, 3.5-inch, 15K RPM Hard Drives >>> >>> What would be the recommended RAID configuration settings for a dedicated >>> MySQL db running on this system? >>> Also, what is the general advice for separating MySQL and the MySQL/Data on >>> different disks? >>> >>> I'm sorry if this sort of question has already been answered. >>> >>> Any help would be appreciated. >>> >>> David. >>> >>> >>> >> >> We built one pretty close to this recently. You definitely want to go >> with raid10, make sure the controller is hardware and not software raid >> (uses the CPU for everything, opposed to having a dedicated on board CPU) >> >> The more spindles the better, in order to use RAID10 you need an even >> set of disks, min 4. Raid10 gives you the best performance while keeping >> data redundancy. I would set it up like this: >> Raid1 -- OS (you could use slower/smaller drives here) >> Raid10 -- all of the mysql data -- as many spindles as you can afford. >> If you have to swap out 73GB drives for for the 146's to get more >> spindles, I would do that (that would increase cost a bit, but the disk >> sub system here would be the bottle neck, so you want to have it as fast >> as you can get it -- and still be affordable) >> >> This all depends on what your data environment looks like as well. >> >> -- >> Thanks, >> James >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] >> >> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Windows Server Configuration
We want to get: Windows Server 2003 R2, Standard x64 Edition 2- Dual Core Intel Xeon 5080, 2x2MB Cache, 3.73GHz, 1066MHz FSB 8GB 533MHz (8x1GB), Dual Ranked DIMMs 3- 146GB, SAS, 3.5-inch, 15K RPM Hard Drives What would be the recommended RAID configuration settings for a dedicated MySQL db running on this system? Also, what is the general advice for separating MySQL and the MySQL/Data on different disks? I'm sorry if this sort of question has already been answered. Any help would be appreciated. David. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]