Andy, I just had an interesting experience you might also find interesting. I rarely have to do restores, also (MySQL is very solid), but I just upgraded my (only) MySQL server. At the same time I upgraded the MySQL release from 5.0.45 to 5.0.67. While testing my procedure (which was a piece of cake for the most part) I got errors on one table that seemed to indicate that the mysqld daemon couldn't create the underlying files. It took a few iterations to discover that on the old server one of my co-admins had moved the files (MyISAM) from the data directory to a different file system and replaced them with symlinks in the data directory because we were running out of space in the data directory file system. That worked (fortunately since he didn't bother doing anything nice like stopping the server or locking tables when he did it). BUT I discovered that the .sql file created by mysqldump contained an option on the create table (I believe) for that table that said 'DATA DIRECTORY blah'. Of course, the mysqld daemon running as the mysql user couldn't create files in that directory! So editing the .sql file and removing that option fixed my problem. And there were no other problems in the migration.
On Wed, Jan 14, 2009 at 10:56 AM, Andy Smith <a.sm...@ukgrid.net> wrote: > Hi, > > I'm not asking this as a specific question, more a general gripe looking > for some kind of explanation. > > I don't do mysql restores very often, but many times when I have tried I > get nasty errors as if its bombing out due to dodgy characters, or quote > problems etc. > Normally I am doing restores across the same major and minor revision (ie > 5.1), but quite possibly with a point release difference. > > Its just quite frustrating, and also for such an old and widely used > product surprising that a simple backup and restore doesnt work at least 99% > of the time. > > So I suppose, Im asking is there anything people like me regularly do wrong > that might cause this, or do other people experience similar issues and is > there anything that can be done to improve matters? :S > > thanks for any help :) > > PS Im no MySQL expert but have used it a fair bit as well as Oracle and > many Unixs and open source bits and pieces and Im usually quite good at > making them do what I need ;) > > cheers Andy. > > ---------------------------------------------------------------- > This message was sent using IMP, the Internet Messaging Program. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=sholme...@gmail.com > > -- The lame man who keeps the right road outstrips the runner who takes a wrong one. The more active and swift the latter is, the further he will go astray. -Francis Bacon, essayist, philosopher, and statesman (1561-1626) Truth never damages a cause that is just. -Mohandas Karamchand Gandhi (1869-1948)
