Re: General MySQL Question: Ed Reed (CA, United States ofAmerica) Medium
Great idea! Tips on how to get around, good local restaurants (if you like Vietnamese, San Jose is the place), and other things to do when you need a break... There is really a great deal just a short distance away, but you have to know how to get there. It's possible there was something like this last year, but I live in the area so I didn't look for it. I'm in full agreement that a conference is just that much better when it includes a little variety, a chance to get away from the drab convention hall, and a chance to socialize a little. One thing I suggest is to attend the Quiz Show (Wed 8pm) or other "after hours" activities. Great fun, and a good way to hook up with people for dinner or drinks away from the center. Eric -- Eric Braswell Web Manager MySQL AB Cupertino, USA Mike Wexler wrote: The area by the Santa Clara convention center is pretty dead, but you can take the light rail to downtown San Jose and there is a pretty lively nightlife there, lots of interesting restaurants, The Tech Museum and other things depending on you interests. Also there are lots more interesting places to eat than sizzler within in 5 minute drive of the convention center. Perhaps what is needed is either a nice cheatsheet of what to do and where to go? Or perhaps some of the locals could volunteer to be "ambassadors" and take people with similar interests to local activities, restaurants or points of interest. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [OT} How to pronounce GIF
In an effort to quell this off-topic and rather pointless dialog, allow me to refer you to the Wikipedia article on the subject: http://en.wikipedia.org/wiki/GIF Specifically the section: "According to the creator of the "GIF" format, Steve Wilhite, the pronunciation is with a soft "g" and the acronym is pronounced like the peanut butter brand, Jif. To fellow employees of CompuServe he would often say "Choosy developers choose GIF", spinning off of the historically popular peanut butter commercial. This pronunciation was also identified by CompuServe in their documentation of a graphics display program called CompuShow. " "GIF" is not a word, it's an acronym, therefore "precedent in English" has no bearing. Eric John Trammell wrote: Way offoptic now How do you pronounce "gift"? :^) $ egrep '^gif' /usr/share/dict/words gift gift's gifted gifting gifts To heck with the spec, all precedent in English says hard G. Next they'll tell us to pronounce "jpeg" as "gay-peg". -Original Message- From: Gerald L. Clark [mailto:[EMAIL PROTECTED] Sent: Friday, January 12, 2007 1:04 PM To: Brian Dunning Cc: mysql Subject: Re: [OT} How to pronounce GIF Brian Dunning wrote: On Jan 7, 2007, at 4:23 PM, TK wrote: In short, the original inventors of the GIF format (CompuServe, 1987) have always defined the pronunciation to be like "JIF." So, that has always been the "correct" pronunciation. Sure, so I'll start pronouncing "graphics" as "jraphics". How do you pronounce "giraffe"? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: www/dev.mysql.com?
Ashley M. Kirchner wrote: >Anyone else having trouble getting to either sites? We have been experiencing an intermittent and inconsistent routing problem with one of our ISPs. We use round-robin DNS and at this point we may need to simply drop that ISP from the mix until we can isolate the problem. I apologize for this inconvenience. As a temporary work-around you can use one of the functioning IPs -- 213.136.52.29 and 213.136.52.82. The default virtual host is the Developer Zone so you can access downloads and the manual in this way. I expect to have this resolved by tomorrow afternoon US pacific time. -- Eric Braswell Web Manager MySQL AB Cupertino, USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Crashing mysql Ver 14.7 Distrib 5.0.2-alpha, for pc-linux (i686)
Is there a reason you cannot upgrade from an early =alpha= version of 5.0 ? I think you fill find the release versions more stable. -- Eric Braswell Web Manager MySQL AB Cupertino, USA murthy gandikota wrote: Hi Can someone tell me where in the file system to look for the logs? Mysql has been crashing once every hour. Memory is not the issue. This is how I start the mysql: nohup /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/ local/mysql/var --user=mysql --pid-file=/usr/local/mysql/var/admin.scholasticfun dinggroup.com.pid --skip-locking --port=3306 --socket=/var/lib/mysql/mysql.sock & I'd appreciate your help. Thanks - Do you Yahoo!? Get on board. You're invited to try the new Yahoo! Mail Beta. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL lock tables - bug or not?
I am not aware of any such bug related to the LOCK TABLES privilege. Like you I could not find a mention in our bugs database, for any version. It is easy to demonstrate that this is not the case. If permissions are properly set up, LOCK TABLES can be restricted to a database just like every other priv (makes sense, of course!). On 5.0.20: mysql> grant select, insert, update, delete, lock tables on dl.* to 'bar'@'localhost' identified by 'bar'; mysql> show grants for 'bar'@'localhost'; ++ | Grants for [EMAIL PROTECTED] | ++ | GRANT USAGE ON *.* TO 'bar'@'localhost' IDENTIFIED BY PASSWORD '*E8D46CE25265E545D225A8A6F1BAF642FEBEE5CB' | | GRANT SELECT, INSERT, UPDATE, DELETE, LOCK TABLES ON `dl`.* TO 'bar'@'localhost' | ++ 2 rows in set (0.00 sec) mysql> show databases; ++ | Database | +----+ | information_schema | | dl | ++ 2 rows in set (0.00 sec) -- Eric Braswell Web Manager MySQL AB Cupertino, USA James Harvard wrote: I'm using MySQL as the db for Drupal (PHP based CMS), on shared hosting. There are repeated errors because the db user does not have permission for LOCK TABLES, which Drupal uses. The ISP says that they don't grant this permission because ... "MySQL has a bug which allows users with GrantTables* the ability to view the Database names of all other databases on the server. Whilst the users can not see any other data, knowing the names of tables can facilitate attacks." (* = I assume they meant 'Lock Tables') However I can't find any mention of this in the bugs db, nor is it listed in the manual as a side effect of granting 'lock tables' permissions. Does anyone know if it is a bug or not? Does anyone know whether LOCK TABLES really is a security risk in a shared server / multi-user environment? TIA, James Harvard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Read_only Mode
--read_only is probably what you are looking for. http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html -- Eric Braswell Web Manager MySQL AB Cupertino, USA Clyde Lewis wrote: The idea is to prevent all users from applying changes to the system. Not just a single user. I'm trying to find something similar to Oracle's Read-only mode option during startup. Thanks, CL At 02:38 PM 6/28/2006, João Cândido de Souza Neto wrote: Why you don´t create a user with just select right and use him? "Clyde Lewis" <[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] > All, > > Does MySQL have an option where the database can startup in READ-ONLY > mode? The idea is to have the server running with users connected, but > now allowing any updates to me applied to the database. I've looked > through the documentation, but was not able to find such a feature. If > someone can point me in the right direction, it would be greatly > appreciated. > > Thanks in advance, > > *** > Clyde Lewis > Database Administrator > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] *** Clyde Lewis Database Administrator General Parts, Inc. 919-227-5100 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: possible to select from multiple databases?
Bing Du wrote: > I have two separate databases that I need to query data from. In the > following SELECT statement, 'title' and 'db_entry_name' are in database1, > and 'projectID' is in database2. If they were in one database, this > SELECT should work. How should I tweak it to get data from both database1 > and database2? Is that even possible in single SELECT? > > SELECT title, db_entry_num, projectID FROM account_info, ResearchProjects > WHERE ResearchProjects.IDNo = $idno AND account_info.db_entry_num = > ResearchProjects.projectID This is easy as long as the dbs are on the same machine: SELECT * from db1.table1, db2.table1... Eric -- Eric Braswell Web Manager MySQL AB Cupertino, USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to Verify Replication Status?
You'll need to checksum them at the same point in time, naturally --
which you can do by stopping replication on the slave, then performing
the command on the master, then slave, and compare.
In other words, if you are doing this on a live system, you have to make
sure there are no writes in between the two checksums... but I'm sure
that's clear.
The one problem with using CHECKSUM TABLE is that a row-by-row
comparison takes some time and necessarily forces a table lock, so
performing this on a live system can be problematic if you are expecting
frequent writes. You might consider adding the live checksum to your
tables for that.
See: http://dev.mysql.com/doc/refman/5.0/en/create-table.html
A data dump, on the other hand, can be fairly quick and would allow you
to perform the checksum without interfering with any other operations. I
don't know the details of your situation (or the size of your data), but
I'm fairly sure that that's how I would do it.
Another possibility is to do a checksum directly on the database files
if you can do so while the server is not updating anything, which would
avoid the dump, and is extremely fast. You could have a shell script
lock the tables, do an md5sum on the .MYD and maybe .frm files (for
MyISAM), then unlock. I can't off-hand think of any reason this wouldn't
work well as long as the slave and master are configured identically and
are the same version.
Eric
--
Eric Braswell
Web Manager MySQL AB
Cupertino, USA
Robinson, Eric wrote:
Eric, that is very helpful. Thanks.
Assuming the master and slave are in sync, is there a reason the
checksums would not match? I would rather not dump the database and run
an external checksum unless I have to.
--
Eric Robinson
Director of Information Technology
Physician Select Management, LLC
775.720.2082
-Original Message-
From: Eric Braswell [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 20, 2006 1:49 AM
To: Robinson, Eric
Cc: mysql@lists.mysql.com
Subject: Re: How to Verify Replication Status?
There are only a very limited set of circumstances where slaves could
get out of sync, and if everything is set up right, it basically should
not happen.
See: http://dev.mysql.com/doc/refman/5.0/en/replication-rules.html
And: http://dev.mysql.com/doc/refman/5.0/en/replication-features.html
CHECKSUM TABLE is a good option if it's a read-only table or you can
stop writes (or just replication) long enough to do that. It only works
on MyISAM.
You could also do basically the same thing by dumping the data in the
same way on each server, and running a checksum (e.g. md5sum) or diff
tool. One thing I have done is to use:
mysqldump --skip-opt {database} > {database}.sql
..on each machine, then diffed the files using "diff" (note *nix bias
here). Using skip-opt to output inserts on individual lines allows you
to compare the data to see exactly where any differences are. But this
won't help you if you can't transfer all the data to one place -- you
could just do a checksum then on both sides and compare that. Would be
pretty easy to script that and perform periodic checks.
Eric
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to Verify Replication Status?
There are only a very limited set of circumstances where slaves could
get out of sync, and if everything is set up right, it basically should
not happen.
See: http://dev.mysql.com/doc/refman/5.0/en/replication-rules.html
And: http://dev.mysql.com/doc/refman/5.0/en/replication-features.html
CHECKSUM TABLE is a good option if it's a read-only table or you can
stop writes (or just replication) long enough to do that. It only works
on MyISAM.
You could also do basically the same thing by dumping the data in the
same way on each server, and running a checksum (e.g. md5sum) or diff
tool. One thing I have done is to use:
mysqldump --skip-opt {database} > {database}.sql
...on each machine, then diffed the files using "diff" (note *nix bias
here). Using skip-opt to output inserts on individual lines allows you
to compare the data to see exactly where any differences are. But this
won't help you if you can't transfer all the data to one place -- you
could just do a checksum then on both sides and compare that. Would be
pretty easy to script that and perform periodic checks.
Eric
--
Eric Braswell
Web Manager MySQL AB
Cupertino, USA
Robinson, Eric wrote:
I have master-slave replication working fine. However, I worry about the
possibility of the master and slave accidentally getting out of
synchronization. Are there circumstances (other than a direct INSERT to
the slave) that could cause the master and slave to be out of sync? Is
there a way to periodically do some kind of full check to verify that
the slave is an exact duplicate of the master? I thought of just
counting the rows in all the tables on both servers, but that only tells
part of the story. Is the a more elegant and complete way? Also, the
servers are separated by a slow WAN link, so transferring the whole
database across the network is not an option.
--
Eric Robinson
Director of Information Technology
Physician Select Management, LLC
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error on T_echo ?? what is this ?
This is not a PHP list and that's a PHP error. But you are missing a semi-colon at the end of the line "...`BondRem`)". Eric Brian E Boothe wrote: i,m getting the following error on my MySQL Code inserting data into a database, .? `OthrProjBill`, `OthrRem`, `BondAm`, `BondBill`, `BondRem`) //confirm echo "Query Finished"; ?> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Restrict MySQL server 4/5 to single IP
Jorrit Kronjee wrote: You seem to be best off with a setup where you've got the MySQL5 UNIX socket disabled, MySQL5 bound to one specific IP address, MySQL4 listening on 127.0.0.1 and a simple port forwarding rule to MySQL4. Then your clients won't have to change anything and they can migrate to MySQL5 when they're ready. Or am I mistaken? From Yves' last post, I concur with this. It's definitely not optimal -- you are substantially reducing performance to avoid a simple parameter that you could easily script (I assumed you would be prepared to simply specify the socket name as a parameter), but if your requirement is that clients must connect using default settings, then this is one way. Personally I'd find another. Eric -- Eric Braswell Web Manager MySQL AB Cupertino, USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Restrict MySQL server 4/5 to single IP
> But what I wanted to do is: > > MySQL 4.0 -> 192.168.0.32 and 127.0.0.1 > MySQL 5.0 -> 192.168.0.33 I'm going to assume you are using some kind of Unix-like platform. When you connect to localhost, you are actually connecting by default through a Unix socket file, not TCP/IP, because it is much faster. Thus it is perfectly possible to do what you outline without having to specify multiple IPs in the bind-address option. External connections will use TCP/IP, internal will use a unix socket file. If you wanted to use -only- the unix socket file to connect to a particular instance, thus completely disallowing external connections, you can use the skip-networking option. I think the clearest description of this is actually: http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html As you can see, the same concept works on Windows, except through named pipes. To verify what type of connection you are using, use the status command. You'll see a line like: Connection: Localhost via UNIX socket -or- Connection: via TCP/IP > Or is there another way to only allow certain users to connect from > localhost? Of course. Grant privileges only to connect to localhost. See http://dev.mysql.com/doc/refman/5.0/en/user-account-management.html Or use skip-networking to turn off TCP/IP for that instance. > As I think about it, a local TCP forwarder would accept connections on > localhost, but MySQL won't see that, so this wouldn't work anyway. Completely unnecessary! You are far better off simply using the default behaviour of connecting through a socket, not TCP/IP, when connecting from the same machine. What you are wanting to do is not that unusual, and I'm confident you'll find there are ample options to get the setup that works best for you. I strongly suggest you read up in the manual on how MySQL handles TCP/IP and local connections. Eric -- Eric Braswell Web Manager MySQL AB Cupertino, USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Restrict MySQL server 4/5 to single IP
You can't specify multiple IPs for bind-address. Let's back up. You want to run both 4.0 and 5.0, and you want to be able to set it up so it's 'easy' to connect to each separate instance, i.e. without having to specify different ports. This is pretty easy to do. In this case you use separate configurations for each instance (5.0 has an instance manager for this, but you can start mysql server with any arbitrary configuration file or configuration options). An example: start each mysqld4 --bind-address=192.168.1.1(more options for each basedir, datadir, etc) mysqld5 --bind-address=192.168.1.2(more options for each basedir, datadir, etc) Now if 192.168.1.1 resolves to mysql4.somedomain.com, you simply connect to that for version 4, and mysql5.somedomain.com for version 5. If you want one copy to -only- listen locally and not be accessible from an external IP, you can use --bind-address=127.0.0.1 (or some other internal-only IP). Alternatively you can use --skip-networking to not use TCP/IP, and connect to your 'local-only' copy via a socket/name pipes. See: http://dev.mysql.com/doc/refman/4.1/en/server-options.html and: http://dev.mysql.com/doc/refman/4.1/en/option-files.html If this were me, I would create two configuration files, my4.cnf and my5.cnf with these options, as well as unique settings for data directories and so on, and start the two instances by telling safe_mysqld to use the appropriate configuration file, and the appropriate mysqld binary, for each instance. Before the instance manager in 5.0, there is also mysqld_multi: http://dev.mysql.com/doc/refman/4.1/en/mysqld-multi.html, which might be of help here. Does that make sense? Did I misunderstand? -- Eric Braswell Web Manager MySQL AB Cupertino, USA Yves Goergen wrote: On 08.04.2006 23:14 (+0100), Eric Braswell wrote: Yves Goergen wrote: How can I enter multiple IP addresses there? This isn't documented online. I need to bind it to one specific external address and additionally to localhost (127.0.0.1). The other server is only bound to another external address. Why do you want to do this? Currently, I have one IP address on my server, with one MySQL server. In the near future, I'll have a server with multiple IP addresses and I'm going to install MySQL 4.0 and 5.0 in parallel. My first design was to use different ports for both servers, but that's always a little complicated to configure for the clients. Now I want to use one IP for one MySQL server. Both are external addresses, which can be assigned with a DNS name for simple access. But the 4.0 server still has some system tasks and also for legacy reasons, I'd like to keep the 4.0 server listening on the localhost interface. This also allows me to assign more strict access rights for these system-related tasks. They can be limited to the local host instead of any host. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Web Farm Design
It is not possible to make specific suggestions based on the information you've provided. The list would need to know the nature and platform of your application, the amount and type of the traffic you see, your current mysql vs. apache load (like queries, requests per sec), current server config, what you mean by "choking", etc. But there are always some general rules that apply, some of which have been mentioned... I'll second the recommendation for the book "High Performance MySQL" by Zawodny. It will answer many of your questions and help guide you through this process. We have two sample chapters from the book -- Replication and Server Performance Tuning on our Developer Zone. We also have several other great articles on performance tuning in our articles section: http://dev.mysql.com/tech-resources/articles/ I'd also like to recommend our Consulting (Professional Services) folks, led by Josh Chamas. You can get any kind of consulting gig, big or small, for a very fair price -- it will save you money. These guys are absolutely top notch and among the best in the business when it comes to scale-out -- they do regular consulting for very well known, high traffic sites I'm not allowed to mention. See http://www.mysql.com/consulting/ Some general principles I go by: - If you can, always separate http and MySQL (as in your option 2). - If you are read heavy as you say (and who isn't?), spread that load over one or more mysql slaves. You don't mention replication. Why not use it? - People tend to assume that there is nothing wrong with their application, but everything wrong with their hardware or software. The -first- place I look is in the slow query log, because for web applications usually built by non-DBAs, that is so often the biggest bang for your buck. Sometimes 20 minutes using explain to make sure you have the right indexes in place and are not doing sub-optimal joins can give you a 20-30% increase in application performance. Next I spend some time in my.cnf making sure that MySQL server is making the best use of memory. If you give us more details I think we can probably give more specific advice on what sort of architecture might be an appropriate fit. -- Eric Braswell Web Manager MySQL AB Cupertino, USA Elias wrote: We are currently building a webfarm to replace our all in one box solution. We are experiencing problems when we get linked to a site like the drudgereport and we are seeing 1000's of hits a minute. Both apache and mysql start chocking and we get dropped because we cant deliver content. I am trying to understand what is the best way to redeploy our Mysql. I am thinking of two possible designs, if feasible. The clients are read only there is no inserting or deleting. The database is updated nightly from a single source. Fig 1 _ | http| |Mysql | |_| _ | http| ___ _ |Mysql | _ | PIX | | Load Balance | |_| | | || ---| |-- _ ---| SAN | |___|| | | http| | | |Mysql | |_| _ | http| |Mysql | |_| In Fig 1 I am thinking that each server runs both apache and the mysql engine and the database files will live on the SAN. Is this possible? can multiple engines talk to one database file on the SAN? Fig 2 _ | http| | | |_| _ | http| ___ _ | | _ __ | PIX | | Load Balance | |_| | | | | || ---| |-- _
Re: Restrict MySQL server 4/5 to single IP
Yves Goergen wrote: On 04.04.2006 23:17 (+0100), Eric Braswell wrote: my.cnf: bind-address = Will probably do the trick. How can I enter multiple IP addresses there? This isn't documented online. I need to bind it to one specific external address and additionally to localhost (127.0.0.1). The other server is only bound to another external address. Why do you want to do this? Eric -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql over HTTP
Jangita wrote: > Yes this is very true Eric, thanks. > > BUT there are LOADS of firewalls that don't allow non http traffic (like > mysql) over port 80; and your method wont work if all that's available is a > http proxy! > Ah, so you want to be able to bypass a firewall that does stateful inspection and -only- allows plain old http traffic? http://www.vbmysql.com/articles/security/bypass-firewall-libmywitch.html Not really aware of any other options, but I'm assuming others have solved this problem. I know there are some fairly generic HTTP tunneling tools available, but I don't know how well they would work with MySQL (if at all). I would imagine it would suck no matter the solution. Are you really sure this is an issue for your application? Eric -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql over HTTP
No need to re-invent that wheel: Just use port=80 in my.cnf or start with --port=80 See http://dev.mysql.com/doc/refman/5.0/en/server-options.html Eric -- Eric Braswell Web Manager MySQL AB Cupertino, USA Jangita wrote: Hi all, It's all well and good having mysql using port 3309 (or any other port for that matter); I'm writing an application that will be used by loads of users off the internet - so I'm expecting firewall issues. One easy way is to have the mysql traffic flow over port 80; that works sometimes but not with intelligent firewalls that only allow http traffic or companies that have only http ports open (yes there are many of these) One method I've thought about that goes around this is to write an interface that sits in-front of the mysql client and translates the mysql traffic into http get or put requests and use wininet.dll to send these requests to the server. Since these are get and put requests I'll have to write and install a cgi or isapi dll on the webserver which translates these requests into normal traffic and relays it to the mysql server and vice versa. This would in effect produce an environment where as long as you can browse you can use the mysql client application (with iexplore because of wininet) - and with linux to some extent and this will also be able to go thru http proxies etc (basically anything that ie can go thru) Before I get my hands dirty; is there anything like this that exists out there? I have a week leave from Monday and if there isn't well im about to start writing one. Jangita -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: upgrading problem
You need root privileges. Login as root or use sudo. E.g. sudo rpm -Uvh MySQL-shared-compat-5.0.19-0.rhel4.i386.rpm If you don't have root or sudo access, you can't perform this upgrade. You could possibly use the --prefix and --relocate rpm install options to install mysql into a directory for which you do have write permissions, but that gets complicated. Eric balaraju mandala wrote: Hi Comunity, I am getting problem while i am upgrading to MySql ver 4 to MySql ver 5. I planned first to install "MySQL-shared-compat-5.0.19-0.rhel4.i386.rpm", but i am getting following error. Preparing...### [100%] 1:MySQL-shared-compat### [100%] error: unpacking of archive failed on file /usr/lib/libmysqlclient.so;44361c01: cpio: symlink failed - Permission denied i am unable to understand the problem. Please help me. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication for historical data
No, replication is not designed for this task. It sounds like the Archive Storage Engine could be a good solution for you: http://dev.mysql.com/doc/refman/5.0/en/archive-storage-engine.html Robin Schumacher has written a nice introductory article: http://dev.mysql.com/tech-resources/articles/storage-engine.html Hope that helps, Eric -- Eric Braswell Web Manager MySQL AB Cupertino, USA Ian Collins wrote: Hi, I have a customer who wants to be able to replicate their live MySQL database to a second server, but not to have any data deleted. i.e., they want to accumulate the data. I don't believe you can do this with replication. Does anyone know a way of doing this? Cheers, Ian. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Restrict MySQL server 4/5 to single IP
my.cnf: bind-address = Will probably do the trick. -- Eric Braswell Web Manager MySQL AB Cupertino, USA Yves Goergen wrote: Hi, I have a machine with multiple IP addresses on my network interface and I have setup multiple MySQL servers on the machine, version 4.0 and 5.0. Currently, they're all listening on all IP addresses on different ports (3306 and 3307) but I'd like to make use of the second IP to make it easier to connect to each MySQL instance with different DNS names (mysql4.mydomain and mysql5.mydomain) on the default port. Only I couldn't find any hint on how to tell the MySQL server to listen only on a single IP address. I can change the port, the UNIX socket and disable IP networking entirely, but no idea how to specify a custom IP. Any hints? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.0.18 on Mac OS X 10.2.8 won't start
Sachin Petkar wrote: For some reason, MySQL 4.0.18 has suddenly stopped running and will not start anymore. It has been running for several weeks until about 5 days ago. When I tried to reach it, I discovered that it is no longer running. However, attempting to start it via the mysqld_safe script simply returns with: Starting mysqld daemon with databases from /usr/local/mysql/data 060402 18:49:55 mysqld ended [1]Done ./mysqld_safe --user mysql To confirm, the /tmp/mysql.sock file does not exist at this point. There are several possible reasons for this. One of the most common is inappropriate permissions on the files in /usr/local/mysql/data (they need to be readable and writable by the user under which mysql is run, usually "mysql") The first thing you should do is check the error log file in /usr/local/mysql/data, on Mac OS X, usually named .err In a terminal window, typing: tail /usr/local/mysql/data/example.com.err will give you the last few lines of this file and likely tell you what the specific problem is. It's possible you may need to be root or use sudo to get permissions to read this file. Another poster suggested verifying that MySQL is not running. In your case it has clearly stopped, but you can always verify that by using the ps command: ps auwx | grep mysql If it's running, you will see an item with "/usr/local/mysql/bin/mysqld" in the list. It was also suggested to us another utility other than safe_mysqld to start the mysql server. In most cases it is better to use safe_mysqld. Any special options you need can be specified in /etc/my.cnf. But it sounds like you are using the default installation, so everything should just work. Eric -- Eric Braswell Web Manager MySQL AB Cupertino, USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Wrf files: how can I read them?
asteddy wrote: Thank you, but why has mysql made seminars wich must be seen with a non-free software with a 14 days trial? Is there nothing else to see it? Asteddy We haven't :) You can download a free player at: http://www.webex.com/customercare/downloads-player.html This is not a trial version but is completely free, and is available for Windows, Mac OS 9 and Mac OS X. It's possible also to view them in Linux using a browser plugin (I had to Google a bit for that). The 14-day trial is for those wanting to _host_ a webex seminar. I will make sure that we provide a link to the Webex player on all web seminar signup pages. Hope you enjoy the seminars -- they have been getting extremely popular! Eric -- Eric Braswell Webmaster MySQL AB Cupertino, USA Hi, there is link "take the free trial" on webex site. haven't you seen the seconf button ? Mathias Selon asteddy <[EMAIL PROTECTED]>: Hello, I have found Mysql Performance Tuning Seminar available for download, but I don't know how to see it. I have found something like Webex website, but I don't see any software to download there. Can you help me please? Why is there nothing specified about that type of file on the download page of the seminar? Thank you very much. Asteddy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
