--
hello please i have been having problem downlaoding
mysql on vista, when i do download it wouldnt let me set up the config wizard
properly keeps giving me an error message when i do and i have tried switching
off the UAC button and still no good. the column you are prompted to put your
pas
I could be wrong.. but this is a guess..
event_type: 15 is update_rows_event which is used in mysql 5.1 and
later..
if mysqlbinlogs is an older version.. most likely it will produce an
error
because it does not recognize event_type 15 and is bombing out.
try it.
http://dev.mysql.com/doc
n MySQL 3.23, the largest possible packet is 16MB, due to limits in the
client/server protocol. In MySQL 4.0.1 and up, the limit is 1GB."
Any help would be greatly appreciated.
Thanks!
Henry
t;
/otm/reports/datadump/mediaowner_bin_data.txt
Am I not wrapping the "where" portion of the command correctly (though I
have tried every possible wrapping with single-quotes that I could come
up with) OR are sub-queries simply not supported OR is there something
else that I should know
#x27;s own row, but I must use the
table as it is.)
Any help would be most appreciated.
Thanks!
Henry
--
Pierre-Henry Perret
change the seed on the random function.
http://dev.mysql.com/doc/mysql/en/mathematical-functions.html
On Mon, 2005-10-03 at 08:33 -0700, Graham Anderson wrote:
> is there a way to make ORDER BY RAND() at bit more spontaneous ?
>
> I am using it in a php statement:
> $sql = "SELECT media.id,
>
grand total sum and average?? Any help would be greatly
appreciated!!!
Thanks in Advance.
Henry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
more
> than 1MB, and depending on how oyu do the import can mean no mor ethan 1MB
> total data in a single batch.
--
Henry Wong <[EMAIL PROTECTED]>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
First, I tried searching the mysql list archives, but the archive search
function on mysql.com does not seem to be working.
Second, I'm using the PHP fsockopen() function on port 3306 to test if a
database is up and responsive. If the socket opens, I'm assuming the database
is up, and I
I like to share with you all, an interesting article about eBay's
deployment of database arrays.
http://www.eweek.com/article2/0,1759,1640234,00.asp
Specifically on page 2, Marty Abbott (eBay's VP of Technology) states
that eBay has four equal data centers. So in this array scheme, a
write in
If I want to update these day fields in this table:
day, date, month, year
-1 August 2004
-1 August 2004
I want on to be Sunday Lunchtime the other to be Sunday Evening. What
query do I use that won't update both fields with the same data?
--
MySQL General Mailing List
For list ar
er=1;
>slave start;
>
>Good luck.
>
>John A. McCaskey
>
>-Original Message-
>From: Henry Chang [mailto:[EMAIL PROTECTED]
>Sent: Monday, June 14, 2004 3:34 PM
>To: [EMAIL PROTECTED]
>Subject: How to Fix Broken Replication
>
>
>
>I have MySQL replic
I have MySQL replication setup between Master A and Slave B.
Everything was working fine, until one day replication was broken.
Status on the slave shows the following error message:
Last_error: Error 'Can't drop database X. Database doesn't exist'
on query 'DROP DATABASE X.
I suspect a
I got MySQL replication working in master-slave configuration. It's
really cool, but how often does the master send binlog dump to the
slave. The implication is if the master crashes, what would be the
potential data gap in the slave??
--
MySQL General Mailing List
For list archives: http://
Thanks for the reply!! IndeedI am using version 3.23.58. I can
stop pounding my head against the wall now. Thanks again!!
*** REPLY SEPARATOR ***
On 2/19/2004 at 2:10 AM Jeremy March wrote:
>http://www.mysql.com/doc/en/UPDATE.html
>
>I believe multi-table updates weren
I am truly frustrated with what should be a simple update. Any help to
enlighten this newbie is appreciated.
[TABLE A] tdmr_dmr
dmr_customer_code
dmr_job_number_code
[TABLE B] tjl_job_list
jl_customer_code
jl_jobnumber
In Table A, the dmr_customer_code fie
I really need some help/direction, so I'll try to explain this as best I can.
I have a PHP script that involves three very long running queries (2-3 minutes
each). The users of my website kick this off from their webpage, so it runs as
"nobody" from inside Apache. In order to prevent a user f
Hello,
I have a query that will be used alot on my website that involves a 42
million record table being self-joined. The primary table instance will be
limited by an index resulting in 1 to about 50,000 rows being selected, then
joined to the second instance of the table, which will retrieve
Very simple question:
Can I use myisamchk version 2.6 (from mysql 4.0.15) to fix/repair a table from
mysql version 3.23.41 (which includes myisamchk version 1.49)??
The reason is that I have more disk space and processing power on a machine
with 4.0.15 installed, but I'd like to rebuild some tab
pls unsubscribe me from this maillist. thanks.
- Original Message -
From: "Andy Eastham" <[EMAIL PROTECTED]>
To: "Mysql List" <[EMAIL PROTECTED]>
Sent: Monday, September 15, 2003 8:54 PM
Subject: {Scanned} RE: random record
> 39?
>
> > -Original Message-
> > From: tuncay bas [ma
Environment:
I'm setting up a database server on a Dell Poweredge 2650, dual 1.8GHZ pentium
with 1GB of memory and RAID5 drives. I've installed RedHat 9, and updated the
kernel to 2.4.20-19.9smp. I've installed the RPM binary distribution of MySQL
4.0.14 right from the MySQL website. The only thi
Thanks for your attention to this problem!
The files are just about 1GB zipped. I'm on a cable modem, so it would take
quite a while to upload these files, but I would be happy to upload them if
helps solve the problem.
Here are the results you requested:
mysql> SELECT COUNT(*) FROM temp_bill_
Here is the resolved stack trace when the FULLTEXT query crahses my server:
0x807474f handle_segfault + 423
0x82a0ad8 pthread_sighandler + 184
0x82ca717 memcpy + 39
0x82891c3 tree_insert + 483
0x827b037 walk_and_match + 231
0x8289956 tree_walk_left_root_right + 78
0x828992c tree_walk_left_root_ri
Oops.. here's the correct command I used to start mysql:
/usr/bin/mysqld_safe --core-file --core-file-size=100 &
It was not started with "--core-file=" as mentioned in my previous note. Sorry.
-Hank
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use w
Sergei wrote:
>How big is your table?
The MYD file is 2,406,292,556 bytes.
The MYI file is 1,381,827,584 bytes.
There are 21,402,554 records in the database.
This table is static (no writers) and ONLY used for fulltext searching on the
"notes" field.
Here is the structure:
+---+-
Try this
http://www.cpp-home.com/tutorial.php?22_1
Hope it helps
"dave" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi, is mysql compatible with c++ in linux? I cant seem to get it
> working any sample c++ script would do. thanks in advance.
>
> dave
>
>
> --
> MySQL Gener
I have 2 tables with the following fields :
table : publisher
field1: pub_id - Primary, int, auto
table : titles
field1: title_id - Primary, int, auto
field1: pub_id - int
Using sqlyog I noticed that the indexes had already been created for the
Primary keys but according to my tutorial I also h
| Extra
|
+---+--+---+--+-+--+-+-+
| tbe1 | ALL | NULL | NULL |NULL | NULL | 8190652 | Using
temporary |
+---+--+---+--+-+--+-+-+
--- Justin Spies <[EMAIL PROTECTED]> wrote:
> Henry,
> The inf
I have the following SQL. The source table has 8.1 million rows, and the
resulting table will have about 7.9 million rows. I know that's not much of a
decrease, but the logic is correct as I've tested it on smaller sets. The
problem is that when I run with the full set of 8 million rows, it take
as they are given to us by the OS and assign permissions
to tables using these users. Does that seem reasonable?
Thank you!
Henry.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 9:09 PM
To: Matt Solnit; Heikki Tuuri; [EMAIL PROTECTED]
Cc
really don't want to do that, I just want them to use mysql from a remote
machine or through PHP.
Henry Umansky
University of Pittsburgh
Systems/Programmer III
www.pitt.edu/~hmust2
[EMAIL PROTECTED]
(412)624-4357
-
Before po
Hello,
While looking at SHOW TABLE STATUS, I noticed that all my dynamic tables seem
to have a Max_data_length of 4,294,967,295 bytes. Is this true - that any
dynamic tables are limited to 4GB in size? My fixed tables do not show this
problem, and report that their Max_data_length is 4+ bill
>[EMAIL PROTECTED] wrote:
>Henry, can you repeat it with binaries from MySQL site?
Unfortunately, no. This database server runs a very high traffic website, so I
can't easily (nor do I want to) start changing the mysql version and causing
alot of (or any) downtime. Except for this
Hello All,
I have mysql 3.23.41 running on a Dell Poweredge 2550 on standard install of
Red Hat 7.2 (2.4.9-21smp). This version of mysql came with Red Hat. It's been
running my website very smoothly for the last few months, and averages 130
queries per second.
Mysql has crashed twice in t
Dear Monty,
At the beginning, I missed doing the step of setting default
character-set.
After I have done what you said about setting default character set,
the correct chinese characters are stored in mysql database.
Thank you very much!
Best regards,
Henry.
>From: Mich
response.write "DataField=" & oRs("DataField") & ""
oRs.movenext
loop
%>
4. run the ASP program to see the special result.
My contact email address is [EMAIL PR
Hello All,
I recently moved my database from mysql 3.22.29 to 3.23.41, and udated all my
tables to MyISAM tables. Under ISAM, I could take the filesize of the ISD
table and divide by the record length to get the exact number of records
returned by "select count(*)" from that table (or vise-ve
in mysql docs, http://www.mysql.com/doc/L/o/Log_file_maintenance.html :
1) shell> cd mysql-data-directory
2) shell> mv mysql.log mysql.old
3) shell> mysqladmin flush-logs
What's happening if there is a query between line 2 and 3, is it logged ?
How could I rotate my files without a query not log
and 'localhost'. The perl script
works fine from my shell acount (through a socket) and works up till the
connect statement in the browser. How can I 'identify' the browser or change
the script to accomodate
This is my first crack at mysql. I am already connecting easily to parallel
mysql databases on Windows98 and on my ISP's server. I have linked to both
from Access97 via ODBC and I can connect to both from command lines. I
have also installed perl DBI and DBD::mysql at home. The ISP did not yet
h
data from
> table TBL_FLAT to TBL_INDX.
>
> INSERT INTO TBL_INDX SELECT * FROM TBL_FLAT;
>
> This will be valid in mysql. The insert will be fast since
> only one insert statement. Let the list know if this works
> for you. Or if your method is valid as well.
>
> David
Hello all,
I'm in the process of building a new mysql db server box to migrate a
database off an existing web server. The webserver is running mysql 3.22.29,
and the new box is running 3.23. The two biggest tables are about 20 million
records and the data and index files are each just over 1
I found the problem. My production server is running mysql 3.22.29, and I
needed to use a SET SQL_BIG_TABLES=1 in many places to prevent a "full temp
table" condition. The new server is running 3.23, and once I removed the
SQL_BIG_TABLES=1 from the script (and allowed mysql to use memory instea
Hello Again - I'm posting this again, since it still is an issue that I can
not resolve - please help!
I've recently installed mySQL on a RH7.2 box without any problems - it runs
great. I've been testing some long running queries (full table scans, etc)
under different scenarios, and get wil
Hello All,
I've recently installed mySQL on a RH7.2 box without any problems - it runs
great. I've been testing some long running queries (full table scans, etc)
under different scenarios, and get wildy differing results. Between each test
case, I was flushing all tables and re-starting the
s for advices.
Stéphane HENRY
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To uns
>> Get some more info at: http://www.mysql.com/doc/I/n/Insert_speed.html
That suggests using LOAD DATA INFILE, but I would really like to avoid dumping
a very large ISAM mysql table to a text file, just to load it back into another
table (MYISAM).
I was looking for answers as to why isamchk w
Hello,
Under mysql 3.22.29, I was able to use isamchk to disable all index keys (-r
-k0), do millions of inserts into the table, then re-enable all the indexes
again with "isamchk -r -k4" (4 indexes). I'm testing out a new Redhat 7.2
Linux server with mysql 3.23.41, and am attempting to load
Hello,
I am trying to decide which OS to use for a dedicated mysql server for my
website. I need filesize >2GB support. I really wanted to use Solaris, but
there are no drivers for my RAID adapter (long story). I was considering
NetBSD, but I don't know it well. I was then back to thinking
learn how to manage
databases. Please let me know if you want to host your database for
practice and/or learning. My email is [EMAIL PROTECTED] I'm sure most
people on this list already has a means of hosting their database, but this
is a just in case email.
Thank
learn how to manage
databases. Please let me know if you want to host your database for
practice and/or learning. My email is [EMAIL PROTECTED] I'm sure most
people on this list already has a means of hosting their database, but this
is a just in case email.
Thank
Hello all,
I just ordered a new server to act as a database-only server for my website
(wheresgeorge.com). I'm currently running mysql 3.22.29 (I'm stuck there due
to my web hosting provider). I plan to upgrade to the latest stable version
of mysql, but have the following questions about the
I have installed and configured MySQL server on my local win 98 machine
How may I export the locally created DB to my remote ISP/MySQL? Any third
party tool?
My site is set on Linux/Apache my local machine is Win 98
Thank you
Henry
Hello,
I am new to mysql. I install windows version MySQL. I want to initial mysql with
command mysqld, I get an error message as "can't initialize innoDB as
'innodb_data_file_path' is not set". Could you please help me how to solve this
problem?
Thanks
Henry
I'm trying to install mysql onto a uniz environment.
I've already unzipped and untarred, and I've created
the mysql - version directory, but when I type
configure, I get a grant table failed error. I cant
find anything on how to fix this.
Hello All,
I'm recently back in the job market, and looking for PHP/MySQL contracting
opportunities. Can some helpful people out there please email with good job
sites and/or real headhunters that specialize in this type of work? I've
already exhausted dice.com, guru.com, monster.com, headhun
57 matches
Mail list logo
