different size under the two OS
Hello DBAs, Though this is not exactly a mysql problem, but I think this list may be helpful for my question. I have dumped a mysql data file, and scp it to another host. The current host is ubuntu-8.04, the remote host is ubuntu-9.10. As you can see below: The current host: $ md5sum fcm.0812.sql.gz ea08ec505c1b1724213538fed7483975 fcm.0812.sql.gz $ lsb_release -r Release:8.04 $ du -k fcm.0812.sql.gz 418080 fcm.0812.sql.gz The remote host: $ md5sum fcm.0812.sql.gz ea08ec505c1b1724213538fed7483975 fcm.0812.sql.gz $ lsb_release -r Release:9.10 $ du -k fcm.0812.sql.gz 417672 fcm.0812.sql.gz Though the files in two hosts have the same md5sum, but why they have different size with 'du -k' showed? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: does mysql support master to master replication
I have been using the M-M replication over years. But we only write to one node at any time. When this node is unusable, we write to another node. On Wed, Aug 3, 2011 at 1:10 PM, Angela liu yyll2...@yahoo.com wrote: Hi, Folks: Does mysql support master to master replication, or master to slave replication on;y? I did not find the answer in MySQL manual, but found some discussion over the internet. Does anybody know? if so, anybody has implemented master to master replication in production? Thanks Angela -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Group By Problem
You need to group by event_text, not obj_text: select source_id ,event_text,count(*) from event_loc group by source_id,event_text; Date: Tue, 8 Feb 2011 16:31:39 +0530 From: adarsh.sha...@orkash.com To: mysql@lists.mysql.com Subject: Group By Problem Dear all, I stuck around one more simple problem today. I have a table named *event_loc* having below data : ( It has many columns but I show you main columns that I needed ) _*Tables Data :-*_ *source_id event_text* 1233 meet 1233 meet 1345 ends 1345 ends performs 13456 Minister 1233 Argentina 1233 meet 1345 ends 1555 is As described above there are more than 10 rows and I want my output as : _*Output Needed :-*_ *source_id event_text Count* 1233 meet 3 1233 Argentina 1 1345 ends 3 performs 1 13456 Minister 1 I tried the below query : *select source_id ,event_text,count(*) from event_loc group by source_id,obj_text ;* But displays only unique record_id rows but I want as mentioned output. Failed to achieve the mentioned output. Thanks Regards Adarsh Sharma
RE: Question about database value checking
Are you using the strict SQL mode? Check your my.cnf file. Peter Date: Fri, 4 Feb 2011 14:08:01 -0800 From: awall...@ihouseweb.com To: mysql@lists.mysql.com Subject: Question about database value checking So, a problem popped up today that has caused us no end of hair-pulling, and it brought to mind a similar issue that I found very, well, wrong. If you have a table defined: CREATE TABLE `tester_table` ( `acnt` varchar(20) NOT NULL DEFAULT '', `method` varchar(10) NOT NULL DEFAULT '', `card_num` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`acnt`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 And try this: INSERT INTO tester_table (acnt, method, card_num) VALUES ('test1', 'push', NULL); That fails. and gives a nice error. But: INSERT INTO tester_table (acnt, method, card_num) VALUES ('test1', 'push', 'A12345'); UPDATE tester_table set card_num = NULL WHERE acnt = 'test1'; That succeeds, but it puts an empty string into the card_num column. I would have thought (hoped) that an error would be thrown in that case as well. On a similar note, the following table: CREATE TABLE `tester_table2` ( `acnt` varchar(20) NOT NULL, `required` enum('NO','DETAILS','RESULTS') NOT NULL, PRIMARY KEY (`acnt`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 Lets you insert: INSERT INTO tester_table2 (acnt, required) VALUES ('A123456', 'THIS IS NOT REAL'); Though it just puts an empty string into the required column. Is there a setting for mysql to return errors in these cases? It seems silly to set up an enum column, or a not null column, and not have the possible values enforced? thanks, andy -- Andy Wallace iHOUSEweb, Inc. awall...@ihouseweb.com (866) 645-7700 ext 219 -- There are two ways to build software: Make it so simple that there are obviously no bugs, or make it so complex that there are no obvious bugs. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=phe1...@hotmail.com
Re: Oracle, Sun and MySQL
I believe MySQL will still have great influence in Open Source area. The better is that MySQL will be a separate Company which has no relation to Sun and Oracle. Maybe Oracle can sell MySQL to a 3rd company. 2009/11/11 John Daisley john.dais...@butterflysystems.co.uk What I am more concerned about at the moment is how much the uncertainty over the deal is hurting MySQL? I was recently in a project planning meeting where MySQL was dismissed completely because nobody could give guarantees about where MySQL was going. There were a lot of concerns over where future development would go and a fear that when the deal goes through Oracle may slowly raise support and training costs to the sort of levels applicable to Oracle database products. These kind of arguments seem impossible to counter for as long as the uncertainty continues and I for one wish they would just resolve the situation either way very quickly because its hurting my business and open source software! regards John On Tue, 2009-11-10 at 23:50 -0600, Peter Brawley wrote: European regulators agree with Monty that the Oracle-Sun deal threatens database competition. Apparently Oracle means to play hardball. Meanwhile Sun revenue fell 25% in 3rd quarter 2009; who else but an anti-competitive giant would take a chance on buying Sun now? Story here: http://www.economist.com/businessfinance/displayStory.cfm?story_id=14840272; source=features_box1. PB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=hexi...@gmail.com -- Thanks Best regards, Xiong HE
Re: Question about MySQL
Hi Gavin, I am interested in the things you made for the optimization. Can you share with us such things? Thanks a lot, -- Banyan He Network System Security Infrastructure Mail: ban...@rootong.com Blog: http://www.rootong.com/blog LinkedIn: http://www.linkedin.com/in/banyanhe Website: http://www.rootong.com From: Gavin Towey gto...@ffn.com Date: Fri, 7 Aug 2009 11:07:19 -0700 To: joerg.bru...@sun.com joerg.bru...@sun.com, Peter Chacko peterchack...@gmail.com Cc: mysql mysql@lists.mysql.com Subject: RE: Question about MySQL I always accepted that NFS was unacceptably slow for database access, until I actually tested it. Turns out that with lots of RAM and properly tuned caches, you're optimizing for minimal IO anyway. A good file server will have massive amounts of IO OPS. On top of that if you're using GigE over few hops, then it's really not slower than local disks. Remember: benchmark and test your assumptions! Regards, Gavin Towey -Original Message- From: joerg.bru...@sun.com [mailto:joerg.bru...@sun.com] Sent: Friday, August 07, 2009 1:19 AM To: Peter Chacko Cc: mysql Subject: Re: Question about MySQL Hi Peter, all, let me just concentrate on the NFS aspect: Peter Chacko wrote: [[...]] Another question is , whats the general experience of running MySQL servers on NFS shares ? I would *never* use NFS storage for any DBMS (except for some testing): NFS access is slower than local disk access, and it adds more components to the critical path. So your operations get slower, reliability decreases, and (in case of any trouble) analysis becomes more difficult. I cannot imagine any setup where you have a machine strong enough to run your DBMS on it, but not capable of driving sufficient local disks. The typical argument for having centralized disks serving many machines is based on economies of scale (huge disks), flexibility (partitioning), and centralized management (RAID replacement, backup). There may be some merit to this in a specialized setup (NAS systems - I'm not convinced of them, but don't claim expert knowledge about them), but IMO not using general-purpose machines and NFS. Whatever the economical advantages during normal operation may be, you should not forget the huge costs you would incur if any in-between component breaks and your database stops operating. This may be tolerable for some applications, depending on the required availability, but simply intolerable for others. We are working on developing a custom protocol for MySQL clustering that takes care of all file management as part of the database clustering protocol, rather than a storage engine feature. Sorry, I don't get the meaning of this in sufficient detail to comment. What are the likely setup of a database storage ? Is it on RAW partition or on a File system ? That may depend on the storage engine used. MyISAM uses a file-per-table approach, so must be run on a file system; InnoDB may be able to use a raw partition (I'm not sure there); for others, I can't tell. Will ocfs2 be better used for mySQL as well, in a clustered environment ? I strongly doubt it. AIUI, the big advantage of cluster file systems is that they allow all machines to access and modify shared data. With a DBMS, you don't want to share data across machines, you want the database to be accessed only be the one machine (possibly multi-CPU, but shared memory) running the database processes, because on that machine you have the various database caches. Then, that machine makes the data available to all clients, so you get a logical sharing on a higher protocol level (SQL). To have multiple machines accessing the same database storage, you would first need some protocol to ensure cache coherency, and that is not contained in MySQL (in the general server). To use MySQL on multiple machines for the same data, you set up replication. The alternative approach would be to use MySQL Cluster, which is designed to hold the data in main memory (for extremely low latency) and to use the disk only for backup purposes. I would appreciate if any one share with me their thoughts on this. My comments above are based on my experience during DBMS development (including distributed DBMS), but not on any financial calculations or DBA work. Weigh them with other answers. Regards, Jörg -- Joerg Bruehe, MySQL Build Team, joerg.bru...@sun.com Sun Microsystems GmbH, Komturstraße 18a, D-12099 Berlin Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Wolf Frenkel Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB161028 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com The information contained in this transmission
Re: Does anyone know how mysql works for mutiple kernels of a cpu.
Hiya, I think this one may be helpful. http://www.mysql.com/search/?q=processorscharset= Amit Sharma wrote: Hi Moon's Father, I thought you meant how mysql works for multiple processors of a cpu. If so, have a look at 'http://www.google.com/search?q=mysql+for+multiple+processors' Regards, Amit Sharma [EMAIL PROTECTED] Amit Sharma E: [EMAIL PROTECTED] M: +91 9971 490 700 W: www.affle.co.uk -Original Message- From: Moon's Father [mailto:[EMAIL PROTECTED] Sent: 18 December 2007 12:33 To: mysql@lists.mysql.com Subject: Does anyone know how mysql works for mutiple kernels of a cpu. Any reply is appreciated,thanks. -- Banyan He MailWeb Security Mobile: +86 13641777622 MSN: [EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] AntiSpam Test: [EMAIL PROTECTED] AntiVirus Test: [EMAIL PROTECTED] Wemaster Mail: [EMAIL PROTECTED] Website: http://www.rootong.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL only listens on localhost
Check your my.cf file a /etc/my.cf. To add the bind-address = ip at the end of the file. Restart your mysql. And grant the access to the user who you want to connect your database from where you can accept. Franz Edler wrote: Hello, Can anyone please give me a hint what I can do that MySQL also listens to the physical address of the host. I see that MySQL listen only to 127.0.0.1:3306 and therefore every connection via the physical interface is reset. What can I do? Regards Franz -- Banyan He MailWeb Security Mobile: +86 13641777622 MSN: [EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] AntiSpam Test: [EMAIL PROTECTED] AntiVirus Test: [EMAIL PROTECTED] Wemaster Mail: [EMAIL PROTECTED] Website: http://www.rootong.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
error once backing up database
Hi Guys, I encounter an issue once I backup the database. mysqldump -u admin -phost --databases message_tracker z:sqlbackup.sql mysqldump: Got error: 1044: Access denied for user 'admin'@'localhost' to database 'message_tracker' when using LOCK TABLES I am using windows as the OS. Any advices will be appreciated. Regards, -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] http://www.rootong.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: error once backing up database
Thx Ananada. Actually, I don't have the admin permission on this server. The grant command is unavailable for me. I have no ideas about this. I install the software on two machines, one of them can issue this command and works fine with it. Another cannot. OS: windows 2003 Cheers, Ananda Kumar wrote: Looks like this user does hot have permission on message_tracker while connecting on the local host. try this. grant all on message_tracker to 'admin'@'localhost' mailto:[EMAIL PROTECTED] identified by 'password'; and then try you mysqldump regards anandkl On 7/19/07, *Banyan He* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi Guys, I encounter an issue once I backup the database. mysqldump -u admin -phost --databases message_tracker z: sqlbackup.sql mysqldump: Got error: 1044: Access denied for user 'admin'@'localhost' to database 'message_tracker' when using LOCK TABLES I am using windows as the OS. Any advices will be appreciated. Regards, -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.rootong.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] http://www.rootong.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: error once backing up database
Yes, the server shows me that. I cannot execute the grant command. This is a serious restriction software works with mysql. Ananda Kumar wrote: You mean to say, you cannot execute the GRANT command. regards anandkl On 7/19/07, *Banyan He* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Thx Ananada. Actually, I don't have the admin permission on this server. The grant command is unavailable for me. I have no ideas about this. I install the software on two machines, one of them can issue this command and works fine with it. Another cannot. OS: windows 2003 Cheers, Ananda Kumar wrote: Looks like this user does hot have permission on message_tracker while connecting on the local host. try this. grant all on message_tracker to 'admin'@'localhost' mailto:[EMAIL PROTECTED] identified by 'password'; and then try you mysqldump regards anandkl On 7/19/07, *Banyan He* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi Guys, I encounter an issue once I backup the database. mysqldump -u admin -phost --databases message_tracker z: sqlbackup.sql mysqldump: Got error: 1044: Access denied for user 'admin'@'localhost' to database 'message_tracker' when using LOCK TABLES I am using windows as the OS. Any advices will be appreciated. Regards, -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.rootong.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.rootong.com -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] http://www.rootong.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: error once backing up database
The question is in this server, I cannot backup the database by issuing mysqldump. On another server, I can. I am sure nobody changes the settings. That's confusing to me. ant command because you don't have permission to do so. The GRANT command allows you to set permissions on databases and tables, thereby giving access to possibly sensitive data. It is in no way a serious restriction, it is a very important security feature. If you don't have the grant permission and need it, ask your database administrator to set up rights. Don't assume that what may be easier for you in other software environments, is the better solution. In this case, it clearly is not. regards, boro Banyan He schreef: Yes, the server shows me that. I cannot execute the grant command. This is a serious restriction software works with mysql. Ananda Kumar wrote: You mean to say, you cannot execute the GRANT command. regards anandkl On 7/19/07, *Banyan He* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Thx Ananada. Actually, I don't have the admin permission on this server. The grant command is unavailable for me. I have no ideas about this. I install the software on two machines, one of them can issue this command and works fine with it. Another cannot. OS: windows 2003 Cheers, Ananda Kumar wrote: Looks like this user does hot have permission on message_tracker while connecting on the local host. try this. grant all on message_tracker to 'admin'@'localhost' mailto:[EMAIL PROTECTED] identified by 'password'; and then try you mysqldump regards anandkl On 7/19/07, *Banyan He* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi Guys, I encounter an issue once I backup the database. mysqldump -u admin -phost --databases message_tracker z: sqlbackup.sql mysqldump: Got error: 1044: Access denied for user 'admin'@'localhost' to database 'message_tracker' when using LOCK TABLES I am using windows as the OS. Any advices will be appreciated. Regards, -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.rootong.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.rootong.com -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] http://www.rootong.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: error once backing up database
thx Ananda. I will try. Cheers, Ananda Kumar wrote: Hi Banyan, Permission can vary from database to database. Please ask your dba to grant you the permission and then try the mysqldump On 7/19/07, Banyan He [EMAIL PROTECTED] wrote: The question is in this server, I cannot backup the database by issuing mysqldump. On another server, I can. I am sure nobody changes the settings. That's confusing to me. ant command because you don't have permission to do so. The GRANT command allows you to set permissions on databases and tables, thereby giving access to possibly sensitive data. It is in no way a serious restriction, it is a very important security feature. If you don't have the grant permission and need it, ask your database administrator to set up rights. Don't assume that what may be easier for you in other software environments, is the better solution. In this case, it clearly is not. regards, boro Banyan He schreef: Yes, the server shows me that. I cannot execute the grant command. This is a serious restriction software works with mysql. Ananda Kumar wrote: You mean to say, you cannot execute the GRANT command. regards anandkl On 7/19/07, *Banyan He* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Thx Ananada. Actually, I don't have the admin permission on this server. The grant command is unavailable for me. I have no ideas about this. I install the software on two machines, one of them can issue this command and works fine with it. Another cannot. OS: windows 2003 Cheers, Ananda Kumar wrote: Looks like this user does hot have permission on message_tracker while connecting on the local host. try this. grant all on message_tracker to 'admin'@'localhost' mailto:[EMAIL PROTECTED] identified by 'password'; and then try you mysqldump regards anandkl On 7/19/07, *Banyan He* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi Guys, I encounter an issue once I backup the database. mysqldump -u admin -phost --databases message_tracker z: sqlbackup.sql mysqldump: Got error: 1044: Access denied for user 'admin'@'localhost' to database 'message_tracker' when using LOCK TABLES I am using windows as the OS. Any advices will be appreciated. Regards, -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.rootong.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.rootong.com -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] http://www.rootong.com -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] http://www.rootong.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: error once backing up database
Ananda, I cannot host the reasons. Just add one more parameter to avoid LOCK TABLES. mysqldump --lock-tables=false db That works. Cheers, Thx guys. Ananda Kumar wrote: Hi Banyan, Permission can vary from database to database. Please ask your dba to grant you the permission and then try the mysqldump On 7/19/07, Banyan He [EMAIL PROTECTED] wrote: The question is in this server, I cannot backup the database by issuing mysqldump. On another server, I can. I am sure nobody changes the settings. That's confusing to me. ant command because you don't have permission to do so. The GRANT command allows you to set permissions on databases and tables, thereby giving access to possibly sensitive data. It is in no way a serious restriction, it is a very important security feature. If you don't have the grant permission and need it, ask your database administrator to set up rights. Don't assume that what may be easier for you in other software environments, is the better solution. In this case, it clearly is not. regards, boro Banyan He schreef: Yes, the server shows me that. I cannot execute the grant command. This is a serious restriction software works with mysql. Ananda Kumar wrote: You mean to say, you cannot execute the GRANT command. regards anandkl On 7/19/07, *Banyan He* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Thx Ananada. Actually, I don't have the admin permission on this server. The grant command is unavailable for me. I have no ideas about this. I install the software on two machines, one of them can issue this command and works fine with it. Another cannot. OS: windows 2003 Cheers, Ananda Kumar wrote: Looks like this user does hot have permission on message_tracker while connecting on the local host. try this. grant all on message_tracker to 'admin'@'localhost' mailto:[EMAIL PROTECTED] identified by 'password'; and then try you mysqldump regards anandkl On 7/19/07, *Banyan He* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi Guys, I encounter an issue once I backup the database. mysqldump -u admin -phost --databases message_tracker z: sqlbackup.sql mysqldump: Got error: 1044: Access denied for user 'admin'@'localhost' to database 'message_tracker' when using LOCK TABLES I am using windows as the OS. Any advices will be appreciated. Regards, -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.rootong.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.rootong.com -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] http://www.rootong.com -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] http://www.rootong.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Problem on millions of records in one table?
Hi, Baisley How did you config your DB? Did you specify one single file or several files to store your DB? I am not sure whether it affects the performance as well. And Could you give more details about your merge tables. Your experience is greatly useful for us, thanks a lot. -Original Message- From: Brent Baisley [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 18, 2007 9:37 PM To: He, Ming Xin PSE NKG; mysql@lists.mysql.com Subject: Re: Problem on millions of records in one table? It all depends on how complicated your data and searches are. I've got tables that add 2-3 million per day and I don't have performance problems. Although we only retain at most 500 millions records, not a full years worth. That said, you can get horrible performance out of mysql with tables as small as 100,000 records if you don't structure your queries correctly or use a good table structure. If I know the tables are going to grow quickly and I don't need the entire dataset all the time, I'll use merge tables. This makes it easy to remove old data easily from the default table set. - Original Message - From: He, Ming Xin PSE NKG [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, April 17, 2007 11:03 PM Subject: Problem on millions of records in one table? Hi,all The number of the records in one table increase constantly. As evaluated, the amount would increase to at least 30 millions within one year. So we worry about whether mysql could handle such a big amount of records with good performance. Or need we some other solutions to avoid this problem ,such as using Partition, dividing a big table and etc. Any help or idea would be greatly appreciated. Best Regards mingxin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Problem on millions of records in one table?
Hi, Pipes Is it reliable to use MySQL 5.1 in a commercial product now since it is still a beta version? -Original Message- From: Jay Pipes [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 18, 2007 10:04 PM To: Brent Baisley Cc: He, Ming Xin PSE NKG; mysql@lists.mysql.com Subject: Re: Problem on millions of records in one table? Brent Baisley wrote: It all depends on how complicated your data and searches are. I've got tables that add 2-3 million per day and I don't have performance problems. Although we only retain at most 500 millions records, not a full years worth. That said, you can get horrible performance out of mysql with tables as small as 100,000 records if you don't structure your queries correctly or use a good table structure. If I know the tables are going to grow quickly and I don't need the entire dataset all the time, I'll use merge tables. This makes it easy to remove old data easily from the default table set. Hi! Have you tried out the new partitioning features of MySQL 5.1 to do this? Would be cool if you had some performance numbers comparing the older MERGE table method with the newer partitioning... Cheers! Jay - Original Message - From: He, Ming Xin PSE NKG [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, April 17, 2007 11:03 PM Subject: Problem on millions of records in one table? Hi,all The number of the records in one table increase constantly. As evaluated, the amount would increase to at least 30 millions within one year. So we worry about whether mysql could handle such a big amount of records with good performance. Or need we some other solutions to avoid this problem ,such as using Partition, dividing a big table and etc. Any help or idea would be greatly appreciated. Best Regards mingxin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem on millions of records in one table?
Hi,all The number of the records in one table increase constantly. As evaluated, the amount would increase to at least 30 millions within one year. So we worry about whether mysql could handle such a big amount of records with good performance. Or need we some other solutions to avoid this problem ,such as using Partition, dividing a big table and etc. Any help or idea would be greatly appreciated. Best Regards mingxin
Re: SPAM ?
What's kind of the message you guys mentioned? - Original Message - From: LP [EMAIL PROTECTED] To: 'MySQL List' mysql@lists.mysql.com Sent: Saturday, March 24, 2007 10:13 PM Subject: Re: SPAM ? Hi, I also get the problem of keep receiving the email from the email list Regards KEVIN - Original Message - From: Jacques Brignon [EMAIL PROTECTED] To: 'Jerry Schwartz' [EMAIL PROTECTED] Cc: 'MySQL List' mysql@lists.mysql.com Sent: Saturday, March 24, 2007 10:45 PM Subject: SPAM ? Hi, I keep receiving this message by several dozens each day, how can this be stopped? Regards Jacques -Message d'origine- De : Jerry Schwartz [mailto:[EMAIL PROTECTED] Envoyé : jeudi 22 mars 2007 17:53 À : [EMAIL PROTECTED]; 'James Tu' Cc : 'MySQL List' Objet : RE: Finding a record in a result set I don't think that will work. If there are 1,000 records that qualify but none for Joe, then it will return 1,001. If Joe is in record 1 of the retrieved record set, and there are 999 other people who match the WHERE clause, then it will retrieve 1,000. Am I missing something? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Thursday, March 22, 2007 12:33 PM To: James Tu Cc: MySQL List Subject: Re: Finding a record in a result set I want to do a query of all employees from Maine, ordered by hiring date, and figure out where Joe falls in that list. (i.e. which record number is he?) If 'Joe' is a unique name LOL... SELECT 1 + COUNT(*) FROM employees WHERE name 'Joe' AND state = 'MA' AND hiredate datevalue; PB James Tu wrote: Is there some quick way to do the following in MySQL? (I know I can use PHP to search through the result set, but I wanted to see if there's a quick way using some sort of query) Let's say I know that Joe is from Maine. I want to do a query of all employees from Maine, ordered by hiring date, and figure out where Joe falls in that list. (i.e. which record number is he?) -James --MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.17/730 - Release Date: 3/22/2007 7:44 AM -- 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] -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SPAM ?
I assume someone send the copy of the message. So that we get the duplications. Since we all reply to all the mail senders. - Original Message - From: Jacques Brignon [EMAIL PROTECTED] To: 'Banyan He' [EMAIL PROTECTED]; 'LP' [EMAIL PROTECTED]; 'MySQL List' mysql@lists.mysql.com Sent: Sunday, March 25, 2007 6:07 PM Subject: RE : SPAM ? Hi, What's kind of the message you guys mentioned? Its always the same message from the same author with the same content, same date same hour, it's the one below: -Message d'origine- De : Jerry Schwartz [mailto:[EMAIL PROTECTED] Envoyé : jeudi 22 mars 2007 17:53 À : [EMAIL PROTECTED]; 'James Tu' Cc : 'MySQL List' Objet : RE: Finding a record in a result set I don't think that will work. If there are 1,000 records that qualify but none for Joe, then it will return 1,001. If Joe is in record 1 of the retrieved record set, and there are 999 other people who match the WHERE clause, then it will retrieve 1,000. Am I missing something? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Thursday, March 22, 2007 12:33 PM To: James Tu Cc: MySQL List Subject: Re: Finding a record in a result set I want to do a query of all employees from Maine, ordered by hiring date, and figure out where Joe falls in that list. (i.e. which record number is he?) If 'Joe' is a unique name LOL... SELECT 1 + COUNT(*) FROM employees WHERE name 'Joe' AND state = 'MA' AND hiredate datevalue; PB James Tu wrote: Is there some quick way to do the following in MySQL? (I know I can use PHP to search through the result set, but I wanted to see if there's a quick way using some sort of query) Let's say I know that Joe is from Maine. I want to do a query of all employees from Maine, ordered by hiring date, and figure out where Joe falls in that list. (i.e. which record number is he?) -James --MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.17/730 - Release Date: 3/22/2007 7:44 AM -- 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] -- 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]
FW: Mysql C API character set
From: He, Gang Sent: Wednesday, April 12, 2006 8:43 PM To: '[EMAIL PROTECTED]' Subject: Mysql C API character set Hi, I install MySQL server 4.1.12 in Redhat Linux in Japanese environment ( env LANG=ja_JP.UTF-8 ), I setup MySQL server utf8 character set, the configuration is as follows: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 default-character-set=utf8 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid Then, I start MySQL server, and type mysql command, the result is as follows: mysql show variables like 'char%'; +--++ | Variable_name| Value | +--++ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_results| utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | /usr/local/mysql/share/mysql/charsets/ | +--++ 7 rows in set (0.00 sec) But, I write a sample code using MySQL C API 4.1.10, the code is as follows: int main(int argc, char* argv[]) { MYSQLm_conn; MYSQL_RES *res; MYSQL_ROW row; mysql_init(m_conn); mysql_real_connect(m_conn, localhost, root, 123456, mysql, 0, NULL, 0); mysql_query(m_conn, show variables like 'character_set_%'); res=mysql_store_result(m_conn); while((row=mysql_fetch_row(res))!=NULL) { printf(row[0]); printf(\t); printf(row[1]); printf(\n); } mysql_free_result(res); mysql_close(m_conn); return 0; } The output result is as follows: character_set_clientlatin1 character_set_connectionlatin1 character_set_database utf8 character_set_results latin1 character_set_serverutf8 character_set_systemutf8 character_sets_dir /usr/local/mysql/share/mysql/charsets/ I want to why character_set_client , character_set_connection and character_set_results in the output result be latin1, not utf8 ? If I want to change MySQL C API default value when the application call mysql_real_connect() function, what I should do ? Can I change MySQL C API default value via modifying '/etc/my.cnf ' configuration file ? ( I think that the best way is to modify configuration file ) Thanks Gang
Load data infile...
Hi, I have a question with regards to Load data infile... I have a .txt file containging only path names e.g C:\temp in the bodytext. this file is imported into the DB using load data infile. However, when i do a select * on that table which i've just imported, the result looks like this: C:temp\r so i assume what has happened is that when this file is imported into MYSQL, MYSQL treats any forward-slashes as codes. i.e. \t , \n , \r etc I have tried to put double quotes around the pathnames but it doesn't help. What should i do so that the path name does not get truncated?? thanks, i'd appreciate the help regards, Lisa _ Fynda på nätet! Handla på MSN Shopping http://www.msn.se/shopping - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to get all tables
Hello, What is the sql command which is the same as command show tables ? Other database stores all tables in a system table, is there one in mysql ? Thanks, Tom __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with ODBC Driver and Office XP
Hello, I m using WinXP / Office XP and need odbc support to create a circular letter. I have installed mysql, etc. all works fine. But I cant get Word to work with odbc drivers. They seem to work, they get connection To my database but word says something like this : couldn't obtain table lists from data base Dunno, how to solve this problem, would be happy someone has suggestions J Regards T.Nissen - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Info on using MySQL with Java
Professional JSP, by Wrox Press Ltd, is a quite good book. Matt - Original Message - From: Robert Alexander [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 24, 2001 2:48 PM Subject: Info on using MySQL with Java Hi all, I'm looking for some pointers towards some good information on accessing and using MySQL with Java/Javascript. Can anyone point me towards a book you like, or some good web resources? Thanks much, /Rob - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php