I¹m running MAMP (www.mamp.info) on my Mac OSX box as a local way of
developing. I¹m running into a slight problem that the mamp site doesn¹t
talk about. The 1.5 beta1 seems to have the option skip-innodb enabled and
I can¹t seem to find out where this is located to disable it and enable the
use
1) both tables are InnoDB.
2) both tables have data in them.
3) both table are the exact same data types.
On 2/20/07 3:51 PM, "Chris White" <[EMAIL PROTECTED]> wrote:
> Jay Paulson wrote:
>> I really don¹t know what to do because I keep getting this error. Any
&
I really don¹t know what to do because I keep getting this error. Any
ideas?
SQL query:
ALTER TABLE pl_reports ADD CONSTRAINT fk_region FOREIGN KEY ( region )
REFERENCES Region( id ) ON UPDATE CASCADE ON DELETE CASCADE
MySQL said: Documentation
#1005 - Can't create table './survey_localhost/#sq
I'm setting up our one server for staging and development. I am need to set
up MySQL to have 2 copies of the same database on the same server. Could
anyone direct me to some documentation or tell me how to do this?
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
A couple questions since I'm not a Solaris person I really don't know how to
do the following and was hoping that someone could help me out (Google isn't
much help on this).
How does one start the MySQL daemon on Solaris 8? (it's running MySQL
3.23.49)
How does one tell Solaris 8 to start the MyS
I'm currently setting up MySQL 4.1.2 on RHEL 4.1 and I have found the
/etc/my.cnf file. I'm trying to find out if I change the "basedir" from:
Basedir=/var/lib
To
Basedir=/other/path
Will that move the actual data files that have all my databases? Do I need
to move any of the things that are
I have no idea if this is possible or not but is there a way to run Apache,
PHP, and MySQL from a CD? I'd like it to be possible to run it on Windows,
Mac OSX and *nix. If it is possible could someone point me in the right
direction?
Thanks!
--
MySQL General Mailing List
For list archives: htt
Take a look at the MySQL function INET_ATON and it's counterpart (I don't
remember what it's counterpart is but it should be easy to find once you
find INET_ATON).
I know in PHP there is a function that will convert x.x.x.x to an int and
then you just put that int into a field in your database and
> I'm logging IP addresses and also searching for existing ones. Does
> anyone happen to know which is more resource intensive: storing the
> IP's as integers using INET_NTOA() and INET_ATON() to convert them at
> each query; or simply storing the IP as a varchar? In each case the
> IP field would
>From the result set below I have 22 rows and the only difference is the
date. I was wondering if there was a way to get all of these results using
GROUP BY instead of having to use LIMIT??
As this table grows I'm going to want to get a LIMIT 0,77 but would like it
to be grouped by date. So basi
o properly execute what it needed. So if you run into this
simply check each directory within the path and make sure of it's
settings"
-Original Message-----
From: Jay Paulson (CE CEN) [mailto:[EMAIL PROTECTED]
Sent: Wed 1/11/2006 11:17 AM
To: mysql@lists.mysql.com
Subject: LO
I'm creating a file via PHP after getting information from a log file. I
create a new file for data import into a table in MySQL. For some reason now
I'm getting this error below. I have no clue what it means. I've checked the
file and it is all there and I've even changed the permissions on
I would totally agree with this. I moved from using Fedora Core 3 to SuSE 9.3
and haven't looked back. YaST is one of the best tools out there. With the
stuff you have installed it would be best just to start over with a new
install. :)
jay
-Original Message-
From: George Law [mail
I was doing some testing with our development mysql server (4.1.x) and one of
the databases died and wouldn't let me do anything not even read the tables in
the database. So I thought I would bring it down and start it back up. I
proceeded to use ./mysqladmin shutdown command which did what I
-Original Message-
From: Stefan Hinz [mailto:[EMAIL PROTECTED]
Sent: Fri 1/6/2006 12:40 PM
To: Michael Stassen
Cc: Jay Paulson (CE CEN); Gleb Paharenko; mysql@lists.mysql.com; [EMAIL
PROTECTED]
Subject: Re: Help with a SELECT query
[1] The reasoning behind this: Is it relevant for a 5.0 use
e your
application which inserts data to the database explicitly determine
the type of the content (perhaps, you should add a field which will
indicate the content. I agree, that this is a superfluity, however
the speed of the query is more important).
"Jay Paulson (CE CEN)" <[EM
Below is a query I'm trying to create and the sql for the table I'm pulling the
information out of. The query is definitely not the best query out there
especially since I'm still pretty new with sql. I know there has to be a
better way of getting the information I want. A little background.
> I have no idea what you are asking, which may explain why no one has
replied
> to your question yet.
>
> I've been working with relational databases for 20 years and I've never
> heard the term "calendar table". What are you trying to accomplish? If you
> describe clearly what you are trying to d
My query below returns however many rows fit the WHERE condition, in this case
when they year, period, week is <= 2009131. In my case it is returning 11 rows
because I have 11 rows where the year,period, week is 2006XXX. However, this
is not what I want. I only need 4 rows returned to me and
> You might be able to use the CAST() function.
>
> http://dev.mysql.com/doc/refman/5.0/en/cast-functions.html
Unfortunately our producation machine is using MySQL 3.23.x and from what I've
found the cast() function isn't available. :(
"CAST() and CONVERT() are available as of MySQL 4.0.2."
> You can cast data tyes explicitly:
> http://dev.mysql.com/doc/refman/5.0/en/cast-functions.html
Now that is cool. Too bad we are using MySQL 3.23.x on our production box. I
can't use it. :(
> If this table is going to get large then you might find it too slow to use
> that method. Your quer
I have a strange question for you all. I've inherated some code and the way
the code works is that I can only mess with the WHERE part of a query.
Therefore, I was wondering if something like this would be possible.
WHERE where concat(year,period,week) as type int < 2007031
Note that I'm tryi
Or if you have any applications that are accessing this database you could
look at the config files for it and most likely the password will be
there.
jay
>
> Username you can get it from the user table in Mysql. But I don't think
> atleast after MySQL 4.1 there is a way to retrieve paswords in M
Hi everyone,
Long time reader, first time poster.
I've been using MySQL for some years now and never really did any
advance stuff in it. I mainly do updates, deletes, and selects. My
selects aren't even that complex as I don't have a very good
understanding of the join syntax and exactly wh
Like an idiot I locked myself out of the mysql database when I went to
change the password for the root user. Is there any way I can get back
into that database and restore my mistake?
Thanks,
jay
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:h
Hello-
I'm trying to get random information out of my table and the query I'm using keeps
returning the same row every time. In the table I have 3 rows and I want to choose at
random in the sql which row to return. Here's an example query I have.
SELECT * FROM banner ORDER BY rand() asc limit
I want to do a query that will find all the titles I have in my db that
start with numbers and ambigious characters (i.e. 0-9, &, #, $ etc...). My
query is below, however I don't know what to change the "a" too in order for
it to return what I just described.
select id, shortdescription, title f
I'm trying to increase the maxium number of connections to my MySQL database
but I am not sure how to do this. I've gone to the manual and it doesn't
say too much (maybe i'm looking in the wrong spot?). The machine I'm
running is an AMD 650 with 512 Ram on RedHat 7.1 and MySQL 3.23.41 so I
found
>
To: <[EMAIL PROTECTED]>
Cc: "Jay Paulson" <[EMAIL PROTECTED]>
Sent: Thursday, January 24, 2002 10:31 AM
Subject: RE: How do you know?
> * Jay Paulson
> > How do you know what the maximum connections you can have at one time
with
> > mysql?
>
> m
How do you know what the maximum connections you can have at one time with
mysql?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To requ
I'm trying to change the root password for mysql. This is the first time
I've tried to change the password and I can't get it to work. Below is the
error message I get:
[root@localhost bin]# ./mysqladmin -u root -p password 'new-password'
Enter password:
./mysqladmin: connect to server at 'loca
I'm running RedHat 7.1 and I'm trying to run mysql. I've gone and run the
mysql_install_db then I try to run the mysqladmin -u root -p password
'new-password' and I get the following error:
error: 'Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)'
Check that m
What is the command in MySQL to grab the last item that was inserted into
the database?
thanks...
jay
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the l
33 matches
Mail list logo
