Greetings,
I am running MySQL (version 4.0.15 max) database on Linux (RH9) box.
This linux box is a dedicated database server with following h/w
configuration:
CPU: 2 * 2.4 Ghz Xeon Processor, 512 K 533 FSB
Ram :6GB
Hdd:36GB * 5 raid config
Typically, this database
[EMAIL PROTECTED] wrote:
Hi All,
Mysqldump -h host name -u username -p password --databases database
name dump.dmp
My doubts are as follows.
1. How to take the backup and restore from the client machine using
ODBC?
mysqldump is a command line utility for making backups. You will have to
- Original Message -
From: Harald Fuchs [EMAIL PROTECTED]
In article [EMAIL PROTECTED],
Jigal van Hemert [EMAIL PROTECTED] writes:
SELECT t1.`msg_id`
FROM `msg_content` AS t1
JOIN `msg_addressee` AS t2 ON t1.`msg_id` = t2.`msg_id` AND
FIND_IN_SET( t2.`status` , 'deleted'
Michael,
Thank you for your reply. Here is a bit more info. I changed the default
table type to innodn in the my.ini file before creating the database, so all
tables are innodb. I tried the create statements with and without explicit
index clauses with all permutations - same result each
In your my.cnf there is no:
Query_cache_size -
http://dev.mysql.com/doc/mysql/en/Query_Cache_Configuration.html
Thread_cache_size -
http://dev.mysql.com/doc/mysql/en/Server_system_variables.html
Marc.
-Message d'origine-
De : ManojSW [mailto:[EMAIL PROTECTED]
Envoyé : lundi 6
Hi!
Running version 4.0 we created a fairly big innodb table (10GB, 72.950.601
rows).
After upgrading to 4.1.7 we switched to multiple tablespaces. Then somebody
ALTERed the table and innodb created a new idb file for the table. So right
now we have 3 large files (old ibdata1|2 and the new
Hi all!
I recently updated my system to FC3, i installed MySQL Administrator
from the mysql.com binaries, but they keep crashing every time. This is
the error message:
[EMAIL PROTECTED] ~]$ /opt/mysql-administrator/bin/mysql-
administrator
*** glibc detected *** free(): invalid pointer:
Heikki I do it, in my.cnf on [mysqld] section I add:
tmpdir=/tmp
then I try:
/usr/bin/mysqld_safe --tmpdir=/tmp --datadir=/var/lib/mysql --user=mysql
with the same result
If I change TMPDIR enviroment variable to /tmp works fine.
I forgot to say I install mysql from rpm.
Alejandro
On Fri, 3
Try something like this
SELECT A1.ID,
SUM(IF(ISNULL(C.AdID),0,1)) AS Clicks,
SUM(IF(ISNULL(V.AdID),0,1)) AS Views
FROM Ads A1
LEFT JOIN Clicks C
ON A1.ID = C.AdID
LEFT JOIN Views V
ON A1.ID = V.AdID
GROUP BY A1.ID
-Original Message-
Dear Steve!
You must set the column address_id as primary key in the table
person_address. That should solve your problem.
Generally table, you want to join with foreign key, should have primary key.
The primary key should include the column that you use for the
Hello.
What version of MySQL Administrator and operating system do you use? I haven't
found any open bugs similar to yours. Are you sure that your database contains
data?
Steve Grosz [EMAIL PROTECTED] wrote:
I am using the MySql Administrator tool to schedule weekly backups on my
Hello.
--replicate-rewrite-db is not taken into account while executing LOAD DATA
FROM MASTER. See:
http://dev.mysql.com/doc/mysql/en/LOAD_DATA_FROM_MASTER.html
Sanjeev Sagar [EMAIL PROTECTED] wrote:
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
Hello.
Looks strange. Have you upgraded from 3.xx to 4.xx? If so, then may be you
forgot to run mysql_fix_privilege_tables script. Your mysql client
shows 4.0.21 version, but check the exact version:
select version();
Send us your my.cnf file, output of show variables. Can you
Hello.
I've submitted a bug http://bugs.mysql.com/7036.
Robin Bryce [EMAIL PROTECTED] wrote:
Hi,
I'm having trouble converting to and from strings that represent
unsigned BIGINT's.
My server is MySQL 4.1.7-standard and
the following selects were entered at the prompt
Time ago I submit a post about temp tables and rights privileges and
it's in my head still.
There is an user privilege to create temporary table
(create_tmp_table_priv) but when the owner of the table need drop
this table can't do (if have drop priv can, but it's a bomb time).
Someone have an idea
Hi!
Is TRUNCATE optimized for innodb tables in MySQL 4.1.7?
http://dev.mysql.com/doc/mysql/en/TRUNCATE.html says:
For InnoDB, TRUNCATE TABLE is mapped to DELETE, so there is no difference..
But http://dev.mysql.com/doc/mysql/en/InnoDB_tuning.html claims:
Beware also of other big disk-bound
Ron,
What's happening is that, when there are clicks and views for an ad, you are
getting the number of clicks TIMES the number of views.
A quick and dirty solution is to put a column, say id, in clicks which is
different for each click, and similarly for views. Then, you can change
your counts
Hello!
I have what seems to be a trivial question, but have not been able to
find a definite answer and your help would be greatly appreciated.
Question:
When creating InnoDB table spaces, are there any advantages to using
multi table spaces for each table or is it better to create a few
If you are using 4.1 or later, you could do a subquery to count the
clicks,
then left join that with the views.
I am using 4.1. I tried to do a sub-query, but never got it run. Can
you give me a quick example? Is the sub-query a better (faster) way to
do this?
Ron
On Dec 6, 2004, at 6:19
This is on windows 2000.
I did the following as a temp solution for the full back up of a database. I
know this is not safe and possibly
not complete. Any suggestions (how to lock/unlock a db for read here)?
Thanks
#include stdio.h
#include stdlib.h
int main() {
printf(start backup ESite
Hello Gleb,
My question was related to LOAD DATA INFILE, not LOAD DATA FROM MASTER.
LOAD DATA INFILE work those slaves which are not using
--replicate-rewrite-db. It do not work for those which are using this.
Thanks for you reply.
-Original Message-
From: Gleb Paharenko
Dear list,
So I'm having a bit of trouble with my first schema. I'm sure I'm
missing something idiotic here, but days of learning MySQL and setting
up servers and working in UNIX have kind of fried my brain. Okay, here
goes:
My project management system includes (among others) two tables:
I'm currently using the following query:
SELECT SUM(IF(`01`=1, 1,0)) AS 01A, SUM(IF(`01`=2, 2, 0)) AS 01B...,
SUM(IF(`55`=1, 1,0)) AS 55A, SUM(IF(`55`=2, 1,0)) AS 55B FROM tableA
INNER JOIN tableB ON tableA_ID = tableB_ID INNER JOIN tableCON
tableB_aID = tableC_aID INNER JOIN tableD ON
Can someone help, please?
We set up a server to handle a coldfusion web application (CFMX 6.1)
running against MySQL 4.1.3b-beta on WinNT.
When it is a little stretched, we are finding many instances of queries
listed as either 'Sending...' or 'Copying...' in the processlist, with
the time
Hello All,
I'm having trouble upgrading 3.23. to 4.1. Since I don't want to break
production, I'm trying to start a test instance on the machine. The problem
I'm having seems to be a missing .frm file. The following details
invocation and the log file. Any help would be greatly appreciated.
Hello All,
I am having problem in finding out the exact position in master bin log
file in replication setup for point-in-time recovery process. Let me
explain the problem in detail.
I have log_position table on all slaves, see the definition below
Table: log_position
Create
Try:
select id, clicks, count(views.adId) as views
from (select ads.id, count(clicks.adId) as clicks
from ads inner join clicks on ads.id=clicks.adId
group by id) as adsclicks
left join views on id=views.adid
group by id;
Explanation:
-- the following gives you a count of
Gleb Paharenko wrote:
Hello.
I've taken this information from documentation at
http://dev.mysql.com/doc/mysql/en/myisamchk_syntax.html
Did it solve your problem? If didn't, send me you my.cnf file and information
about version of MySQL and operating system.
The docs are old, they changed
- Original Message -
From: Chris Kavanagh [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, December 06, 2004 12:11 PM
Subject: A newbie and his first MySQL schema
Dear list,
So I'm having a bit of trouble with my first schema. I'm sure I'm
missing something idiotic here, but
-Original Message-
From: Terry Riley [mailto:[EMAIL PROTECTED]
Sent: Monday, December 06, 2004 10:12 AM
To: [EMAIL PROTECTED]
Subject: Locking Issue?
Can someone help, please?
We set up a server to handle a coldfusion web application (CFMX 6.1)
running against MySQL 4.1.3b-beta on
Depends on your disk setup. Remember a table space is a virtual
filesystem that sits on top of the OS. Having one large file and
chopping a contiguous block of the disk out enables better seeks as well
as caching if the file doesn't bust the system cache. In your case it
will. One file needs to be
Um its better to use the SQL backup table if the table is a myISAM
table.
BACKUP TABLE [tables] to [LOC].
Or a more sophisticated approach
FLUSH TABLE WITH READ LOCK;
Fork out copy myISAM datafile out
UNLOCK TABLES;
If it's innodb then use the innodb backup script offered by Heikki.
Don't think of it a column must hold mutiple values (unless your using
Sets or bitmasks) think that this table will hold mutiple rows, and each
person is a row with permissions for each project. So, a basic approach
is forevery authorized project a person is able to see that person has a
row
- Original Message -
Thanks for those hints, Dathan (see below):
-Original Message-
From: Terry Riley [mailto:[EMAIL PROTECTED]
Sent: Monday, December 06, 2004 10:12 AM
To: [EMAIL PROTECTED]
Subject: Locking Issue?
Can someone help, please?
We set up a server to
Hi all.
I'm using the MySQL C API to interface with my MySQL 4.1 server and I
have the following questions:
When I do a SELECT of some integer data value what is actually returned
is a string representation of the integer value and since I need this
integer value in my client I have to convert
Hi All,
I understand that I can get a random row out of a table by doing something
like
SELECT * FROM fortunes ORDER BY RAND() LIMIT 1
But I have also been told that this is a very slow operation.
I am building a script that will display a random saying, user testimonial,
whatever, on a web
Prepared Statements, only offered in 4.1 API's.
http://dev.mysql.com/doc/mysql/en/C_API_Prepared_statements.html
David W. Juntgen
Medical Informatics Engineering Inc.
Phone: 260.459.6270
Fax : 260.459.6271
-Original Message-
From: Mads Kristensen [mailto:[EMAIL PROTECTED]
Sent:
[snip]
I understand that I can get a random row out of a table by doing
something
like
SELECT * FROM fortunes ORDER BY RAND() LIMIT 1
But I have also been told that this is a very slow operation.
I am building a script that will display a random saying, user
testimonial,
whatever, on a web
Hey check the MySQL C API By Example site.
http://www.geocities.com/jahan.geo
Yes you have to convert the data always and its zero terminated.
Mads Kristensen wrote:
Hi all.
I'm using the MySQL C API to interface with my MySQL 4.1 server and I
have the following questions:
When I do a SELECT of
How many rows do you anticipate that the table will have? Have you
tested this on your server? I would have to bet that if you
have only a few K rows that speed/performance will not be an issue.
I doubt I will have more than 100. Perhaps I shouldn't worry about it,
then.
The way to
[snip]
The way to
enhance this is by selecting an indexed value, such as the following
where `foo` is indexed
SELECT `foo` FROM fortunes ORDER BY RAND() LIMIT 1
Why does this help? From the MySQL book I have, the reason ORDER BY
RAND() is slow is because for each record in the table a
I beginning to use MySQL clustering abilities for a large records
keeping solution.
I have installed 4.1.7 with the clustering components. The ndbd and
ndb_mgmd processes are running. I can create the database and tables
using the ndb engine.
I have started to import our data. I gather from
Hey.
The code that I'm trying to get to work is as follows. The problem is
with the 7th, 8th, and 9th lines...
html
head
titleTest MySQL/title
body
!-- mysql_up.php --
?php
$host=;
$user=;
$password= ;
mysql_connect($host,$user,$password);
$sql=show status;
$result = mysql_query($sql);
if
I need to convert database values into php variables.
Let me explain:
i.e.
select firstbase, secondbase, thirdbase, home from
allstars where firstbase = 122;
Now I want to use all those field names as variables
with the same record information they would have if
you just ran the above
Hello!
I need to pull records from the db where the timestamp column (2004-11-01
00:00:00) greater than November 1, 2004
WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) = a.createdate doesn't work
DATE_SUB(CURDATE(),INTERVAL 30 DAY) = a.createdate doesn't work
a.createdate '2004-11-01 00:00:00'
Klaus Berkling [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I have started to import our data. I gather from the manual that tables
are stored in RAM. I am trying to import a database with 11 tables with
about 7 million rows. If I follow the math in the manual, one row will
Probably a real old question, but where
can I go to look up a numbered error,
as in
ERROR 1005 at line 333502: Can't create table
'./warehouse/tblGTprojConfigs.frm' (errno: 150)
thanks
titus sends
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Yes, mysql clustering is a ram only database. It does not make sense to
use it if you have a very large database.
You can use master/slave functionality and use whatever table type you
like. But using the newer clustering technology you have no choice but
to use the ndb table type which is ram
-Original Message-
From: John McCaskey [mailto:[EMAIL PROTECTED]
Sent: Monday, December 06, 2004 17:01
To: Joshua Beall
Cc: [EMAIL PROTECTED]
Subject: Re: Clustering and a large database
Yes, mysql clustering is a ram only database. It does not
make sense to use it if you
[snip]
I need to convert database values into php variables.
Let me explain:
i.e.
select firstbase, secondbase, thirdbase, home from
allstars where firstbase = 122;
Now I want to use all those field names as variables
with the same record information they would have if
you just ran the above
--- Jay Blanchard
[EMAIL PROTECTED] wrote:
My suggestion is that you work some basic PHP/MySQL
tutorials and use
the PHP general list ([EMAIL PROTECTED]) for
questions like
this. Make sure you have RTFM, STFA, and STFW before
posting, those guys
can be merciless.
Jay, thank you and I
On Dec 6, 2004, at 1:53 PM, Joshua Beall wrote:
Klaus Berkling [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I have started to import our data. I gather from the manual that
tables
are stored in RAM. I am trying to import a database with 11 tables
with
about 7 million rows. If I
- Original Message -
From: Titus [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, December 06, 2004 4:53 PM
Subject: Error documentation
Probably a real old question, but where
can I go to look up a numbered error,
as in
ERROR 1005 at line 333502: Can't create table
Ah, Excelent. Thanks for looking at this. The use context that exposed
this was using uuids as primary keys. I was breaking the result of
uuid() into two parts, and then storing into a pair of bigint unsigned
fields that formed a composite primary key:
CREATE TABLE `test`.`uuidkeys` (
Pseudo code:
$min = SELECT MIN(id) from fortunes;
$max = SELECT MAX(id) from fortunes;
While (!$row $count 3) {
$id = rand $max + $min;
if ($id $max) {
next;
}
$row = SELECT * from fortunes where id = $id;
$count++
}
If ($count = 3) {
return 1st row;
}
Aaron,
You aren't trapping errors on mysql_connect().
Try this:
mysql_connect($host,$user,$password)
or die(mysql_error());
-Eric
On Mon, 6 Dec 2004 19:13:49 +0100, Aaron Ford [EMAIL PROTECTED] wrote:
Hey.
The code that I'm trying to get to work is as follows. The problem is
with
I'm trying to utilize the debug switch with mysqlimport so that I can figure
out why I'm getting errors on the data I'm importing, but I have yet to
figure out a way to do this. I've tried to read the sparse documentation
concerning this feature and no debug file is ever produced. I've tried
If you are running Linux, try.
]$ perror errno
errno being the number of the error.
David W. Juntgen
Medical Informatics Engineering Inc.
Phone: 260.459.6270
Fax : 260.459.6271
-Original Message-
From: Rhino [mailto:[EMAIL PROTECTED]
Sent: Monday, December 06, 2004 5:17 PM
To:
Steve,
- Original Message -
From: [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, December 06, 2004 1:00 PM
Subject: Re: Foreign Key Error 1005:150
--NextPart_Webmail_9m3u9jl4l_14802_1102330771_0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
Michael,
Thank
Alejandro,
please search the bugs.mysql.com database about known --tmpdir bugs.
If TMPDIR works, it is a fine workaround.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
does anyone know what type of encryption is used in the PASSWORD(str)
function? When would you use the MD5 vs the PASSWORD function?
We have a campus standard to use the MD5 encryption so I need to confirm
if the PASSWORD function will offer that or not.
Thanks,
Lauren
--
MySQL General
Paul,
- Original Message -
From: Paul Mallach [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, December 06, 2004 4:26 PM
Subject: innodb: TRUNCATE vs. DELETE FROM
Hi!
Is TRUNCATE optimized for innodb tables in MySQL 4.1.7?
Terry,
- Original Message -
From: Terry Riley [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, December 06, 2004 8:15 PM
Subject: Locking Issue?
Can someone help, please?
We set up a server to handle a coldfusion web application (CFMX 6.1)
running against MySQL
Paul,
- Original Message -
From: Paul Mallach [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, December 06, 2004 1:59 PM
Subject: inodb: large old ibdata1 and multiple tablespaces
Hi!
Running version 4.0 we created a fairly big innodb table (10GB, 72.950.601
rows).
When I am logged on to a particular mysql server, is it possible to
- Access table residing on a different mysqlserver? or
- To join tables between two databases residing on two different
mysql servers (on two different H/W boxes or same H/W box).
Any Ideas
I looked in the manual. It
On Mon, Dec 06, 2004 at 04:21:38PM -0600, [EMAIL PROTECTED] wrote:
does anyone know what type of encryption is used in the PASSWORD(str)
function? When would you use the MD5 vs the PASSWORD function?
We have a campus standard to use the MD5 encryption so I need to confirm
if the PASSWORD
Hi,
On Monday, December 6, 2004, at 04:15 PM, Klaus Berkling wrote:
I beginning to use MySQL clustering abilities for a large records
keeping solution.
I have installed 4.1.7 with the clustering components. The ndbd and
ndb_mgmd processes are running. I can create the database and tables
Hello,
I try to set up replication and woulkd like to export my master with
mysqldump. The import fails with ERROR 1005 (HY000) (errno 150)when trying
to import the dump on the slave. The create-state which causes the error
is:
CREATE TABLE fond4client (
id int(11) NOT NULL auto_increment,
Background: I have a web site that is running MySQL 3.23.58 (although
phpinfo shows Client API version: 4.0.20) and PHP 4.3.9 on a FreeBSD 4.7
system. The only live site on the server is
http://www.routerbitworld.com/ which is using osCommerce.
Problem: Until today, the site was speedy.
Never mind, it was a query optimization issue. Upon the third
interogation of the other admin, he remembered one small setting that he
changed, which just so happened to increase the number of queries
exponentially.
Thanks,
Jonathan Duncan
On Mon, 6 Dec 2004, Jonathan Duncan wrote:
hi,
I wish to have clusters of MySQL. i installed it from RPM. version, 4.1.7.
but, i cant get the ndbd command to start my NDB.
do i really need to install from tarball??
i am really new to MySQL clustering. all this while, i am using MySQL
standalone database.
pls guide me... i am willing to
Howdy all,
We're having concurrency problems with a table in our
database and I'm not sure if I'm interpreting the
following chunk of output from SHOW INNODB STATUS
correctly.
From what I gather, the row could not be inserted
because the table was locked. I think that this insert
was a victim
I just read the post 'MySQL 4.1 and Unicode produces crap' on Dec. 6 by Yves
Goergen.
I guess we are having the same issue.
I notice that 4.1.0 if I do SHOW VARIABLES LIKE char%', there is only one
setting, however, in 4.1.7 there are different characterset.
I did tried to change all variables to
Hello,
I am a software developer,
I am using Mysql-4.1.3b-beta-nt,
ODBC3.5.1 driver on windows PC for an
application development.
the application which i am developing is a
client-server architecture based,in which we have to
store data of the BSM(Base Station Manager of CDMA
network).
the
hello all,
i had installed mysql-4.1.7 and php-4.3.5 and while
testing the php. it shows error as:
mysql_connect(): Access denied for user
'alaguraj'@'localhost' (using password: YES) in
/home/alaguraj/public_html/my.php on line 3
Could not connect: Access denied for user
'alaguraj'@'localhost'
Am Mon, 06 Dec 2004 21:16:02 -0800 schrieb alagu raj:
hello all,
i had installed mysql-4.1.7 and php-4.3.5 and while
testing the php. it shows error as:
mysql_connect(): Access denied for user
'alaguraj'@'localhost' (using password: YES)
What are the privileges for user alaguraj? If You
76 matches
Mail list logo