Thursday, 8 May 2008
|
| problem with mysqld Paizulaev Abdula 10:09:06 |
| | 040401 06:21:02 mysqld started
040401 6:21:03 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 10 4036416
InnoDB: Doing recovery: scanned up to log sequence number 10 4036416
040401 6:21:03 InnoDB: Flushing modified pages from the buffer pool...
040401 6:21:03 InnoDB: Started
/usr/local/mysql/libexec/mysqld: ready for connections
040401 6:21:04 InnoDB: Assertion failure in thread 7176 in file
../include/page0page.ic line 482
InnoDB: We intentionally generate a memory trap.
key_buffer_size=8388600
record_buffer=131072
sort_buffer=2097144
max_used_connections=0
max_connections=100
threads_connected=0
It is possible that mysqld could use up to
key_buffer_size + (record_buffer + sort_buffer)*max_connections = 225791 K
bytes of memory
Hope that's ok, if not, decrease some variables in the equation
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Cannot determine thread, fp=0x685406c8, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x80c9d62
0x40027f75
0x8244028
0x81a44b9
0x8174c79
0x8171c4c
0x81721a8
0x8172b9a
0x81739d7
0x8173cfb
0x815a30e
0x81c673f
0x813dbed
0x40024fef
0x420e779a
New value of fp=(nil) failed sanity check, terminating stack trace!
Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow
instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains
information that should help you find out what is causing the crash
Number of processes running now: 0
040401 06:21:04 mysqld restarted
040401 6:21:04 Can't start server: Bind on TCP/IP port: Address already in
use
040401 6:21:04 Do you already have another mysqld server running on port:
3306 ?
040401 6:21:04 Aborting
040401 6:21:04 /usr/local/mysql/libexec/mysqld: Shutdown Complete
what I can do for returning DB to online?
thank you.
---
Paizulaev Abdulla,
Electrosvyaz close corp.,
Makhachkala, Daghestan,
abdul@ellco.ru, icq 342000,
+78722608210, +79034984708
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| Options |  4 answer | Add comment |
Monday, 5 May 2008
|
| toner cartridges Guest 19:45:33 |
| | VERTEX LASER AND
COPIER SUPPLIES
TAKE ADVANTAGE OF THE SAVINGS WHILE THEY LAST!!!
WE ARE REDUCING OUR INVENTORY FOR
THE SUMMER OF 2002 ON OUR LASER
PRINTER AND COPIER SUPPLIES
ORDER BY PHONE: 1-888-288-9043
ORDER BY FAX: 1-888-977-1577
***EMAIL REMOVAL LINE: 1-888-248-4930***
ORDER BY PAGE NUMBER AND/OR ITEM NUMBER
For Hewlett Packard Printers: (Page 2)
ITEM
DESCRIPTION
MFG #
PRICE
Item #1
Laserjet Series 4L, 4P
92274A
$44
Item #2
Laserjet Series 1100,3200
C4092
$44
Item #3
Laserjet Series 2
92295A
$49
Item # 4
Laserjet Series 2P
92275A
$54
Item #5
Laserjet Series 5P,6P, 5MP, 6MP
3603A
$44
Item #6
Laserjet Series 5SI,8000
3909A
$95
Item #7
Laserjet Series 2100, 2200
C4096
$74
Item #8
Laserjet Series 8100
C4182
$115
Item #9
Laserjet Series 5L/6L
3906A
$39
Item #10
Laserjet Series 4V
C3900
$95
Item #11
Laserjet Series 4000
C4127X
$79
Item #12
Laserjet Series 3SI/4SI
92291A
$54
Item #13
Laserjet Series 4,4M,5,5M
92298A
$49
Item #13A
Laserjet Series 5000
C4129X
$125
Item #13B
Laserjet Series 1200, 3300 series
C7115A
$59
Item #13C
Laserjet Series 4100
C8061X
$99
Item #18
Laserjet Series 3100
3906A
$39
Item #19
Laserjet Series 4500 Black
C4191
$69
Item #20
Laserjet Series 4500 Color
CALL
$89
For Hewlett
Packand Cannon Fax (on Page 2 )
ITEM
DESCRIPTION
MFG #
PRICE
Item # 14
Leserfax 500, 700
FX1
$59
Item # 15
Laserfax 5000, 7000
FX2
$64
Item # 16
Laserfax 6000
FX3
$59
Item #17
Laserfax 8500, 9000
FX4
$54
Item #18
Laserfax 3200
3906A
$44
For Lexmark / IBM Machines: (on Page 3)
ITEM
DESCRIPTION
MFG #
PRICE
Item #1
IBM 4019/4029
1380200
$95
Item #2
Optra R,4039, 4049
1382150
$117
Item #3
Optra E310, E312
12A2202
$89
Item #4
Optra E
69G8256
$59
Item #5
Optra S
1382625
$135
Item #6
Optra T
12A5840
$165
Item #7
Optra E410/412
4K00198
$115
For Apple Printers: (on Page 8)
ITEM
DESCRIPTION
MFG#
PRICE
Item #1
Personal LaserWriter
M0089LLA
$54
Item #2
LaserWriter 300PX/ 320-4L,+4ML
M2045GA
$54
Item #3
LaserWriter Select 360
M1960GA
$74
Item #4
LaserWriter 16/ 600 Pro
M2473GA
$59
Item #5
LaserWriter 12/ 640 PS
M4683GA
$89
Item #6
Laser Writer NT/2NT
M4532GA
$49
For Cannon Copiers: (Page 10)
ITEM
DESCRIPTION
MFG #
PRICE
Item # 1
PC 6/ 6RE/ 7/ 8/ 11/ 12/ 65
A30
$69
Item # 2
PC 300/320/340/360 All 300 Series
E40
$89
Item #3
PC 700/720/760 All 700 Series
E40
$89
Item #4
PC 900/910/920 All 900 Series
E40
$89
For Epson and Panasonic Printers on Pages 4 & 7)
ITEM
DESCRIPTION
MFG #
PRICE
Item # 1
Epson 1000/1500
S051011
$105
Item #2
Epson EPL7000/8000
S051200
$105
Item #3
Panasonic 90/95
---------------->
$105
Sorry, Still no Inkjets, bubble jets or Xerox in stock
DISCLAIMERS:
All trademarks, brand names and diagrams listed or shown above
are property of their respective holders and used for descriptive
purposes only
.We do not carry any HP OEM Products.
NOTES:
University and School Purchase orders welcome. (No Credit approval
required. All other Purchase
orders require credit approval
Pay by check (C.O.D.), Credit card or purchase order (Net 30 Days)
Shipping charges start at $4.5 per cartridge. Add $1.5 for each
additional cartridge. Cartridges
delivered by Federal Express within 2 to 5 working days depending on
your location.
Shipping and billing addresses are required for Purchase Order
transactions. Your invoice will
be attached to your packaging. Please peal and pay within 30 days.
30 day standard return policy (money back guarantee) on all
merchandise. 90 day unlimited exchange policy
for defective merchandise.
EXCLUSIONS:
We do not carry:
- Xerox, Brother, Panasonic, or Fujitsu Products
- Deskjet/Inkjet or Bubblejet products
-Any Offbrands besides the ones listed above. All cartridges
are compatible high yield products.
|
| Options | 2 answer | Add comment |
Tuesday, 22 April 2008
|
| Change decimal to fraction Warren S. Wyght 21:39:58 |
| | I would like to know how to change a decimal to a fraction for printout
purposes only.
I.E.
34.0625 = = 34 1/16
The number or float in the DB would still be the same but when it is
sent to the front end I would like it to be sent as a fraction to the
nearest 1/16th. Is there a method in MySql to do this?
Thanks
Warren
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
|
| Options | 10 answers | Add comment |
Sunday, 17 February 2008
|
| Plz provide some information Gopal Goyal 13:54:04 |
| | ----------------------------------------- (on mail.momentuminfocare.com)
email-body was scanned and no virus found
---------------------------------------------------------
Dear Sir/madam
In my project I m using XML,XSL as front end and MySQL as back end and
jdeveloper3.2.3. I am facing a problem in connectivity. I got the code
from some one. Whn I run the code, in
Class.forName("twz1.jdbc.mysql.jdbcMysqlDriver");, it gives the
following error---
ClassNotFoundException:
twz1.jdbc.mysql.jdbcMysqlDriver
==> SQLException:
Message: No suitable driver
SQLState: 08001
ErrorCode: 0
Pls help me out
gops
|
| Options | 1 answer | Add comment |
Tuesday, 5 February 2008
|
| Specified driver could not be loaded due to system error 5 (MySQL
ODBC 3.51 Driver) Damien Bargiacchi 01:49:51 |
| | I have installed and setup the mySQL server on my windows 2003 server. I am
trying to connect to the database from a C# app running on the same server
in IIS. I have been able to connect through the mySQL binary as well as by
clicking the test connection using the "Test Data Source" button in an ODBC
DSN on the mySQL server and on a remote computer.
When I try to connect to the database from the C# app I get the following
error message:
Specified driver could not be loaded due to system error 5 (MySQL ODBC 3.51
Driver).
I have tried to uninstall and reinstall the ODBC driver to no avail. I have
noticed that the installer places it's dlls etc into the current user's
Documents and Settings\WINDOWS\... Folder so I have moved the files it puts
into there to the real system32 directory to avoid the 126 error.
Any help would be greatly appreciated.
---------------------
Damien Bargiacchi
Vancouver, Canada
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org
|
| Options | 1 answer | Add comment |
Wednesday, 14 November 2007
|
| SELECT /*!40001 SQL_NO_CACHE */ * FROM `ROUTEDATA` message Connie A. Logg 15:05:06 |
| | I am running mysql version 5.0.24 and am seeing this error when running mysqldump.
From what I can find on the web, this message is generated by an error in the mysql code.
Please correct me if I am wrong.
Is this fixed in mysql 5.0.27 ?
Thanks,
Connie Logg, Network Analyst
Stanford Linear Accelerator Center
ph: 650-926-2879
"Happiness is found along the way, not at the end of the road, and 'IF' is the middle word in life."
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| Options | 2 answer | Add comment |
Monday, 24 September 2007
|
| Crystal Reports 9 & ODBC Fred Dinkler 15:40:38 |
| | I defined an ODBC connection in Win2K Pro using 3.51 driver. Works fine in
Excel, Access and Word.
However, when defining a database connection within Crystal Report (v 9) it
can't find any tables. Thinks the db is empty.
Browsed this list's archives and didn't turn up anything.
Any ideas?
Fred Dinkler
Los Angeles
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org
|
| Options | 1 answer | Add comment |
Friday, 24 August 2007
|
| http://virt.voicemessage.com/index.listen.php2=35affv - The webpage you requested - A service of Pag Guest 03:35:06 |
| | A service of PageGetter.com, Inc.
*PageGetter.com Home: http://www.PageGetter.com
*Other Services: http://www.PageGetter.com/services.htm
*Advertise with Us: http://www.PageGetter.com/advertise.htm
*Terms of Use: http://www.PageGetter.com/terms.htm
*Privacy Policy: http://www.PageGetter.com/privacy.htm
*Help: http://www.PageGetter.com/help.htm
This page is brought to you by American Express - Get Blue, the first
Card designed for the 21st Century, with a 0% Introductory APR, no
annual fee, a built-in Smart Chip for Internet security, plus
CoolBlueOffers, BlueLoot (sm) and more. Get approved instantly at
http://by.advertising.com/1/c/33488/14783//41369
________________________________________________
VIRUS ALERT - Monday, June 14, 2004
Our website has been referenced in, without our consent or knowledge, as
part of a virus! Please understand that we had no part in this virus,
and that we are being victimized as much as you are! Voicemessage.com is
in no way involved in the perpetration of this criminal activity.
The virus is called W32.Erkez.B@mm and is also known as W32/Zafi.b@MM.
This is a worm virus that sends e-mails to all the e-mail addresses it
finds on an infected computer and then attempts to overwrite program
files associated with security. You can read more about the virus and
find out how to repair damage at
http://securityresponse.symantec.com/avcenter/venc/data/w32.erkez.b@mm.h
tml
and
http://www.trendmicro.com/vinfo/virusencyclo/default5.asp?VName=PE_ZAFI.
B&VSect=T
<http://www.trendmicro.com/vinfo/virusencyclo/default5.asp?VName=PE_ZAFI
.B&VSect=T>
The virus sends many different types of e-mails, and one of them
references our website, voicemessage.com. Unsuspecting recipients may
open these e-mails, and when they click the link in the e-mail they
unknowingly infect their computer with the virus. Here is the e-mail
that references our website:
To: Jennifer
Subject: You`ve got 1 VoiceMessage!
Attachment: "link.voicemessage.com.listen.index.php1Ab2c.pif"
Message:
Dear Customer!
You`ve got 1 VoiceMessage from voicemessage.com website!
Sender:
You can listen your Virtual VoiceMessage at the following link:
http://virt.voicemessage.com/index.listen.php2=35affv
or by clicking the attached link.
Send VoiceMessage! Try our new virtual VoiceMessage Empire!
Best regards: SNAF.Team (R).
Visit Our Home Page <http://www.voicemessage.com/index.html>
________________________________________________
Please support your PageGetter.com sponsors! - American Express -
http://by.advertising.com/1/c/33488/14783//41369
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
|
| Options | 1 answer | Add comment |
Wednesday, 18 July 2007
|
| UNICODE Dienw 16:39:48 |
| |
Hi all,
I apologize if this is a frequent topic.
It just I don't find any answer in the archives regarding this,
and maybe my unicode knowledge is rather limited.
I'd like to know, how can I query the database containing
UNICODE character? My application will use wide char. I'm confused
with the interfacing to the mySQL through mysql++.
Currently for single-byte char, I was mostly using << operator to
set up a query.
With wide char, what should I do, just do it like that? Or should I
convert it into MBCS? And then when read I translated it back?
Or maybe there are some other things I should do?
Thanks in advance for any answers.
-Dien.
--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsub=gcdmc-plusplus@m.gmane.org
|
| Options | 4 answer | Add comment |
Monday, 9 July 2007
|
| Security log fills up with ServicesActive failure audits Samuel 17:45:46 |
| | My Windows XP Security Events log is filling up with failure audit events,
but there is very little information about them. Based on when this began
happening, it might be caused by the MySQL service. If this problem has not
been encountered before by MySQL users, then it seems unlikely it is caused
by the MySQL, but the following is the information in case someone has any
information related to this problem being by caused by MySQL.
I get the log events whether MySQL has started or not. Within a few minutes,
the log is full. The failures are for the user I normally use, which does
not have Administrator privileges. I assume that the problem is that a
service is not installed properly. I have looked at the MySQL service and it
seems okay; it is run by the "Local System account" (the default). The
following is relevant information from a log event record.
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Description:
Object Server: SC Manager
Object Type: SC_MANAGER OBJECT
Object Name: ServicesActive
Operation ID: {0,611286}
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
|
| Options | 3 answer | Add comment |
Monday, 25 June 2007
|
| ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) Daqi Li 18:46:52 |
| | Hi,
After I installed the mysql3.23.54 on a NT4.0
(service pack6) workstation to C:\mysql directory,
when I tried to run mysql.exe, I got
"ERROR 2003: Can't connect to MySQL server on
'localhost' (10061)".
Then I created the C:\my.cnf file, which is a copy of
c:\mysql\my-medium.dnf and I added the following two
lines to its [mysqld] section:
basedir=C:\mysql
datadir=C:\mysql\data
But I still get same error. Any kind of ideas would be
greatly appreciated.
Thanks in advance,
Martin.
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail win32-thread10305@lists.mysql.com
To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail win32-unsubscribe@lists.mysql.com instead.
|
| Options | 9 answers | Add comment |
Wednesday, 20 June 2007
|
MySQL Extremely Slow Starting Up  ONEinc 23:34:31 |
| | Hello Everybody,
I am using a Windows 2003 Web Edition Server running IIS and MySQL 4.1. I had to restart the server the other day and it took MySQL over an hour to come back up. I was watching it on my task manager and it went up to approximately 50,000k in 10k increments before I was able to access MySQL. My CPU usage was hovering around 3% all this time. Everything else came up on the server just fine. This happens every time I have to restart my server. The reason I have to restart my server most of the time, is because MySQL locks up on me.
Is there any settings I can change that would help me here? Any help would be greatly appreciated.
One more thing to add. I am using the default my.ini file. We have almost 100 different databases on the server and have around 20000 tables within all of these databases combined. The Memory Usage is at 857MB in use at this time.
Thank you in Advance,
ONEinc |
| Options | 1 answer | Add comment |
Tuesday, 19 June 2007
|
| Back to Basics Guest 01:43:15 |
| | I reloaded mysql on a reformatted partitioned c drive on a pc running
Windows 98 and receive error messages when trying to load data as I had
done many times over the past year. I also get an error message when
trying to establish a new database. I have created a table in database
test and the commands SHOW TABLES and DESCRIBE TABLENAME work, but
loaddata results in error:
ERROR 1045 Access denied for user: '@localhost' (Using password: NO)
Could someone describe precisely what I must do to gain access again and
to operate with a password (I didn't use one with the last installation)?
Numbered steps would help. Thanks.
Ken
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
|
| Options | 4 answer | Add comment |
Wednesday, 13 June 2007
|
| MyODBC Windows unattend Rul_rec 12:46:32 |
| | im doing an installer and i dont like the user to click next, next on myodbc install screens, im working with MyODBC-3.51.11-2-win.exe
which parameters can i send it to make it automatic?
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org
|
| Options | 4 answer | Add comment |
Wednesday, 6 June 2007
|
| Data source name not found and no default driver specified David Mills 04:47:55 |
| | Hello
I have a problem with using my ASP pages with MySQL data in my Browser
on my computer as a testing server.
Before sending you this query I have read set up instructions, I have
sent my ISP who provides me with MySql for my domain where the pages
work, queries on why I can not use my computer to test pages, and they
can not see any reason that my ASP pages do not run. I have been to
several forums on MySQL but do not find a solution
I can access MySQL and the database when constructing the pages using
Dreamweaver., but if I try to view the pages on my computer I get the
following error message
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified
I have MySql 4 and ODBC 3.51 installed
I am at a loss as to where to go to find the reason or solution
Your assistance would be greatly appreciated
Regards
David Mills
|
| Options | 6 answers | Add comment |
Wednesday, 23 May 2007
|
| installing RPM RedHat 8.0 Sam 16:22:22 |
| |
I am getting the following message when submitting the following:
how-to-repeat:
[root@localhost sam]# rpm -ivh /mnt/cdrom/MySQL-4.0.6-.0.i386.rpm
error:/mnt/cdrom/MySQl-4.0.6-.0.i386.rpm: MD5 digest : BAD
expected(ba03cefd50c27d9d993ce693457c072d) !=
(ad8cba3b72f6ae195b93f9b1db8a481c)
error:/mnt/cdrom/MySQl-4.0.6-.0.i386.rpm cannot be installed
I have tried several .rpm from different North America sites
sam
---------------------------------------------------------------------
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 <mysql-thread128441@lists.mysql.com>
To unsubscribe, e-mail <mysql-unsubscribe-gcdmg-mysql=m.gmane.org@lists.mysql.com>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
|
| Options | 3 answer | Add comment |
Saturday, 19 May 2007
|
| Fatal error: Call to undefined function mysql_connect() in c:\Inetpub\wwwroot\mysqlconnect.php
on l Tony Aldemir 14:55:47 |
| | Hello There,
I am getting the "Fatal error: Call to undefined function mysql_connect()
in c:\Inetpub\wwwroot\mysqlconnect.php on line 2" error when I try to
connect to the MySQL DB using:
<?php
$conn = mysql_connect("localhost", "joeuser", "somepass");
echo $conn;
?>
I have made sure that my PHP.INI file is adjusted to reflect the following:
Uncommented the line "extension=php_mysql.dll" exposing this DLL to PHP.
I added the following line
extension_dir = "c:\php\ext"
I copied the libmySQL.dll to the c:\inetpub\wwwroot folder (I am using the
IIS on this machine, but I have the same configuration using the latest
APACHE Server on my home machine and when It try the same code on that
machine, I get no response showing me the value of the $conn, but I do not
get any error message either). Confusing situation!
I do have the php_mysql.dll in the C:\php\ext folder
Well, none of this seem to matter. I am still getting the error listed
above using IIS .
Here is my setup:
I have MySQL 4.1.13a-nt installed. I am able to run MySQL Admin to add
users, add tables to the TEST DB, add records to the new table via the
command line as well as via the MySQL Query Browser. So I am pretty sure
that my MySQL is installed and working fine.)
I have the MySQL program installed on the default location "C:\Program
Files\MySQL\MySQL Server 4.1" as oppose to changing it to c:\MySQL folder
during the installation. I am hoping that this is not the reason for this
problem, but I am not sure.
I am able to run other non-MySQL related simple PHP code via my browser
just fine.
(Example:
<html>
<?php echo '<p>Hello World</p>'; ?>
and a few other simlar stuff. That all works fine.
But when I use the
<?php
$conn = mysql_connect("localhost", "joeuser", "somepass");
echo $conn;
?>
code it just does not want to work. I get the "Fatal error: Call to
undefined function mysql_connect() in c:\Inetpub\wwwroot\mysqlconnect.php
on line 2" error.
Any help would be greatly appreciated.
Regards,
Tony Aldemir
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
|
| Options | 2 answer | Add comment |
Thursday, 3 May 2007
|
| help help help Alex Davis 19:26:23 |
| | Ok... everytime I try to use MyODBC or SQLyog to log into the server i
get the error "Lost connection to MySQL during query" or "Access denied
to root@cae234-998-172.sc.rr.com. (PASSWORD = YES)"
What do I need to do? Any suggestions?
Thanx,
-Alex
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/products/myodbc/manual_toc.html (the manual)
http://lists.mysql.com/ (the list archive)
To unsubscribe, e-mail <myodbc-unsubscribe@lists.mysql.com>
To unsubscribe from Yahoo! Groups version, e-mail myodbc-unsubscribe@yahoogroups.com
|
| Options | 2 answer | Add comment |
Thursday, 26 April 2007
|
| Data mining Pavel 20:02:40 |
| | Hello,
Does anybody use MySQL for dataminig such as clustering or decision
trees? Is there anything that can be integrated with the database or do
you use some other software?
Thank you
With regards,
Pavel Kusch
---------------------------------------------------------------------
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 <mysql-thread133854@lists.mysql.com>
To unsubscribe, e-mail <mysql-unsubscribe-gcdmg-mysql=m.gmane.org@lists.mysql.com>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
|
| Options | 1 answer | Add comment |
Tuesday, 24 April 2007
|
| Strange duplicate key problem Ismael Touama 01:31:56 |
| | Hello all,
I 'm front of a strange trouble.
My table (connexe) is 2 fields varchar(20).
These 2 fields are composing a Primary Key.
(ref_art and ref_cnx)
When I'm doing this query:
INSERT INTO article_connexe (Ref_art, Ref_cnx)
VALUES (Ref_art = 'w1', Ref_cnx = 'w2')
It's inserting me 0-0 !!!
I don't understand where the errors occur.
Someone can help ?
Thank you,
ism
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail win32-thread9958@lists.mysql.com
To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail win32-unsubscribe@lists.mysql.com instead.
|
| Options | 4 answer | Add comment |
Saturday, 10 March 2007
|
| MS Access and mySQL Jonathan Coleman 23:10:57 |
| | Hi.
I have a situation where a church I am doing some volunteer work for
has a MS Access (office 97) database running on NT. They are (woohoo)
upgrading to a QUBE (linux box) for a server which has mySQL installed
(and I can upgrade it etc..)
My job therefore is to
a) port MS Access data and queries to mySQL database
b) use the MS Access forms to access the data and queries through ODBC.
Is there anyone who can point me in the right direction, either to
where the searchable discussion archives are, OR even better, someone
who has gone through this before?
Cheers
Jon
http://digital.yahoo.com.au - Yahoo! Digital How To
- Get the best out of your PC!
---------------------------------------------------------------------
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 <mysql-thread118159@lists.mysql.com>
To unsubscribe, e-mail <mysql-unsubscribe-gcdmg-mysql=m.gmane.org@lists.mysql.com>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
|
| Options | 20 answers | Add comment |
Friday, 23 February 2007
|
| Daylight Savings Time James Kelty 01:48:22 |
| | Hello,
We had a strange instance happen here with one of our MySQL servers.
We have multiple MySQL installations, and one of the MySQL servers had a
problem with daylight savings time.
Basically, when we ran a select now(); MySQL reported time that was two
hours ahead of the actual time. The system /bin/date command was correct
however.
We restarted the MySQL server and the time was corrected. I have looked
at 'most' of our other servers, and none of them (so far) has had this
issue.
I am just wondering if anyone else has seen this problem?
-James
|
| Options | 21 answer | Add comment |
Saturday, 27 January 2007
|
| Big Table, myisampack or merge? Altendew 18:30:35 |
| |
Hi lets say I want to record transactions on my site. This transaction table
becomes over 1GB in six months. Which makes it very hard to read. The
reading and deleting process becomes very slow.
Would it be wise to make a new transaction table every month?
Then recreate the merge table?
How long would a process like that take because my members are creating
transactions every second, so wouldnt all their queries be locked up while
it was creating it?
Or would using myisampack be better to just compress all the data. I display
about 50 rows of their transaction history based on the User ID index. So
decompressing 30 rows is that a big deal?
--
View this message in context: http://www.nabble.com/Big-Table%2C-myisampack-or-merge--tf3128016.html#a8666880
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| Options | Add comment |
|
| BETA RELEASE: v2.2.0.beta1 Warren Young 18:00:49 |
| | It's been a long time coming, but here it is. Changes so far relative
to v2.1.1:
o ColData, const_string, and SQLString can now be constructed
with an explicit length parameter. Furthermore, Query
class's execute(), store() and use() call chains terminate
in a version taking an explicit length parameter, instead
of one taking a simple C string. Together, this means
that it's now possible to handle data from the SQL server
containing nulls. The library is almost certainly not yet
capable of handling embedded nulls in all cases, but this
is a big first step towards that.
o Can now construct a DateTime object from a time_t. Patch by
Korolyov Ilya.
o Changed the way we're handling exported functions in the
Windows DLL case so that it works more reliably under MinGW.
o Added proper copy semantics to Connection, so that you get a
new connection with the same parameters, not just a bitwise
copy of the object.
o Added exrun shell script and exrun.bat files to distribution,
to avoid linkage errors when running the examples while
you have an older version of MySQL++ still installed.
o Using an explicitly thread-safe variant of localtime() where
one is available.
o Removed ListInsert template from myset.h. This wasn't used
within the library, and was never documented, so I'm betting
that no one actually uses it.
o Result::copy() was not copying the exception flag in
all cases. Fix by Steven Van Ingelgem.
o Renamed MYSQLPP_LIB_VERSION to MYSQLPP_HEADER_VERSION, as
what it really encodes is the version number in the mysql++.h
file you're using, not the actual library version number.
o Added mysqlpp::get_library_version(), which returns the
library version number at build time. Between this and
the header version constant, you can check that you're not
mixing MySQL++ header and library versions.
o resetdb example uses these new version number affordances to
double-check that you're not mixing libraries and headers
from different versions. This happens easily unless you
take care of it (such as by using exrun) when you have one
version of MySQL++ installed and you're trying to build and
test a new version without blowing away the old one first
or overwriting it.
o No longer using recursive Makefiles on Unixy platforms
or split lib + examples project files on VC++. Everything is
handled by a single top-level Makefile or project file, which
is simpler for the end user, and makes better dependency
management possible.
o When looking for the MySQL C library on systems using
autoconf, looking in .../lib64 wherever we are also looking
in .../lib.
o RPM build process no longer depends on Bakefile. It means
you have to build the examples when building an RPM even
though they're never used within the RPM, but it's a better
tradeoff in my opinion.
o Updated include and library paths on Windows to reflect
changes in the most recent MySQL installers.
o Merged lib/defs.h and lib/platform.h into new file,
lib/common.h. Just cleans up the library internals.
o Fixed build errors on Windows due to recent changes in MySQL.
o Fixed a few memory leaks and double-deletes in Query class.
o Fixed compatibility with STLPort's string implementation.
Patch by dengxy at cse.buaa.edu.cn.
o Fixed a compatibility problem between Set<> template and
SSQLS. Patch by Korolyov Ilya.
o Fixed build bug in SQLQueryParms due to a character
signedness issue on PowerPC with GCC. Patch by Michael
Hanselmann.
o ~Transaction() can no longer throw exceptions. It'll just
quietly eat them, to avoid program termination. Fix
suggested by Alex Burton.
o Fixed thread safety testing in autoconf case, accidentally
broken during v2.1.0 development cycle.
o Using Doxygen 1.5.1 to generate documentation.
You can download the latest beta from http://tangentsoft.net/mysql++/ in
many forms, or you can check out the absolute brandest newest from svn.
I hope to get this release finalized within a week, so if you have
problems with it, please let me know soon.
--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsub=gcdmc-plusplus@m.gmane.org
|
| Options | 4 answer | Add comment |
|
| Performance problem Peter Zuidema 14:49:48 |
| | Please help,
We have big performance problems.
This is the situation:
We haven an Windows NT server with a P355 processor and 256MB Ram. We have
installed version 3.49 of mysql
(we have also tried version 3.52).
When we do a select on a table which contains about 10.000 records, we have
for about 10 seconds a cpu of 100%.
We use MyISAM tables and have checked indexes and we have checked if tables
need to be repaired.
Is there someone who can give advise to get a better performance of mysql?
Met vriendelijke groeten,
IBT Groep BV,
Peter Zuidema
---------------------------------------------------------------------
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 <mysql-thread123131@lists.mysql.com>
To unsubscribe, e-mail <mysql-unsubscribe-gcdmg-mysql=m.gmane.org@lists.mysql.com>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
|
| Options | 41 answer | Add comment |
|
