Re: Library database help

* Taylor Lewick > Hi all. I am trying to build a small simple database for a > lending library. > > Basically, I have a table of resources to be lended out, and a > table that will store a user's name and what they have borrowed. I think you need a third table to store what the users have borrowe

replication w/o stopping the master

Hi guys & gals, Tried to get an answer through the manual, but couldn't find one. So, is there a way to do replication w/o stopping the master. The only way I found up until now was to stop the master (in order to insure there are no changes to the database), copy the database directory,

Re: mutual declarations produce Error 1064

"Morten Gulbrandsen" <[EMAIL PROTECTED]> wrote: > I think something is wrong with my administration, > > Basically I get these messages, > > ERROR 1005 at line 9: Can't create table '.\company\department.frm' > (errno: 150) > > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using passw

Re: Can't start MySQL on Mac OS X

Nicos, Actually, MySQL should be installed by an administrator, but it should be executed by root, which would permit the writing to the tmp dir. Meaning everytime you kick off MySQL server, you'll need to do so as root. This is usually how I dow it: cd /usr/local/mysql sudo echo sudo ./bin/my

Updating table based upon matching field in second table

I have a database of books that was originally created as a flat file. Each record has a number of fields, including the authors name. I'm trying to convert the database to something a little more efficient. I've created a new table (called Authors) of unique authors names and assigned each one

Re: replication problem

On Thu, Aug 07, 2003 at 07:54:18AM +0100, Andy Smith wrote: > On Wed, Aug 06, 2003 at 07:00:33PM -0700, Steven Roussey wrote: > > > So does anyone else have any ideas what is going on here? Shall I > > > report this as a bug? > > > > Did you post how you setup the servers to load the different my

error when using avg( DISTINCT column)

I'm getting a syntaxt error when using > select avg( DISTINCT column) from table. the code above is from the "teach urself sql" book. i have mandrake 9.1 linux. here's exactly what's happening: mysql> select avg(distinct prod_price) from Products; ERROR 1064: You have an error in your SQL syntax.

Re: MySQL Logging and encryption

On Thu, Aug 07, 2003 at 10:32:19AM -0700, K. Wright - DataAnywhere wrote: > If logging is turned on, is there a way to disable it for a given query? > > IE. If I query --> select AES_ENCRYPT("This is very important data", > "lessthansecretkey"); > > Then my key and the value I'm trying to encr

4.0.14 runs CPU usage up and eventually stop

Hi, I am running 4.0.14 on a FreeBSD 4.8-STABLE machine (upgraded to CVS from last week) and I am having a problem. We run a fairly large website using PHP so there is always many connections to the database. On 4.0.12 the cpu usage never shot to over 20% and ran extremely fast. After upgrading to

Hardware recommendation

I am going to have to put MySQL on it's own box, and I am wondering what makes the biggest difference with hardware. I am hoping to set max_connections to 1000 at least (and I will probably use at least 500 several times a day). There are a few tables that are almost constantly running inserts,

RE: upgrade

