Re: Hybrid Environment
Hey John, It very much depends on what your users needs are. In my experience, there's an opensource alternative that integrates well with proprietary systems if needed for everything i can think off. I've been working solely on Linux for more than 3 years now. My laptop came with Vista pre-installed and the reason it's still there, is that I haven't gotten around to wiping it clean. I suggest you make a list of all the software you need in your company and then go about finding opensource alternatives. They'll be there, you just have to ask yourself if they fit your needs. Software used here: Eclipse for development (all languages), Firefox/Thunderbird goes without saying, OpenOffice.org for word processing and spreadsheets. The only problem I can think off, is the compatibility between some Office versioned documents and OpenOffice, but hey, you don't even get that compatibility between different versions of Office and you certainly can't beat the price of OpenOffice.org :p In conclusion, from a developers point of view, you can't beat Linux. It's safe, it's easy and most of all, it's considerably faster. regards, boro john_sm schreef: Hey Guys, I am still in a thinking stage and will like to learn from your experience, and was wondering if any of you folks have a hybrid environment i.e. Linux and Proprietary systems and what kind of issues do you run into. And also, what pieces of technology you have - which are open source and which ones you have are proprietary and any changes you anticipate 1 year out. Greatly appreciate your help. - John Smith -- 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
You cannot execute the grant 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: off-topic unsubscribe concern
Check out your signature after posting. It has the unsubscribe link added. cheers, boro Ananda Kumar schreef: Me too, every once in two days i keep getting this UNSUBSRIBE emails. regards anandkl On 7/7/07, B. Keith Murphy [EMAIL PROTECTED] wrote: I have been having the same problems. Have no idea what is up. - Original Message - From: Michael Dykman [EMAIL PROTECTED] To: MySQL General mysql@lists.mysql.com Sent: Friday, July 6, 2007 11:55:41 AM (GMT-0500) America/New_York Subject: off-topic unsubscribe concern Hi everyone. I have been on this list for a pretty long time but in the last few months I have started to receive random 'confirm unsubscribe' messages.. They always seem to originate from a Roadrunner IP (I have not thoroughly tested that hypothesis). I have no accounts on or near roadrunner, so I doubt I am inadvertantly kicking these off, which was my first theory. Is anyone else suffering from this or is it just me? -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- 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 (o) 919-433-0786 (c) 850-637-3877 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: database structure
Hey there again, I suggest you look up a tutorial about database normalisation. Good ones are often hard to find. In general, you give all tables that contain data you will be referencing in other tables a numeric id (INT(11) UNSIGNED) as primary key, and you use that key as the constraint. Your table `locations` will be referenced in your table `tags` as such: FOREIGN KEY (`location`) REFERENCES `locations`(`id`) ON UPDATE CASCADE ON DELETE SET NULL Search the mysql manual for those update/delete options to see what they do and adjust them to your needs. The ones given are the ones I in most situations. HTH, boro Hiep Nguyen schreef: Now, if I have a location table with id, name, address, phone, fax, etc... Should I put id or name into the tag table? If id used, then how do i look up the name, address, phone, fax, etc... when I do a select on tag table? Thank you for all your helps T. Hiep -Original Message- From: Mogens Melander [mailto:[EMAIL PROTECTED] Sent: Monday, July 02, 2007 3:45 PM To: mysql@lists.mysql.com Subject: Re: database structure On Mon, July 2, 2007 21:10, Hiep Nguyen wrote: take your advice, i looked in to JOIN and i got the idea. but i noticed that in order to use JOIN, don't you need to have the same column name in both tables? i just don't see it in your example here. is there something that i'm missing? Using the form: select t1.field1 data1, t2.field1 data2, t3.fieldn data3 from table_a t1 left join table_b t2 on ( t1.id=t2.t1_ref ) left join table_n t3 on ( t2.id=t3.t2_ref ); You can join on allmost anything. ?? Can typecasts be used in this scenario ?? can u give a select example with JOIN on three tables above? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: database structure
Or: Tag ShapeDimension (type enum('height', 'thickness', etc), value VARCHAR() or INT()) TagsShapeDimensions (FOREIGN KeY TAG, FOREIGN KEY ShapeDimension) 1 less table Greetz, boro Rajesh Mehrotra schreef: Hi, You can do this in four tables: 1. Tag 2. Shape (with an additional field, let us call it X, describing how many data elements each shape has) 3. ShapeElements : one record describing each data element (length, width etc.) for each shape. Record count for each shape: X 4. Data Table : X number of records for each TagID. References ShapeElements. The number of table will remain fixed at four, no matter how many shapes you have. And your SQL statements will be generic, most of the times, regardless of the shape. Sincerely, Raj Mehrotra hccs - Experts in Healthcare Learning (516) 478-4100, x105 [EMAIL PROTECTED] -Original Message- From: Hiep Nguyen [mailto:[EMAIL PROTECTED] Sent: Monday, July 02, 2007 8:53 AM To: mysql@lists.mysql.com Subject: database structure Hi all, i'm seeking for help/suggestion on how to create relationship for this scenario: I have one table (tag) with the following fields: tagid, location, weight, grade, heat, shape, diameter, length, width, height, ... (and many other fields) what i want to do is move the shape field into a different table, however, each shape will have different dimensions for sample: rod bar has diamter and length, but square/flat bar has width, height (thickness), and length. wire has only diameter. but i also don't want to create a huge table to hold all the possible fields in all shapes, so i'm thinking create a table per shape: round table (diameter, length) square table (width, height, length) i-beam table (flange height, flange thickness, web thickness) angle table (leg1, leg2, thickness) ... and so on. in turn, i have 2 tables: tag, shape + as many table as there are shapes my question is: is there a better to do this? how do i query with this structure? i'm a bit confuse on how to manipulate data if each shape have diffent fields??? Thank you for all your help (sorry for a long email) T. Hiep -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Select Last X rows
Rich schreef: Hi folks. Just wanting to know the best way to grab the last 10 rows from a table. Looking twice to the db to see how many records there are will be outdated by the time the SELECT is done, so it's moot. This is a fast moving db with records coming and going. Instead of having an offset in LIMIT, is there a way to ask for the last 10 rows directly? Cheers Rich in Toronto Hey, Why is ORDER BY in combination with LIMIT not a valid solution to your problem ? Greetz, boro -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't Bind to Port
netstat -nlp | grep 3306 greetz, boro Drew Jenkins wrote: Hi; I just installed MySQL from FreeBSD port. I specified using openssl. Outside of that, I changed nothing. I copied over the /etc/my.cnf as is, leaving the innodb stuff commented out. In preparing to install my database, I got this error: server312# mkdir /usr/local/localhost server312# chown mysql:mysql /usr/local/localhost/ server312# /usr/local/libexec/mysqld -uroot -hlocalhost --max_allowed_packet=999M InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 070302 15:58:29 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 070302 15:58:29 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 070302 15:58:29 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 070302 15:58:29 InnoDB: Started; log sequence number 0 0 /usr/local/libexec/mysqld: Table 'mysql.general_log' doesn't exist 070302 15:58:29 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 070302 15:58:29 [ERROR] Do you already have another mysqld server running on port: 3306 ? 070302 15:58:29 [ERROR] Aborting 070302 15:58:30 InnoDB: Starting shutdown... 070302 15:58:32 InnoDB: Shutdown completed; log sequence number 0 46403 070302 15:58:32 [Note] /usr/local/libexec/mysqld: Shutdown complete # ps wax|grep mysqld 3986 p1- I 0:00.01 /bin/sh /usr/local/bin/mysqld_safe 4034 p1- I 0:11.16 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql --pid-file=/var/db/my server312# nmap localhost Starting Nmap 4.11 ( http://www.insecure.org/nmap/ ) at 2007-03-02 16:02 UTC Interesting ports on localhost.by2012.com (127.0.0.1): Not shown: 1672 closed ports PORT STATE SERVICE 22/tcp open ssh 25/tcp open smtp 110/tcp open pop3 143/tcp open imap 993/tcp open imaps 3306/tcp open mysql 8021/tcp open ftp-proxy 8080/tcp open http-proxy I presume everything went well here until it went to bind to the port. There's no other MySQL running on the server, so why can't it connect to the port? This server isn't yet set up with an URL, so if it's reading from rc.conf or what have you, that could be tripping it up. Please advise. TIA, Drew Finding fabulous fares is fun. Let Yahoo! FareChase search your favorite travel sites to find flight and hotel bargains. http://farechase.yahoo.com/promo-generic-14795097 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]