I expect using the Master_log_File should be fine since the slave caches the
sqls in its own Relay_Log_File using the IO Thread.
Arvind Gangal
internet: http://www.lastminute.com
do something lastminute.com
-Original Message-
From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED]
I want to redirect output of the query to the file in tab delimited
format. Can this be done?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Jerry Swanson wrote:
I want to redirect output of the query to the file in tab delimited
format. Can this be done?
Thanks
Select ... INTO OUTFILE:
http://dev.mysql.com/doc/mysql/en/SELECT.html
or mysql -e (documentation on the same page)
HTH,
Wolfram
--
MySQL General Mailing List
For list
Hi,
I would like to know how to connect to the mysql database using a
DSN in mysql API's. I am using myodbc 3.51 driver.
Used the following API code for the connection
MYSQL *link = mysql_init(NULL);
MYSQL *connectHandle =
mysql_real_connect(link,localhost,root,,test,0,NULL,0);
Hello all,
After playing with the idea of 'abandoning ship' in favor of IBM DB2
or Oracle, we deiced to stick with mySQL, due its simplicity and
investment in time and experience we have put into it.
Our company needs a HA solution for ensuring 24x7 operation for the
mySQL server instances. As
On 4 Nov 2004 at 0:59, Schalk Neethling wrote:
Since installing the latest 4.1 version of MySQL I have not been able to
run phpMyAdmin.
I have since gathered that the current version of phpMyAdmin is not
compatible. I therefore ran Add/Remove programs on Windows and installed
4.0.22 but
Hi.
Look at the output of
show variables like '%character_set%';
show variables like '%collat%';
show create table 'your_table';
Are all character_sets and collations the same?
Keith Morris [EMAIL PROTECTED] wrote:
We are in the process of upgrading our installation of MySQL
Hi.
See:
http://dev.mysql.com/doc/mysql/en/Repair.html
Abaghan Ghahraman [EMAIL PROTECTED] wrote:
hi
i have a PHP/MYSQL site in witch i have some scripts creating some tables.
my host crashed several times this week and then many of my already
created databases corrupted.the error
Hi.
Send us information about operating sytem and MySQL version you use.
May be it will be helpful to install official binaries with enabled debug support of
the
latest release.
I am using INSERT DELAYED ... to insert log records into a MyISAM table. Recently
these
inserts have
Hi.
What operating system do you use? If you use MySQL compiled manually, it may be
helpful to use official binaries of the latest release.
You can look for some clues at the end of the .err log file.
Ginger Cheng [EMAIL PROTECTED] wrote:
Hello, MySQL Gurus,
I have a mysql
Hi.
select concat(database(),_utf8.,_utf8'table')
works fine. It is not clear for me - what is the problem? You can choose charset
according to your local settings.
Nick Arnett [EMAIL PROTECTED] wrote:
I don't see a way to ask MySQL what the full name of a table is... the
Hi.
First, how can I detect, on localhost, which port MySQL is using?
Look at my.cnf.
Also see:
http://dev.mysql.com/doc/mysql/en/Can_not_connect_to_server.html
Schalk Neethling [EMAIL PROTECTED] wrote:
Since installing the latest 4.1 version of MySQL I have not been able to
Hi,
The following query works out the amount of hours a user has been booked for
on a particular day:
SELECT
(SUM(((DATE_FORMAT(B.Booking_End_Date, %k) * 60 ) +
DATE_FORMAT(B.Booking_End_Date, %i)) -
((DATE_FORMAT(B.Booking_Start_Date, %k) * 60 ) +
DATE_FORMAT(B.Booking_Start_Date, %i))) / 60 )
Thanks, I go the dump now. but when i go to import the dump:
mysql -D sd2000 -u root mysqldump.txt
Im getting errors; ERROR 1064 (42000) at line 355: You have an error
in your SQL syntax; check the manual, etc!!!
What does this means?
On Wed, 03 Nov 2004 09:23:53 +0200, Gleb Paharenko
I just wanted to say that I think it's great that people like Heikki
Tuuri monitor this list and contribute to it.
Kudos to you!
Heikki Tuuri wrote:
snip
Best regards,
Heikki Tuuri
Innobase Oy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
From: shaun thornburgh [mailto:[EMAIL PROTECTED]
Hi,
The following query works out the amount of hours a user has
been booked for on a particular day:
SELECT
(SUM(((DATE_FORMAT(B.Booking_End_Date, %k) * 60 ) +
DATE_FORMAT(B.Booking_End_Date, %i)) -
((DATE_FORMAT(B.Booking_Start_Date,
I cannot see in mysql online manual Embedded example
(http://dev.mysql.com/doc/mysql/en/libmysqld_example.html) any pathname
telling where de database will be saved in disk. So I suppose it must be
some existing database especified on some configuration file.
Could be embebbed mysql be a
On Thursday 04 November 2004 01:13, [EMAIL PROTECTED] wrote:
To confirm that you would like
[EMAIL PROTECTED]
added to the mysql mailing list, please click on
the following link:
http://lists.mysql.com/s/mysql/4189d686a90fba48/lists=buddhalinux.com
This confirmation serves two
Hi.
You may send us fragment of your file, near line 355.
spiv007 [EMAIL PROTECTED] wrote:
Thanks, I go the dump now. but when i go to import the dump:
mysql -D sd2000 -u root mysqldump.txt
Im getting errors; ERROR 1064 (42000) at line 355: You have an error
in your SQL
At 09:14 AM 11/4/2004, you wrote:
I cannot see in mysql online manual Embedded example
(http://dev.mysql.com/doc/mysql/en/libmysqld_example.html) any pathname
telling where de database will be saved in disk. So I suppose it must be
some existing database especified on some configuration file.
Hi.
You may tell MySQL where the data files are stored in the argc,
when you are calling mysql_server_init. Also you may put other
server variables into this array.
I think, MySQL can do most tasks, which you are looking for.
See:
Hi,
I need to make relationishp between 4 tables in my system.
I just don´t know how to make.
Somebody could help me, please?
The tables are: Order, Employee, ItensOrder and Unit.
My objective: to program a report of Order that appears in the screen the fields (
id_order, name_employee,
The attachment describing your tables didn't come through. However,
here's roughly how your SELECT statement might look:
SELECT Order.id_order, Employee.name_employee,
ItemsOrder.date_order, Unit.name_unit, ItemsOrder.status_order
FROM Order, Employee, ItemsOrder, Unit
WHERE
Hello Gleb,
Please read the notes about MySQL on Linux:
http://dev.mysql.com/doc/mysql/en/Linux.html
I don't find anything specific to my problem there, sorry!
My Linux installation seems to be missing something that the
bdb part of MySQL 4.1 needs and which was not needed by v4.0
and
Aha, what solution would you recommend? I would like some open and free
product working in linux and win, easy to interact with other products
and some relation among tables capabilitie (foreign index,
constraint...).
I focused on sqlite because It seem to match this requirements and it is
I am trying to construct a SELECT statement on distinct email addresses.
Our DB has emails entered by various sources and there are duplicate
addresses based on the source. Using sample table names and sources here
is what I have:
SELECT DISTINCT email_address
FROM 'email_table'
WHERE SOURCE
I prefer to explicitly declare my INNER JOINs (not to imply them by using
commas to make a list of tables). That way I avoid accidentally creating
any Cartesian products of any tables by leaving out a WHERE condition.
Missing ON conditions are much easier to spot (IMHO).
Thanks, I did have a look at it and it seems that I could use embedded
mysql with no conffiles at all. :-) I like it becouse I would prefer
application configuring mysql based on its own config or status and not
having spread conffiles for each used library. Besides, various
applications using
The complete error is:
ERROR 1064 (42000) at line 355: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near 'Purge CHAR(1),
Dehydration CHAR(1),
SomachDistentionCHAR(1),
So what are you really after:
All email addresses that are unique (not multiple-sourced)?
The email addresses from source1 that are duplicated from no other
sources?
The email addresses from source1 that are not from any of the following
sources (source2, source4, or source6)?
The email
The email addresses from source1 that are also not part of all of the
following sources (source2, source4, and source6).
What I meant was there are addresses that are duplicate and exist in
source 1, source 2, source 3, et. al. I want to only include the
distincts from all of them, in other
On Wed, 3 Nov 2004 08:31:18 -0500 (EST), Ed Curtis [EMAIL PROTECTED] wrote:
I'm trying to get a slash in a variable into my database and am having
some trouble. If the variable = 1 1/2 it echoes to the screen correctly
but it seems to strip the 1/2 off the variable when updating the value to
I'm trying to get a slash in a variable into my database and am having
some trouble. If the variable = 1 1/2 it echoes to the screen correctly
but it seems to strip the 1/2 off the variable when updating the value to
the database.
Just FYI to everyone replying:
Ed replied to me personally
- Original Message -
From: Rob Kudyba [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, November 04, 2004 12:26 PM
Subject: constructing a select and excluding duplicates
I am trying to construct a SELECT statement on distinct email addresses.
Our DB has emails entered by
You should read this page on clusters:
http://dev.mysql.com/doc/mysql/en/MySQL_Cluster_Limitations_in_4.1.html
Replication and clustering is different technology.
Replication works great, but there are no algorithms to prevent the same
row being updated on different servers at the same time (in
This query will list all of the email addresses where SOURCE='Source1' but
are not listed within any other source
SELECT et1.email_address
FROM email_table et1
LEFT JOIN email_table et2
on et2.email_address = et1.email_address
and et2.SOURCE 'Source1'
WHERE et1.SOURCE =
Rhino wrote:
- Original Message -
From: Rob Kudyba [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, November 04, 2004 12:26 PM
Subject: constructing a select and excluding duplicates
I am trying to construct a SELECT statement on distinct email addresses.
Our DB has emails
Wow even the 1st query seems to be taking a while...been like 5 minutes.
The DB has only around 80,000 records. I do have an index key which is
email_address_id so would adding that in the query help speed it up?
Thanks for the quick reply suggestion...
[EMAIL PROTECTED] wrote:
This query will
Are you linking against an old library binary?
DVP
Dathan Vance Pattishall http://www.friendster.com
-Original Message-
From: V. M. Brasseur [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 03, 2004 10:19 AM
To: MySQL Listserv
Subject: Undefined symbols compiling
Nope, You need a key on your SOURCE column to help this query respond.
ALTER TABLE email_table ADD KEY(SOURCE);
Then, try again.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Rob Kudyba [EMAIL PROTECTED] wrote on 11/04/2004 02:02:09 PM:
Wow even the 1st query seems to
Strace the thread to see what it's cycling on. Sending a HUP signal should
shut it down.
Since max is a dynamic binary ie not statically built you might have some
weird operation with your environment.
DVP
Dathan Vance Pattishall http://www.friendster.com
-Original Message-
Hi,
I've upgraded one of my servers (test) to 4.1.7 this week, all went ok.
Now I'm trying to upgrade another server (production) from 4.1.3 to
4.1.7 and I'm having serious problems. I tried 4.1.6 as well, same problem.
OS: Tao Linux (Red Hat Enterprise Linux 3.0 clone).
First, since I
What data type should I use to use True/False type when I create a table?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[snip]
What data type should I use to use True/False type when I create a
table?
[/snip]
ENUM http://www.mysql.com/enum
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
That page is ambiguous about creating a table with enum...
create table account (
ID int auto_increment,
Date date,
Check_Number int(5),
Bank_Match int enum(0,1),
Category varchar(20) no null,
Credit decimal(7,2),
Debit decimal(7,2),
Balance decimal(7,2),
primary key (ID)
);
Didn't work.
[snip]
That page is ambiguous about creating a table with enum...
[/snip]
A teeny-tiny bit more digging and you would have found it...
`Good` enum('true','false') NOT NULL default 'false'
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
- Original Message -
From: Scott Hamm [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, November 04, 2004 3:15 PM
Subject: True/False data type
What data type should I use to use True/False type when I create a table?
MySQL 4.1.x includes a column type called Boolean which would
On Thursday 04 November 2004 02:28 pm, Scott Hamm wrote:
create table account (
ID int auto_increment,
Date date,
Check_Number int(5),
Bank_Match int enum(0,1),
Category varchar(20) no null,
Credit decimal(7,2),
Debit decimal(7,2),
Balance decimal(7,2),
primary key (ID)
);
Its pretty
Personally I use a tinyint(1) unsigned.
Scott Hamm wrote:
What data type should I use to use True/False type when I create a table?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I also use tinyint(1) unsigned
and I provide a mysqlBooleanFormat() function in my application that will
return 1 or 0 for storing the value in the DB
-Original Message-
From: Michael J. Pawlowsky [mailto:[EMAIL PROTECTED]
Sent: 04 November 2004 20:44
To: [EMAIL PROTECTED]
Subject: Re:
Hello all,
Basic question about creating a database that will be accessed by many users. Do I
create one web user account with no password in the mysql.user table or add each user
to the mysql.user table as they join up to my site? (Lots of books and documentation
says how to create users,
Hello,
a server of us with dozends of databases from our customers is running
mysql 4.0.x and some users are using timestamp-columns in their tables.
If we would switch to 4.1.x immediately, there would be no time for our
customers to check their scripts relying on the older timestamp format
It's not a simple question at all.
Your users actually DON'T talk to the database, your PHP application does.
Your users converse with your PHP code. Your web server will have one
layer of authentication just to allow the user to view the pages your site
is composed of. Assume for a second
Can I perform an update on a table using load data infile..?
If I have the following table...
Name Score Rank
John NULL NULL
Susan NULL NULL
And I have a data file that has...
John,95,1
Susan,89,2
Any idea if this can be done?
Thanks,
--
MySQL General Mailing List
For list
There are differences, starting with 4.1.5, with the
user/schema administration, that need to be updated/massaged.
Perhaps that is your problem?
Maybe.
:)
Anders
+===+
|Anders Green Email: [EMAIL PROTECTED] |
|
I recently migrated a myisam database to a dual processor AMD Opteron
(see specs below) host and found that tables would sporadically lock and
not release and so all subsequent inserts would be blocked. In this
state, I was unable to nicely restart the server. It would simply give
up.
Anders Green wrote:
There are differences, starting with 4.1.5, with the
user/schema administration, that need to be updated/massaged.
Perhaps that is your problem?
I don't think so, everything works perfectly on my test server, which is
very similar.
Thanks,
Maybe.
:)
Anders
Is there a configure option to tell mysql not to put logs in /var/log?
I don't want to run mysql as root if I can avoid it, and my /var/log
directory requires root access.
I tried using --localstatedir=$HOME/mysql-state, but that didn't help.
I determined that mysql wouldn't start up correctly
hi,
having a hack with the whole imp, horde, webmail thing
have installed the mysql server and client rpms on redhat8 and just
trying to get started.
/usr/bin/mysqladmin -u root password password
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error:
Hi Dan,
There are a number of different variables that can be set. eg. log_bin
etc. These can be set on the command line as
--log_bin=file path or alternately can be set in your my.cnf file as
log_bin=file path
The complete set of variables can be found in the manual in section
5.2.3 System
In my experience, RedHat in their 'wisdom' put mysql.sock in /tmp/ yet
ships their mysql-server.rpm with a my.cnf pointing at
/var/lib/mysql/mysql.sock
Make the necessary change to /etc/my.cnf to point to /tmp/mysql.sock, or
change /etc/rc.d/init.d/mysql to point to /var/lib/mysql/mysql.sock
Is there any way of identifying each row in a table? I know in Oracble we have rowid
which remains fixed as long as the table exists. I am trying to search all the tables
in a database and then display the searched information alongwith some sort of row
identification.
Raj Batra wrote:
Is there any way of identifying each row in a table? I know in Oracble we have rowid which remains fixed as long as the table exists. I am trying to search all the tables in a database and then display the searched information alongwith some sort of row identification.
It
You could just add a column to the beginning of your table called rowid
and index it.
On Thu, 2004-11-04 at 18:07, Raj Batra wrote:
Is there any way of identifying each row in a table? I know in Oracble we have rowid
which remains fixed as long as the table exists. I am trying to search all
I keep getting this error when trying to preload a fulltext index. I've
checked the block size of the fulltext index using myisamchk (is there
an easier way to find out block size?) and it is 2048. The block size of
the primary key on the same table is 1024. Is that what it means by
Indexes use
I have a large fulltext index (the MYI file is about 750 Megs) and I've
set my key_buffer_size to 1 Gig. I do:
load index into cache fttest;
and I watch the Mysql process in memory, and it doesn't grow. It just
hangs around 250Megs. Why isn't the index loading into memory?
Thanks,
Mark.
--
Mark
It is a known problem with this feature. So far I am not aware of any
solution to it. Just want to let you know that you are not alone
having this problem.
Haitao
On Fri, 05 Nov 2004 02:16:49 +, Mark Maunder [EMAIL PROTECTED] wrote:
I keep getting this error when trying to preload a
OK, thanks. I've reported this as a bug, and another, below. I must
admit, this production release seems flakey:
http://bugs.mysql.com/bug.php?id=6447
On Fri, 2004-11-05 at 04:03, Haitao Jiang wrote:
Mark
It is a known problem with this feature. So far I am not aware of any
solution to it.
Hi all
I have just released a utility (under the GPL) that enables SQL to be
incorporated into UNIX/LINUX shell scripts (easier than using psql or
similar with better integration).
For more information see http://www.edlsystems.com/shsql
To download ftp://ftp.edlsystems.com/shsql
(needless to
Hi List,
Can any one show me the practical query of creating a table which should contain a
column with BLOB Datatype.
--Nikhil.
Why am I having a problem getting a date field to hold date? I will store
2004-10-15, save the record. Reopen the record, and there is just
-00-00
What's going on here?
Thanks
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
The answer is you create one user for the PHP (webserver) process to
use.
Then you keep track of user permissions in your application code. This
probably involves creating your own user table within your own database
and storing users of your site there. Then in the other tables you
associate
72 matches
Mail list logo
