Im trying to set up a primary key of server(text), date (date), hour
(small int) but when i try to include the server field in the key it
replies with
ALTER TABLE `exim` DROP PRIMARY KEY ,
ADD PRIMARY KEY ( `date` , `hour` , `server` )
#1170 - BLOB/TEXT column 'server' used in key
Ronan [EMAIL PROTECTED] wrote on 16/02/2006 11:56:18:
Im trying to set up a primary key of server(text), date (date), hour
(small int) but when i try to include the server field in the key it
replies with
ALTER TABLE `exim` DROP PRIMARY KEY ,
ADD PRIMARY KEY ( `date` , `hour` , `server`
Hi there,
Im trying to set up a primary key of server(text), date (date), hour
(small int) but when i try to include the server field in the key it
replies with
ALTER TABLE `exim` DROP PRIMARY KEY ,
ADD PRIMARY KEY ( `date` , `hour` , `server` )
#1170 - BLOB/TEXT column 'server' used
hi,
since 3 days, i'm trying to connect to MYSQL 5.0.18 from php scripts using
Apache et Macromedia 2004 Dreamweaver.
Could someone help me doing this?
Best regard.
-
Nouveau : téléphonez moins cher avec Yahoo! Messenger ! Découvez les
persant mpote [EMAIL PROTECTED] wrote on 02/16/2006 10:29:37 AM:
hi,
since 3 days, i'm trying to connect to MYSQL 5.0.18 from php
scripts using Apache et Macromedia 2004 Dreamweaver.
Could someone help me doing this?
Best regard.
-
Nouveau :
All,
I'm looking to output every piece of data from the database line by line. Is
there any
methody by which 'mysqldump' can output the following?:
use MY_DATABASE;
CREATE TABLE IF NOT EXISTS MY_TABLE;
ALTER IGNORE TABLE MY_TABLE ADD MY_COLUMN [properties]
ALTER IGNORE TABLE MY_TABLE ADD
Mysqldump can do all the following except dump the ALTER commands, it will
log the create statement of the table as the table exists. Mysql doesn't
keep a record of what, when, how a table was altered only the final result.
Look at the mysqldump options for the stuff you want to do by typing
Thanks Dathan,
But I'm more concerned with ALTER than anything. As I said, I basically want
to be able to
output field, type, etc. by row so that *if* the receiving DB needs to add a
field it can do so
without having to nuke the table with all data in it just to add all fields
again with a
My suggestion: Modify the source of mysqldump yourself.
After all, it is open source. Make sure you adhere to any and all
licensing requirements and copyright notices and you will keep yourself
out of any legal trouble.
For the vast majority of users, replication is a better solution than
Shawn,
I'd actually considered such, but I was hoping for it to already be present.
I'm currently on a
tight deadline to finish a project I'm working on so devoting time to getting
'mysqldump'
stable enough to then propagate across corporate servers in such a short period
is not very
Hi Michael,
Have you considered a Master-Master (or more if required) replication
setup for achieving what you mentioned below? That would certainly
provide the I'll show you mine if you show me yours scenario.
I can recommend the High Performance MySQL book by Jeremy Zawodny as
it has an
Rather than changing the function of the mysqldump program, why not
massage its output to your specifications.
Dirk Bremer - Senior Systems Engineer - ESS/AMS - NISC Lake St. Louis MO
- USA Central Time Zone
636-755-2652 fax 636-755-2503
[EMAIL PROTECTED]
www.nisc.coop
-Original
I am trying to connect to my MySQL 4.x server from a new machine. I am
getting this error:
Got error: 1045: Access denied for user 'user'@'192.168.2.56' (using
password: YES) when trying to connect
BUT I have a user setup in mysql with allowed access from
'%.willcomminc.com'. The machine I'm
did u start mysql with --skip-name-resolve ???
Kishore Jalleda
On 2/16/06, Ryan Stille [EMAIL PROTECTED] wrote:
I am trying to connect to my MySQL 4.x server from a new machine. I am
getting this error:
Got error: 1045: Access denied for user 'user'@'192.168.2.56' (using
password: YES)
Nope.
_
From: Kishore Jalleda [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 16, 2006 4:32 PM
To: Ryan Stille
Cc: mysql@lists.mysql.com
Subject: Re: User is rejected because of IP, but hostname is
allowed
did u start
First you need to make sure that you have a running mysql
server for the client mysql program to connect to. If the
server is not runing, you will obviously not be able to
connect to it.
I find the following utility very helpfull - been messsing
around with it today.
I searched the other lists and couldn't find one that was more appropiate for
this question; if there is, please tell me so :)
I am monitoring networking equipment and so far I'm saving all my data in a
MySQL database (hence an email to this list). I'm using only VARCHARs because
the SNMP
mysql describe prueba;
+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-+---+
| inte | int(2) | YES | | NULL| |
| stri | char(2) | YES | | NULL| |
Hi Ariel,
It works fine for me
localhost.testshow create table mytest\G
*** 1. row ***
Table: mytest
Create Table: CREATE TABLE `mytest` (
`id` int(11) NOT NULL auto_increment,
`test_col` varchar(10) default NULL,
PRIMARY KEY (`id`)
)
David Godsey wrote:
This might be an unusual question because mysql always stores in little
endian for all platforms (if I'm not mistaken). However, I am receiving
data from several different platforms (custom boards with various
processors) in raw form. I will have stored as a configuration
20 matches
Mail list logo