I have an installation of 4.1 and 5 running on the same test server... I
want to start using 5 for testing but still want to use the same test data
I had before... Is it possible to simply point MySQL 5 to the old 4 data
dir?
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
Levi Campbell said:
> Okay, I've got MySQL installed but now I can't start the server deamon,
> when
> I try to start it as the root user, I get the following: "Warning: asked
> for
> 196608 stack space but got 126976" but on the user mysql I get: "bash:
> mysqld: command not found."
>
> What do I
Original Message
Subject: Re: mysql.sock
From:"Jonathan Villa" <[EMAIL PROTECTED]>
Date:Sat, July 24, 2004 1:42 pm
To: "Levi Campbe
I'm maintaining 2 instances of MySQL running as slave/master on the same
machine. I was asked to install MaxDB on the slave server for testing...
The purpose of this post is for clarification... is MaxDB it's own db
instance or does it need MySQL running already running...
Depending on that answ
I have MySQL 4.1 installed via rpm. I just installed a new hd because I
want another MySQL installation on the same machine but acting as a
replication server.
At the same time, I want to try out MaxDB on this new installation. Does
that mean that I can't set up a master/slave replication with t
I'm administering a Red Hat machine which is used soley for MySQL. The
person working with the db has more than 15 million records in various
tables...they were trying to run some queries to create one table from
these many tables. When this was happening, they ran out of disk space.
They had abo
I'm administering a Red Hat machine which is used soley for MySQL. The
person working with the db has more than 15 million records in various
tables...they were trying to run some queries to create one table from
these many tables. When this was happening, they ran out of disk space.
They had ab
How exactly are you doing it with phpMyAdmin? Not sure if it would be save
to a temp dir, I usually get a save as option.
Sorry I can't see your batch file because Outlook blocked it, since it was a
batch file. I'll be checking my email from my Linux machine later, I'll
take a look at it the
I wonder if he means that he wants to pull data from one db into another
using a script of some kind.
If that is what you mean, why not give phpMyAdmin a try, unless your hosting
company already has it. Many do now a days...
Please clarify.
-Original Message-
From: Paul DuBois [mailto
03-03 at 07:27, Victor Medina wrote:
> > A few things to try:
> >
> > 1.- did you create the data dir as root?
> > chown mysql.mysql -R /var/dir-where-you-install
> > 2.- who owns the mysql data dir and it's parent dirs?
> > ls -lka /var/dir-wher
ase directory
>
> On Wed, 2004-03-03 at 07:25, Jonathan Villa wrote:
> > Ok, I have installed MySQL many times and have never come across this...
> >
> > when try to run
> >
> > ./bin/mysqladmin -u root password 'new-password'
> >
> > I g
Ok, I've always used intel machines, but this time I'm stuck using a
AMD Athlon(tm) XP 1900+
The only AMD I see for download is the AMD64, which is not what I have
and also gives me a warning before installation...
So, which should I use? There is
Linux (x86, libc6)
Linux (S/390)
Linux (IA64)
Ok, I have installed MySQL many times and have never come across this...
when try to run
./bin/mysqladmin -u root password 'new-password'
I get the following
./bin/mysqladmin: unable to change password; error: 'Table 'user' is
read only'
I've never had this happen, and unfortunately do not kn
Ok, I am going about this as I normally have umpting times
# scripts/mysql_install_db
and I get
Neither host 'isdesign.isdesigndev.com' and 'localhost' could not be
looked up with
./bin/resolveip
Please configure the 'hostname' command to return a correct hostname.
If you want to solve this
It wasn't code, just an example to get my question across clearly...
I will try the IN, however the manual says "Returns 1 if expr is any of
the values in the IN list" I want to do it for every value. So I'm
trying to accomplish this in one query:
UPDATE users SET status = no WHERE name = bob;
UP
I have a loop which is similar to the following:
while(array contains elements) {
UPDATE users SET status = no WHERE name = array[i]
}
great, it works but the query runs many times. I want to make only one
call to the database and have all the elements in the array be included
in the query
--
Has anyone every connected Lotus Notes/Script to MySQL?
Someone asked me about it and I can't seem to find any information on
Google... and I don't know much of MySQL...
Would I have to have built MySQL with ODBC support? I installed the
binary so wouldn;t this already be available...
--
MySQ
Check the ownership (and permissions) of your .
Maybe your is owned by user "mysql" and not "mysqladmin" and
then "mysqladmin" can't write to .
You may find what your datadir is with:
# mysqladmin var | grep datadir
Hope this helps,
On Fri, 2003-09-05
I installed MySQL 4.0.14-standard from binary onto a Red Hat 8.0 system.
I always follow the steps described in INSTALL-BINARY as well as review
what shows up when I type ./configure.
The only thing I did this time around was that I changed the user's name
from mysql to mysqladmin. I get the fol
I've installed MySQL on Linux more than a few times... so I got the
process down... however, now I am trying to install on FreeBSD.
This what I am doing...
1. tar zxvf mysql...freebsd.tar.gz -C /usr/local/mysql
2. cd /usr/local/mysql
3. ./configure (just to get the message)
I get the following...
I have a shopping cart which creates temporary tables in the format of
zorder_;
These tables are used to hold a customers order while they shop and
after checking out, it is dropped. The values of the shopping cart are
put together in an HTML table and stored as their history.
What I want to
I have a shopping cart which creates temporary tables in the format of
zorder_;
These tables are used to hold a customers order while they shop and
after checking out, it is dropped. The values of the shopping cart are
put together in an HTML table and stored as their history.
What I want to
You'll have to check if the result is NULL or not. Try this
" : ""; ?>
This is print out nothing if your result is equal to null.
On another notes, how do you specify the width and height of this image?
Or the alt tag, or set the border so that on older versions on Netscape
it does not defau
Is your database configuration the same on both environments? Usually
this error comes querying for the wrong table/column name. I have also
seen this error when, for example, customer_id = NULL, and in my script
I say WHERE customer_id = $customer_id.
---> Jonathan
-Original Messag
AIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Querying for performance...
At 13:19 -0600 3/31/03, Jonathan Villa wrote:
>All,
>
>I have been writing my applications using PHP/MySQL for about a year
and
>a half now. During this time and up to now, there hasn't been anything
>wron
All,
I have been writing my applications using PHP/MySQL for about a year and
a half now. During this time and up to now, there hasn't been anything
wrong with my apps; however, I need to know if what I am doing is the
best route for optimal performance.
So I ask these questions:
1. How
Well, I thought I could figure it out but I guess I couldn't.
This is exactly what I want to do...
//Using Access now, but when I use MySQL, I can just get the last insert
id.
$itemID = $_POST['item_id'];
$itemQty = $_POST['item_qty'];
$itemPrice = $_POST['price'];
$orderID = Will be a value take
All,
Is this query possible to do:
I am going to select an id from a table
SELECT order_id FROM orders WHERE order_start = 1324
I will then use the order_id from this query and insert it as well as
some others values I have into another table.
So in summary, I want to perform a SELECT and IN
28 matches
Mail list logo
