Matt Scales wrote:
I've just installed MySQL 4 4.1.12_1 +server using darwinports but I
can't seem to get past this error. After installing it tells me that
it cold not resolve my IP.
Why are you using darwinports instead of the official binary from mysql?
For reference, I've had success runni
I'm curious --- why do you have the extra parentheses in there, anyway?
Short answer: Because I'm a newbie to MySQL and I get confused easily.
Longer answer: Because I'm not very clear on the use of brackets. I
thought they defined parameters for a command. So, for example, INSERT
takes a
Have you tried removing the brackets ( ) from around the fields in the
SELECT part of the query?
I did as you suggested and ran the query without brackets, and it worked
perfectly.
Thank you for the speedy and helpful advice!
Dave
--
MySQL General Mailing List
For list archives: http://l
At 13:19 +0900 9/13/05, Dave wrote:
(Topic moved from "Copying data stored in different field formats
from one table to another")
MySQL General List,
Server specifications:
MySQL 4.1.3-beta, phpMyAdmin 2.5.7-pl1, PHP 4.3.8
My specifications:
MySQL beginner, PHP intermediate, HTML and C
Dave wrote:
The situation:
While trying to copy data over from one table to another, I have
encountered the following error:
#1241 - Operand should contain 1 column(s)
The query that I used which led to this error was this:
INSERT INTO forum_members( dateRegistered, realName, ID_MEMBE
While the basic issue of correct syntax is still open, this issue has
boiled down to a specific error message, so I've moved to a new thread
called:
""Operand should contain 1 column" error"
However, for future reference, the issue of variables has been solved. I
discovered that to make the
(Topic moved from "Copying data stored in different field formats from
one table to another")
MySQL General List,
Server specifications:
MySQL 4.1.3-beta, phpMyAdmin 2.5.7-pl1, PHP 4.3.8
My specifications:
MySQL beginner, PHP intermediate, HTML and CSS advanced.
The situation:
Whil
I recently discovered that the following
create table ttt (
id serial primary key,
txt text
);
show index from ttt
is telling me that there is a primary ke on id column with BTREE
and at the same time, there is another unique index on the id column.
This is redundant.
if the id column
Since MySQL-Cluster is not recommended over a WAN that's not an option. I
soon will be looking for a method to syncronize real-time data between a
active/passive datacenter setup. (One datacenter in Salt Lake City, Utah
and another in Las Vegas, Nevada)
At this time I don't think any 'out of t
Hi, Michael!
> Really? In 4.0? In which character set is '' equivalent to '%' to LIKE?
Thank you for the advertence, I was just going to figure it out:)
You are right, I haven't should asked to show me the collation.
Still I'd like to the see the value of character_set system variable.
Hello.
When the replication is configured, the slave is synchronized to a certain
position in the master's binary log. To make this synchronization
often LOAD DATA FROM MASTER is used (but you may fill the slave's
databases in different ways). After a successful setup replication
shouldn't b
Hello.
Yes, MySQL 5.0.12 a bit unstable yet. You may want to make a bug
report. See:
http://dev.mysql.com/doc/mysql/en/bug-reports.html
Or send the the list definition of your tables, problematic
queries and a stack trace. It would be great if you include
a test script which generates
Kevin,
From "http://www.innodb.com/todo.php";
*In progress:*
Add |FULLTEXT| indexes on InnoDB tables. A sponsor for this project
has been found, and a developer has been hired. Appears probably in
2006.
David.
Kevin Burton wrote:
Anyone know the ETA of having full-text index supp
Kevin Burton wrote:
Anyone know the ETA of having full-text index support on INNODB?
"Some time in 2006" -- http://www.innodb.com/todo.php
--
Jasper Bryant-Greene
Freelance web developer
http://jasper.bryant-greene.name/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
Anyone know the ETA of having full-text index support on INNODB?
Kevin
--
Kevin A. Burton, Location - San Francisco, CA
AIM/YIM - sfburtonator, Web - http://www.feedblog.org/
GPG fingerprint: 5FB2 F3E2 760E 70A8 6174 D393 E84D 8D04 99F1 4412
I've 10 server in differents locations, I want to make a broadcast, I
would like to have always datas synchronized between this network, each
database have the same tables and same structure. Each insert or update
in database will be executed for each server within this broadcast,
what's the be
I am trying to reload/rebuild a table from the backup and I get this message. I
cannot find any references for it.
[EMAIL PROTECTED] mysql-backup]# mysql -u root -p iepm <
/home/iepm/privatedir/mysql-backup/iepm-bw.cern.ch.iepm-abwedata.08-16-2005
Enter password:
ERROR 1030 (HY000) at line 52: G
Quoting [EMAIL PROTECTED]:
hello
I have a box with CentOS 4 kernel 2.6.9-11 with vpopmail 5.4.9 courier-imap
4.0.2 with courier-authlib 0.55 and mysql 4.1.7
A few days ago, I have a very messages like this in my errors logs:
vmysql: error creating table 'limits': MySQL server has gone away,
Here's some thing I've been thinking about.
I want to use INNODB without FKs. I don't need or want referential integrity
in my app (due to a schema and performance issue).
Basically I just create FKs in my OR layer and my app enforces the rules.
The column is still an _ID column so I visually k
clint lenard wrote:
can anyone help me with this question? (about using Smarty)
No doubt -- but that "anyone" would likely be on a Smarty-specific
(or at least PHP-oriented) mailing list, eh? :-)
--
Hassan Schroeder - [EMAIL PROTECTED]
Webtuitive Design === (+1) 4
can anyone help me with this question?
On 9/12/05, clint lenard <[EMAIL PROTECTED]> wrote:
>
> Hey Douglass,
>
> Curious about using Smarty (taking the Crash Course and bookmarked a
> couple of other tut's)... One of the advantages of using a DB to store the
> HTML Sites was the opportunity to
hello
I have a box with CentOS 4 kernel 2.6.9-11 with vpopmail 5.4.9 courier-imap
4.0.2 with courier-authlib 0.55 and mysql 4.1.7
A few days ago, I have a very messages like this in my errors logs:
vmysql: error creating table 'limits': MySQL server has gone away, referer:
http://admin.mario.c
Has anyone tried using the embedded server with MySQL 5.0 yet? I have
an application that I'm anxious to take advantage of triggers with.
It's not a money maker, so it's no big deal if it has a few quirks, but
if it's just totally a "bad idea" right now, I won't risk it.
The main reason I'm consi
bruce wrote:
hi...
i have a situation with a server that i have. i have mysql installed with
php..
the mysql is V4.1.12. i'm trying to see/view a database from the command
line and i can't see it when i login to mysql as root. i also can't see it
when i try to login to mysql as the given user.
[EMAIL PROTECTED] wrote:
> Hi all,
>
> I've got a question. We were testing something on our mysql server (
> 4.0.21) with MyISAM tables.
>
> When we executed the query "select * from people where name like '';" we
> expected the same results as "select * from people where name='';" but it
> didn'
hi...
i have a situation with a server that i have. i have mysql installed with
php..
the mysql is V4.1.12. i'm trying to see/view a database from the command
line and i can't see it when i login to mysql as root. i also can't see it
when i try to login to mysql as the given user.
from the php a
Obantec Support wrote:
It was suggested that i could run a second server. as i have FC3 i use yum
to add / update programs.
are you suggesting i get the source , unpack and build the server setting
some configs to run it on a different port?
Not source, just get the proper binary, untar it and
I guess I can understand that. I still think it blows that using
huge.cnf vs. the standard config results in the huge.cnf showing worse
benchmarking results. if what you are saying is correct (I don't doubt
your statements in the slightest) I would have hoped to at least seen
identical performanc
My original question was how to add InnoDB support to 3.23.58 server.
It was suggested that i could run a second server. as i have FC3 i use yum
to add / update programs.
are you suggesting i get the source , unpack and build the server setting
some configs to run it on a different port?
Mark
--
Obantec Support wrote:
I found upgrading info but no info on how to install a second mysql server.
`tar xvfz` works the same for one or many :-)
Do you have a specific question?
--
Hassan Schroeder - [EMAIL PROTECTED]
Webtuitive Design === (+1) 408-938-0567 ===
Hi
I found upgrading info but no info on how to install a second mysql server.
Mark
- Original Message -
From: "Gleb Paharenko" <[EMAIL PROTECTED]>
To:
Sent: Monday, September 12, 2005 12:42 PM
Subject: Re: Adding InnoDB support
> Hello.
>
> Usually it is not so simple and many provi
To its benchmarking limits, yes. But benchmarks and real-world
performance almost
never closely parallel. If the purpose here is to set my.cnf optimally,
then it needs to
be set in accordance with your real usage patterns.
You probably won't see a big improvement in the benchmark between my.cnf
At 15:17 +0530 9/12/05, [EMAIL PROTECTED] wrote:
This is from the docs . "The auto-increment value of a deleted
record will only not be reused until the server is restarted, then
it will be reused. In other words, if you insert 10 rows into an
InnoDB table and then delete them the AUTO_INC
Hello.
Usually it is not so simple and many providers install another
MySQL server and then clients move their applications to it. See:
http://dev.mysql.com/doc/mysql/en/upgrade.html
Use an official rpms or binaries from:
http://dev.mysql.com/downloads/
"Obantec Support"
Hello.
> Now if i have records 1 to 10 and i delete some records in between , say, 5,
> 7, 8. Now when i restart my server, will these values of 5, 7 and 8 be
> reused??
No, they won't be reused until your column has values more than 5,7 or 8. The
AUTO_INCREMENT counter initialized to
Hello.
I was unable to repeat this situation on my MySQL 5.0.12. See:
mysql> create table tlike (a char(10));
Query OK, 0 rows affected (0.01 sec)
mysql> insert into tlike values('abc');
Query OK, 1 row affected (0.02 sec)
mysql> select * from tlike where a like '';
Empty set (0.00 s
[EMAIL PROTECTED] wrote:
This is from the docs . "The auto-increment value of a deleted
record will only not be reused until the server is restarted, then it
will be reused. In other words, if you insert 10 rows into an InnoDB
table and then delete them the AUTO_INCREMENT value will stay
MySQL 5.0.12 crashed when I tried to select, backup or left join from
certain table with 431433 rows with Data length of 23.6 MB using InnoDB
engine. Tested on MySQL 4.1.14 with no problem in all aspects. Has this
occured to anyone before?
--
Please avoid sending me Word or PowerPoint attachme
I'm setting up a database replication between a master and a slave. Why
I need to use command |"LOAD DATA FROM MASTER" ? Can The replication
process synchronize data e table structure at startup without launching
loading commands ? Once ||synchronized with master the slave need again
to be upda
Sorry guys,
Worked it out, if anyone is interested here is the query:
INSERT INTO Allocations(Project_ID, User_ID)
SELECT P.Project_ID, U.User_ID
FROM Users U, Projects P, Clients C
WHERE P.Client_ID = C.Client_ID
AND U.Client_ID = C.Client_ID
AND Project_ID = 2
""Shaun"" <[EMAIL PROTECTED]> wro
Hi,
I have four tables: Projects, Users, Allocations and Clients. A Client will
have many projects and many Users, Users are allocated to Projects via a
link table - Allocations. When I add a project I want to have an option of
allocating all users to the project, can this be done with a select
> This recipe is intended to minimize the impact on ongoing database
> operations by inhibiting writes only during a relatively speedy
> operation (creating a snapshot). The long dump operation can ...
This seems to be a rather long winded way of doing this. Why not
replicate the database and th
not sure i completely understand your question but i think the user
enters a date, and you want to delete all records that match that date?
also i'm assuming that the entered date hits your script as a post
variable.
if so, you need to convert the posted date into the same format as the
records i
I have a php/mysql database with articles. What I need is a php sctipt or
some mysql that will compare the current day with the 'expiry date'
entered by the user and if the there is a difference then drop it from the
database..
I am fairly new to mysql so do not know if there is
a way
> > Qus 2. Is there any other way to compute the db size (other
> than disk
> > quota).
> >
>
> du -s mysql_data_directory
If you want to know the size of a /single/ database (i.e. schema) then
this method works if there's just one database in the
mysql_data_directory. If there are multiple da
This is from the docs . "The auto-increment value of a deleted record will
only not be reused until the server is restarted, then it will be reused. In
other words, if you insert 10 rows into an InnoDB table and then delete them
the AUTO_INCREMENT value will stay at 11 until the server is s
SET collation_connection = utf8_general_ci;
on my server (4.1.14) and it seems to work
I made a new Query, copying the text as you wrote it, and it still
didn't work, but in a different way.
I type:
SET collation_connection = utf8_general_ci;
... and I get the following returned to me:
Your
Dave,
I've tried
SET collation_connection = utf8_general_ci;
on my server (4.1.14) and it seems to work so
I'm afraid I can't help you anymore there.
/Johan
Dave wrote:
My hunch here is that your ' ' in the CONCAT_WS defaults to
latin1_swedish_ci.
It seems you're right. There are a few var
My hunch here is that your ' ' in the CONCAT_WS defaults to
latin1_swedish_ci.
It seems you're right. There are a few variables that are still in
default mode which I discovered through the SHOW VARIABLES command. I've
tried to switch them, but I'm obviously using the syntax incorrectly. I
Dave,
I'm not that good when it comes to collations but latin1_swedish_ci is
normally the default collation for a MySQL installation. Have you
checked via "SHOW VARIABLES" that you don't have latin1_swedish_ci
lurking somewhere. My hunch here is that your ' ' in the CONCAT_WS
defaults to latin1_sw
Hello.
>After reading through the MySQL manuals, as suggested here, I attempted
>to construct the following statement to copy data from the table "members"
>to the table "forum_members":
Please, keep your answers on the list. Use INSERT ... SELECT. Don't put
the functions in the column lis
Hello.
> 1) i'm trying to figure out how to allow a user to search through a
Full-Text search functions might be helpful. See:
http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html
> 2) if i have a query that produces a number of rows, how/what would i need
> to do, to limit the numbe
I think your problem is that you're trying to call one of your columns
MD5(passwd)
Thank you for pointing that out. I had the function in the wrong part of
the statement. Actually, I've realized I'm probably best off to leave
the passwords alone for now, and go ahead and copy the rest of th
Hi Dave,
I think your problem is that you're trying to call one of
your columns MD5(passwd) and my guess would be that you should do:
INSERT INTO forum_members( passwd, dateRegistered, realName,
ID_MEMBER, memberName, emailAddress, active, keitai, number, admin,
cardpic, cardbio, hofpic, hofbio
Hi
1 user has requested InnoDB support. can i simple get the mysql-max rpm an
use yum to install over the existing mysql server.
currently running FC3 with default 3.23.58
I would upgrade to 4.x but a lot of user databases and i am worried about
loosing data, so for now a quick fix is in order.
After reading through the MySQL manuals, as suggested here, I attempted
to construct the following statement to copy data from the table
"members" to the table "forum_members":
INSERT INTO forum_members( MD5(passwd) , dateRegistered, realName,
ID_MEMBER, memberName, emailAddress, active, kei
Hello Shawn,
Thanks for your comment.
It must be helpful.
Moreover, we would like to know;
1. when row-level-replication starts? (every time after issuing SQL statement?)
2. is it "two-phase-commit" or "synchronous" replication?
Thanks,
Kenji
On 9/9/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wro
Hey Douglass,
Curious about using Smarty (taking the Crash Course and bookmarked a couple
of other tut's)... One of the advantages of using a DB to store the HTML
Sites was the opportunity to give the user an automated Zip file of their
site if they wanted to download it and create their own si
58 matches
Mail list logo