Did you restart the server? -->-Original Message- -->From: Robert Morgan [mailto:[EMAIL PROTECTED] -->Sent: Thursday, August 07, 2003 1:19 PM -->To: mysqllist -->Subject: upgrade --> -->Hi I am using mysql 3.23.54 that came bundled with RH9. I have tried -->updating to version 4.0 using th

RE: Tracking a delete

> Ok, I know it WAS there because we have two similar tables that should > contain sister records. One table has a record the other doesn't so it > had to have been deleted. I need to find out WHEN it was deleted. > > How do I create a log of record deletes? > If you keep the update log or the

Tracking a delete

How can I see if a record was deleted from a database? Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: mysql LOAD DATA INFILE

Oh and just a note. This solution won't work if you are uploading the file to the server through the browser. You will need to put the file on the server and adjust the commands PATH accordingly. -Original Message- From: Donald Tyler [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 200

mysqlbug

Hi, I am a Sun solaris 5.6 user. I do not have su or any other system permissions We have PERL5.005 on the box We do not have DBD::mysql So I wanted to install that module into my private library. Mysql server is on a remote unix box So when I try to install the DBD::mysql module its looking

RE: mysql LOAD DATA INFILE

PHPMyAdmin uses the "LOAD DATA LOCAL INFILE" command. Just remove the word LOCAL and it should work fine. -Original Message- From: Mike At Spy [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 2:35 PM To: [EMAIL PROTECTED] Subject: mysql LOAD DATA INFILE When I come across this er

Re: Date Problem

* Girish Agarwal > Hi All, >I have added the date column ( column name is > dolv ) in mysql as CHAR(10) Then it is not a 'date column', but s string column... ;) See the manual for a description of the different column types: http://www.mysql.com/doc/en/Column_types.html > http://www.mys

Native Arabic speakers wanted

Dear all, the MySQL Documentation Team is looking for native Arabic speakers on this list who are interested in reviewing an Arabic translation of the MySQL reference manual. Reviewers will receive our gratitude, and will of course be mentioned in the credits section of the manual. If you're inte

mysqld cannot access innodb

Dear Sirs, I can not start MySQL server. More specifically, MySQL was running fine all the time since installation. It stopped working after I used FmPro Migrator to convert some File Maker databases to MySQL It looks like mysqld has no access permissions to InnoDB and I do not know how to fix

Re: order by question

* motorpsychkill > SELECT * FROM kf_gallery WHERE gallery_id IN ( 3, 1, 2 ) ORDER BY ? > > What I'm trying to do is get the results in the order specified > in the "IN" > clause, i.e. (3, 2, 1). Is this possible? (I'm having trouble searching > the mail archives). Thanks! Use the FIELD()

Re: MYSQL Scalability on SMPs

On Thu, Aug 07, 2003 at 10:27:38PM -0700, Steven Roussey wrote: > > MyISAM performance is limited right now by a global lock in the key > > cache. However, I believe there is work going on to fix that in the > > 4.1 tree. > > Really? I thought it was going to be fixed in the 5.1 tree, which will

transfer InnoDb in correct order ??

Hellu, I want to transfer the structure of my InnoDb database to another mysql server 3.23. However, I don't seem to get this to work correctly as the tables are not transfered in the correct order such that I get a bunch a foreign key constraints. Even if I use the MysqlPhp admin tool, Mysql M

Re: order by question

* motorpsychkill > Ahhh...I see now. I'm still in MySQL 3.23.54. Thanks anyways! It should work also in version 3.23.54... actually, it should work since version 3.20.17: http://www.mysql.com/doc/en/News-3.20.17.html > -- Roger -- MySQL General Mailing List For list archives: http://lists.m

RE: order by question

Ahhh...I see now. I'm still in MySQL 3.23.54. Thanks anyways! > -Original Message- > From: Cabanillas Dulanto, Ulises [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 07, 2003 2:52 PM > To: mysql > Subject: RE: order by question > > > I execute the SELECT and it works!. I have MySQL

Re: replication problem

> So does anyone else have any ideas what is going on here? Shall I > report this as a bug? Did you post how you setup the servers to load the different my.cnf files? Hopefully you don't have one at a default location. Otherwise, it sounds like the config information is not properly set -- eithe

RE: 1 query lock all others query

i've noticed that, when a thread "sending data" an "update" is first "locked" then other "select" is locked From: "xuefer tinys" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: 1 query lock all others query Date: Fri, 08 Aug 2003 02:31:14 +0800 i've once noticed it it has

Re: Unix date problems

On 7 Aug 2003 at 9:47, woody at nfri dot com wrote: > While I don't know for sure, my guess is that it would have something > to do with 32 bit as the magic number, but also...being that this > won't become a problem until > > mysql> select from_unixtime(2147483647); > +-

Re: MySQL 3.23 vs. 4.0

Hi! > Currently, I'm running 3.23.51 on Red Hat 7.1, and I'm contemplating > upgrading to MySQL 4.0, but I'm not sure what to expect. I don't know if > MySQL 4.0 is fully backwards-compatible with 3.23.x versions, or if > something is going to break if I upgrade. > > What are the main advantages

heading off in mysql?

Hi all, Just a quick question here. May I know how to get a result without heading in Mysql (like "set heading off" in Oracle) ? Thanks and regards, Helen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]