REGEXP help Finding phone numbers (nnn) nnn-nnnn format
Hi, Please, can anyone lend a hand in helping pullout phone numbers from the DB that only match the format (nnn) nnn- ? SELECT phone_work FROM leads WHERE phone_work REGEXP 'the_expression?' I've been trying to lick this for hours now with no avail. Thank you, Paul -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Could somebody tell me how to use the memcache engine inside mysql?
Although I set up memcache engine successfully on my computer, I didn't know how to use it? I can not find where the document is. Here is my result of engines. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 11 Server version: 5.1.30 Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show engines; ++-++--+-++ | Engine | Support | Comment| Transactions | XA | Savepoints | ++-++--+-++ | InnoDB | YES | Supports transactions, row-level locking, and foreign keys | YES | YES | YES| | MEMCACHE | YES | Simple Interface for working with memcache as a storage engine | NO | NO | NO | | CSV| YES | CSV storage engine | NO | NO | NO | | BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO | | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO | | MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO | | ARCHIVE| YES | Archive storage engine | NO | NO | NO | ++-++--+-++ 8 rows in set (0.00 sec) mysql> Aborted Any reply is appreciated. -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
log_output variable
hi guys, mysql> show variables like '%output%'; +---+---+ | Variable_name | Value | +---+---+ | log_output | FILE | +---+---+ 1 row in set (0.00 sec) mysql> set global log_output=table; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table' at line 1 Server version: 5.1.30-enterprise-gpl-advanced-log MySQL Enterprise Server - Advanced Edition (GPL) It's the same situation on Linux and Win OS. Is this a bug for "set global log_output=table" on 5.1.30 which is GA just now??? *^_^* ___ 好玩贺卡等你发,邮箱贺卡全新上线! http://card.mail.cn.yahoo.com/
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 say to just use --skip-cache-host . Thanks, Tuc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: create single resultset from multiple sets
Hi Bryan, My gut reaction would be to use a temporary table - create the temporary table at the start of proc1, run multiple inserts into the temp table for the results of proc2, then just before proc1 ends, select from the temp table and drop it. Andy Cantwell, Bryan wrote: I have a procedure (proc1) that calls another procedure (proc2) several times. I'd like to make proc1 return the proc2 results in a single resultset. How can this be done in mysql 5.0.51? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
create single resultset from multiple sets
I have a procedure (proc1) that calls another procedure (proc2) several times. I'd like to make proc1 return the proc2 results in a single resultset. How can this be done in mysql 5.0.51? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[Q] FULLTEXT index question
Can one make a composite index with FULLTEXT for one column and standard indexing on another? For instance we have a table CREATE TABLE OurData ( TheText TEXT, TheLanguageID INTEGER ); We have a FULLTEXT index on TheText, but want to be able to do searches on TheText AND TheLanguageID. So, an index like ( FULLTEXT TheText, TheLanguageID ) would be nice. Is this possible? Tim... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQl and LVM
Simon, Thanks for the info, that is very useful. I still have a few questions though...I am considering setting up a 200GB LVM partition for the mysql data and a 70 GB LVM partition for the snapshots. Am I able to store several snapshots on the 70 GB partition? or do I need to take one snapshot and then move it..take another one then move it? Also...if anyone else is doing this...how often are you taking the snapshots...every 5 minutes, every hour, every 12 hours, etc? Thanks, Shain Simon J Mudd wrote: [EMAIL PROTECTED] (Shain Miley) writes: I am trying to plan we in advance our methods for backup and recovery of our new MySQL replication cluster. After doing some research it looks like a lot of people are using LVM snapshots as their backup solution. We currently have two MySQL servers with 2 300 GB (Raid 1). What I am confused about is the best disk layout to use at this point. Do I need to create a separate volume for the snapshots? Can anyone provide any suggestions on disk layout for two disks of this size? The filesystem layout is largely irrelevant. Basically what you want is to have all your mysql files on a separate LVM filesystem. So you could do this by creating a new filesystem and mounting it at /var/lib/mysql. Then install MySQL. Once you have the filesystem mounted you can use mysql as normal. To take snapshots do the following: 1. stop mysql 2. make a snapshot LV of the volume mounted at /var/lib/mysql 3. start mysql 4. mount the snapshot and back it up to a real filesystem or to tape or whatever. 5. unmount the snapshot and remove it. 4. Is very important as if you don't do this eventually the snapshot will run out of space and suddenly it will lose its contents. It's only a temporary staging area. Hope this helps. Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fwd: Updating from MySQL 4.0.12 to 5.0.67 Community
Crap. The list won't let me send the graphic through, and I can't host it anywhere ATM. When I run winmysqladmin.exe it comes up with a gui showing that it's version 1.4 and that's where it asks for a user/pass and says it's creating a my.ini -- Forwarded message -- From: Bai Shen <[EMAIL PROTECTED]> Date: Tue, Dec 2, 2008 at 10:25 AM Subject: Re: Updating from MySQL 4.0.12 to 5.0.67 Community To: mysql@lists.mysql.com But I didn't create any privileges in the old system. That's where I'm confused. When I install 4, I just click Next, accepting all of the defualts. Then I run winmysqladmin.exe(I can't connect to the db until I do). When I do this I get the screen shown in the attached screeenshot. Then I run mysql.exe and I can create the new database. When I install 5, I accepted all of the defaults except for setting a security password for root(since I didn't do that with 4). I don't have a winmysqladmin.exe to run, and mysqladmin.exe just quits on me. When I run mysql.exe and attempt to create a new database exactly as I did in 4, it gives me the error I mentioned in my original post. So, AFAIK, I'm not setting any privileges. I'm not sure how the admin user in the gui plays into it as I don't provide any login info when I run mysql.exe with 4 or 5. On Tue, Dec 2, 2008 at 1:26 AM, Chandru <[EMAIL PROTECTED]> wrote: > Hi Bai, > > In case you want the privileges of the old system, please take a backup of > the mysql database as inserts and reimport the same in the upgraded server. > If you want a new admin user to be created, then > please check the below page for the syntax: > http://dev.mysql.com/doc/refman/5.0/en/grant.html > > > Regards, > Chandru > www.mafiree.com > On Tue, Dec 2, 2008 at 3:48 AM, Claudio Nanni <[EMAIL PROTECTED]>wrote: > >> Hi Bai, >> I think the best option is to read carefully the installation guide, >> there are some post installation steps to set up initial privileges, >> and everything is explained quite well. >> After that if you still have problems please provide more informations on >> platform and other points >> like the steps and commands you issue and the output you get, >> so you 'help' others to help you, the more you are precise, the more you >> get help. >> >> Sincerely, >> >> Claudio >> >> >> Bai Shen wrote: >> >>> I currently have an application that runs on MySQL 4.0.12. I'd like to >>> update it to the newest version of MySQL so I can have multiple >>> applications >>> using the one database. However, I'm running into some permissions >>> problems. >>> >>> When I install MySQL 4.0.12 I set up an administrator user. Then I run >>> mysql.exe and I'm able to create a new database for the application. I >>> don't log in or anything like that. >>> >>> Now I've stood up MySQL 5.0.67 on another machine. I've recreated the >>> same >>> administrator user, but I'm not sure how to give them the priveleges, >>> since >>> I didn't do anything like that with the older version. And when I try to >>> create the database using mysql.exe I get the following error. >>> >>> ERROR 1044 (42000): Access denied for user ''@'localhost' to database >>> 'newdb' >>> >>> So I'm assuming that my permissions aren't setup correctly, but I'm not >>> sure >>> what I need to change. 5.0.67 seems to handle the administration fairly >>> differently than 4.0.12. Also, I'm not running the newer version as a >>> service. I don't think that would effect things, but I figured I should >>> mention it. >>> >>> TIA. >>> >>> Bai Shen >>> >>> >>> >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >> http://lists.mysql.com/[EMAIL PROTECTED] >> >> >
MySQL University session on December 4: What's new in MySQL optimizer
This Thursday (December 4th), Sergey Petrunia will highlight what's new in MySQL Optimizer, with a focus on MySQL 5.1. Since Sergey is one of the main developers in charge of MySQL Optimizer, you can expect to get some in-depth insights that only very few people could provide. The session will start at 14:00 UTC / 8am CST (Central) / 9am EST (Eastern) / 14:00 GMT / 15:00 CET / 17:00 MDT (Moscow). MySQL University is an educational program run virtually on the 'net. Sessions are open to anyone. MySQL University focuses on MySQL internals and on Sun technology that can be used in connection with MySQL, but we're open to hear your suggestions for other topics. We'll be using the Dimdim conferencing system for this session. Dimdim has integrated voice streaming and chat. To attend, you need a browser with a recent Flash plugin. You may register a Dimdim account but you don't have to. The virtual meeting room will open 15 minutes before the hour. Point your browser to this URL: http://webmeeting.dimdim.com:80/portal/[EMAIL PROTECTED] Related URLs: - MySQL University: http://forge.mysql.com/wiki/MySQL_University - http://forge.mysql.com/wiki/What%27s_New_in_MySQL_Optimizer Here's the MySQL University schedule for the rest of this year. Only two more sessions to go in 2008. All sessions start at 14:00 UTC / 8am CST (Central) / 9am EST (Eastern) / 14:00 GMT / 15:00 CET / 17:00 MDT (Moscow): December 11 - Random Query Generator - Philip Stoev December 18 - Using DTrace with MySQL - MC Brown In January, we'll likely continue with a set of sessions on performance and scalabilty – straight from the Sun QA labs. Find the tentative 2009 schedule on the MySQL University home page. Cheers, Stefan -- *** Sun Microsystems GmbHStefan Hinz Sonnenallee 1Manager Documentation, Database Group 85551 Kirchheim-Heimstetten Phone: +49-30-82702940 Germany Fax: +49-30-82702941 http://www.sun.de/mysql mailto: [EMAIL PROTECTED] Amtsgericht Muenchen: HRB161028 Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer Vorsitzender des Aufsichtsrates: Martin Haering *** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]