Wednesday, 3 June 2009
|
| Change decimal to fraction Warren S. Wyght 19:19:19 |
| | 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
|
| |  13 answers | Add comment |
Wednesday, 20 May 2009
|
| ERROR 1045 (28000): Access denied for user (Using password: YES)
from outside localhost Aron Levy 11:14:54 |
| | Hi good afternoon, i am triying to connect with my company's mysql
server using a client program from shell and I keep receiving the
following answer:
[root@GWTServer ~]# mysql -u user1 -p -h serverCompany.com
Enter password:
ERROR 1045 (28000): Access denied for user 'user1'@'200.93.42.209'
(using password: YES)
[root@GWTServer ~]#
I already checked the user was configured for any host ("%"), the port
3306 is open (checked with nmap), but i dont know what i need to do or
see other variables. I am 100% sure of the passwords i am using for
this users, and i am attaching some info about the database.
Thank you in advance,
mysql> select * from user;
+-----------+--------------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| Host | User | Password | Select_priv |
Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv |
Reload_priv | Shutdown_priv |Process_priv | File_priv | Grant_priv |
References_priv | Index_priv | Alter_priv |
+-----------+--------------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| % | user1 | 5804b8eebr456240 | N | N |
N | N | N | N | N |
N | N | N | N | N
| N | N |
| % | user4 | 6f37d73jsdred201d | N | N |
N | N | N | N | N |
N | N | N | N | N
| N | N |
[root@CompanyServer ~]# nmap -A -T4 my.domain.com
Starting Nmap 4.03 ( http://www.insecure.org/nmap/ ) at 2006-06-07 09:57 VET
Interesting ports on xx.xx.xx.xx:
(The 1653 ports scanned but not shown below are in state: closed)
PORT STATE SERVICE VERSION
21/tcp open ftp ProFTPD 1.2.10
22/tcp open ssh OpenSSH 3.9p1 (protocol 1.99)
25/tcp open smtp netqmail smtpd 1.04
53/tcp open domain
80/tcp open http Apache httpd 2.0.53 ((Fedora))
106/tcp open pop3pw poppassd
110/tcp open pop3 Courier pop3d
111/tcp open rpcbind 2 (rpc #100000)
135/tcp filtered msrpc
139/tcp filtered netbios-ssn
143/tcp open imap Courier Imapd (released 2004)
443/tcp open ssl/http Apache httpd 2.0.53 ((Fedora))
445/tcp filtered microsoft-ds
465/tcp open ssl/smtp netqmail smtpd 1.04
593/tcp filtered http-rpc-epmap
993/tcp open ssl/imap Courier Imapd (released 2004)
995/tcp open ssl/pop3 Courier pop3d
1720/tcp filtered H.323/Q.931
3306/tcp open mysql MySQL 4.1.15
4444/tcp filtered krb524
8443/tcp open http Apache httpd 1.3.33 ((Unix)
mod_ssl/2.8.22 OpenSSL/0.9.7e PHP/5.0.4)
Device type: general purpose
Running: Linux 2.6.X
OS details: Linux 2.6.5 - 2.6.11
Uptime 26.627 days (since Thu May 11 18:56:31 2006)
Service Info: OS: Unix
Nmap finished: 1 IP address (1 host up) scanned in 63.549 seconds
mysql
MySQL Support
Active Persistent Links
Active Links
Client API version 4.1.15
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient
--
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
|
| | 5 answers | Add comment |
Tuesday, 28 April 2009
|
| InnoDB table recovery problem - not beeing able to start database server Ivan Tomasic 12:43:07 |
| | Hi.
Please help.
During long delete operation from one InnoDB table there was PC shutdown due to power supply failure. After that I was unable to start database server so I have started it with set-variable = innodb_force_recovery=4 option and I have dropped all databases with InnoDB tables. Still I am unable to start database server normally. Following is the part of Err file:
030630 11:58:36 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 0 3895685648
InnoDB: Doing recovery: scanned up to log sequence number 0 3895685632
InnoDB: 1 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 1777810 row operations to undo
InnoDB: Trx id counter is 0 22060800
InnoDB: Starting rollback of uncommitted transactions
InnoDB: Rolling back trx with id 0 22060495, 1777810 rows to undo
InnoDB: Progress in percents: 1InnoDB: Dump of the tablespace extent descriptor:
len 40; hex 0000000000000095ffffffff0000ffffffff000000000004aaaaaaaaaaaaaaaaaa
aaaaaafeffffff; asc .......Ľ................¬¬¬¬¬¬¬¬¬¬¬¬â–...;
InnoDB: Serious error! InnoDB is trying to free page 32306
InnoDB: though it is already marked as free in the tablespace!
InnoDB: The tablespace free space info is corrupt.
InnoDB: You may need to dump your InnoDB tables and recreate the whole
InnoDB: database!
InnoDB: If the InnoDB recovery crashes here, see section 6.1
InnoDB: of http://www.innodb.com/ibman.html about forcing recovery.
030630 11:58:37 InnoDB: Assertion failure in thread 580 in file D:\mysql-4.0.12
\innobase\fsp\fsp0fsp.c line 2689
InnoDB: We intentionally generate a memory trap.
InnoDB: Send a detailed bug report to mysql@lists.mysql.com
030630 11:58:37 mysqld-max-nt: Got signal 11. Aborting!
030630 11:58:37 Aborting
030630 11:58:37 InnoDB: Warning: shutting down a not properly started
InnoDB: or created database!
030630 11:58:37 mysqld-max-nt: Shutdown Complete
Please help
B.Sc.E.E Ivan Tomasic
--
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
|
| | 4 answer | Add comment |
Saturday, 18 April 2009
|
| Word/Excel XP(2002) cant use MyODBC 2.50.39 Joel D Peshkin 21:26:54 |
| |
Word XP(2002) and Excel XP(2002) cannot use new MyODBC datasources even
though Access XP can on the same machine.
Further, a word document with an existing MyODBC database inserted in
it, when opened in Word XP will successfully access the database.
If the field codes for the (old, working) connection are manually
modified to change the SQL syntax, that still works.
Inserting the field codes to query a database manually from Word XP fails.
The failure in word is a failure to access datasource if the field code
is manually entered, but it provides a message inidcating that it can't
get a list of tables if using the MSQuery "insert database" in Word or
Excel.
I realize this is totally inconsistent, but that't the situation.
Please advise if there are any experiments that I should try.
This is running on Windows 2000, Office XP (2002) and has been observed
on several machines.
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail myodbc-thread5751@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 myodbc-unsubscribe@lists.mysql.com instead.
|
| | 1 answer | Add comment |
Saturday, 4 April 2009
|
| Microsoft OLE DB Provider for ODBC Drivers error '80004005' Jeremy Hodges 08:05:45 |
| | Hey Guys,
I just installed MySQL 4.0 and MyODBC 3.51 on Windows XP running IIS.
But when I try to connect to my database with ASPs I get this error:
--------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/source/experimenting/mysql.asp, line 20
--------------------------
Here is my code:
<%
Set adoDataConn = Server.CreateObject("ADODB.Connection")
adoDataConn.Open "MySQLTest"
%>
Please help! |
| | 13 answers | Add comment |
Wednesday, 4 February 2009
|
| DBDesigner 4 connection problem with MySQL DB Ritu Sinha 03:34:42 |
| | Hi,
I just downloaded the latest version of DBDesigner 4
from fabFORCE.net (v4.0.5.6) and installed it on
Windows. I already have MySQL server installed and
running on my machine. When I try to connect to MySQL
DB, it asks me for the Username (root) and password. I
use the same root password that I use for the MySQL
Administrator (and it works), however, I keep getting
"dbExpress: Invalid Username/password" message. Can
someone please help??
Thanks,
Ritu
Discover Yahoo!
Find restaurants, movies, travel and more fun for the weekend. Check it out!
http://discover.yahoo.com/weekend.html
--
MySQL GUI Tools Mailing List
For list archives: http://lists.mysql.com/gui-tools
To unsubscribe: http://lists.mysql.com/gui-tools?unsub=gcdmm-mycc@m.gmane.org
|
| | 7 answers | Add comment |
Thursday, 29 January 2009
|
| Fatal error: Call to undefined function mysql_connect() in c:\Inetpub\wwwroot\mysqlconnect.php
on l Tony Aldemir 00:36:45 |
| | 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
|
| | 5 answers | Add comment |
Sunday, 25 January 2009
|
| perl with mysql problem Mark 05:13:49 |
| | Hi,
Anyone have a solution to this problem. Using following code:
#!E:\Perl\bin\perl.exe
print "Content-type: text/html\n\n";
use strict;
use DBI();
print "<HTML><HEAD><TITLE>Waitingroomsite</TITLE></HEAD>";
print "<BODY BGCOLOR=\"#ffffff\"><TABLE BORDER=0 WIDTH=\"100\">";
print "<TR><TD><FONT
FACE=\"Helvetica,Verdana,Arial\"><B></B></FONT></TD>";
print "<TD><FONT FACE=\"Helvetica,Verdana,Arial\"></FONT></TD></TR>";
print "list of mysql databases:<p>";
my $dbh =
DBI->connect("DBI:mysql:database=waitingroom;host=138.68.26.210:3306",
"administrator", "admin",
{'RaiseError' => 1});
print "<TR><TD VALIGN=top><FONT FACE=\"Helvetica,Verdana,Arial\">";
print "</FONT></TD>";
print "<TD><FONT FACE=\"Helvetica,Verdana,Arial\"></A></FONT></TD>";
print "</TR>";
print "</TABLE></BODY></HTML>";
getting error:
cgi: runCGI (stderr) BI
connect('database=waitingroom;host=138.68.26.210:3306','administrator',...)
failed: Can't create TCP/IP socket (10106) at
C:\jakarta-tomcat-4.1.24\webapps\pds\WEB-INF\cgi\example.pl line 39
I'm wondering about a number of things:
don't tcp/ip require porting code; io:socket code
Is it easier like a configuration issue . i.e. configuring my.ini.
Any help is much appreciated.
**********************************************************************
This document is strictly confidential and is intended for use by
the addressee unless otherwise indicated.
Allied Irish Banks
**********************************************************************
--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m.gmane.org
|
| | 3 answer | Add comment |
Monday, 5 January 2009
|
| Trying to install-getting DOSX.exe error? Vincent 07:27:39 |
| | I am trying to install MySQL 4.0.12-win on WinXP-Home Edition. I am using
the .zip file downloaded from www.mysql.com. I am getting the following
error when I launch setup.exe.
"The Win16 Subsystem was unable to enter Protected Mode, DOSX.EXE must be in
your AUTOEXEC.NT and present in your PATH."
I've done some searching and I do have dosx.exe in my path...and dosx.exe is
loaded in my autoexec.nt file. Any quick workarounds or fixes for this?
Has anyone gotten past it and how?
Thanks for any help.
Vincent
--
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
|
| | 2 answer | Add comment |
Saturday, 6 December 2008
|
| Performance degradation over time David French 17:45:13 |
| | I have a script written in python running on Suse linux using mySQL
3.23.32.
There are two tables each with an auto-increment key and one index.
Table 1 has a maximinum of 1,000,000 records and table 2 has a
maxminum of 20,000,000 records. The script performs a mixture of
inserts, updates, deletes and selects. it has an output line every 10
seconds saying how many records have been written since the last
sample.
I set it running @ 6.00 last friday and performance started @ 1200
transaction per second and degraded gradually to about 12 a second. I
then connected to mysql and asked for the count of both tables,
'select count(*) from table_name'. After the query, performance went
up to 700/sec degrading after an hour or so the aroung 500/sec.
Can anyone offer an explanation to this interesting result.
Dave French.
NOTICE & DISCLAIMER
This email including attachments (this "Document") is confidential and
may contain legally privileged information. If you have received this
Document in error please notify the sender immediately and delete this
Document from your system without using, copying, disclosing or
disseminating it or placing any reliance upon its contents. We cannot
accept liability for any breaches of confidence arising through use of
this Document.
The information contained in this Document is provided solely for
information purposes on an "as is" basis without warranty of any kind,
either express or implied, including without limitation any implied
warranty of satisfactory or merchantable quality, fitness for a
particular purpose or freedom from error or infringement. The user
relies on the information contained herein, and its accuracy or
otherwise, entirely at their own risk.
Any opinions expressed in this Document are those of the author and do
not necessarily reflect the opinions of Telsis. We will not accept
responsibility for any commitments made by our employees outside the
scope of our business.
---------------------------------------------------------------------
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-thread123348@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
|
| | 6 answers | Add comment |
Tuesday, 2 December 2008
|
| Can't connect error 10061 - nothing but Mascon works remotely. Daevid Vincent 19:30:01 |
| | I'm having a strange problem connecting via remote to mySQL. This is an
internal LAN, so there should be no firewall issues. I'm running RedHat
8.0, but I've installed the latest mySQL rpms which I thought were
statically linked to avoid the earlier problem of this same nature. The
peculiar thing is that "Mascon" will connect and work just fine, but NO
other programs will, and I've tried: mySQL-front, DBTools-manager,
mySQL-GUI and mySQL AB's very own "myCC" (which I thought for sure would
work). This all started b/c I'm trying to get Datanamic's DeZign to
work.
It's always error '10061', and yes, my 'mysql' databse table permissions
are all correct AFAIK. Again, "Mascon" works just fine which is the
baffling part.
[root@daevid SAMBA]# rpm -qa | grep "mysql" -i
MySQL-client-3.23.53a-1
MySQL-Max-3.23.53a-1
MySQL-python-0.9.1-4
libdbi-dbd-mysql-0.6.5-2
MySQL-bench-3.23.53a-1
MySQL-devel-3.23.53a-1
perl-DBD-MySQL-2.1017-3
qt-MySQL-3.0.5-17
mod_auth_mysql-1.11-1
MySQL-shared-3.23.53a-1
php-mysql-4.1.2-7.3.4
MySQL-3.23.53a-1
I try to telnet to the port, and it 'looks' like it works, although
there's a bunch of gibberish at the end that makes me nervous, but mebbe
it's supposed to be like that?
[root@daevid SAMBA]# telnet 192.168.1.254 3306
Trying 192.168.1.254...
Connected to 192.168.1.254.
Escape character is '^]'.
-
3.23.53a-Max2qe%)<3(,
Connection closed by foreign host.
---------------------------------------------------------------------
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-thread126728@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
|
| | 10 answers | Add comment |
Saturday, 29 November 2008
|
| Password protection Bjørn Stave 03:13:00 |
| | Hi MySQL
I am a new user of your product, and so far everything looks great, except
for password protection...
I have completed a new setup on WinXP, with Mysqld-nt as a service, and
assigned a new password to root. However I am able to connect as root
without password, alter and even drop tables and complete databases with
the tool MySQLFront !!!
If I try to connect using MySQLadmin at the command prompt without password
I am rejected as expected.
Did I miss out on something important, or is there a commonly known
backdoor to the MySQLdb
A litle extra info
Server: WinXP, MySQL ver. 3.23.49nt (commandprompt rejects acces without pw)
Client: WinXP, MySQLFRONT ver. 2.2 from MySQLfront.de (acces without pw
granted)
Purpose of use: development of a servicemanagement/CRM application as ISV
Being a bit worried to continue developing, I look forward to hering from You.
Kind regards
Bjørn D. W. Stave
Expressive.dk
---------------------------------------------------------------------
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-thread126946@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
|
| | 9 answers | Add comment |
Tuesday, 14 October 2008
|
| ASP and MySQL Andrew H. Schwarz 16:40:44 |
| | I am using ASP to access a mySQL database and have found that mySQL does
not support nested select statements. How would I go about converting
the following standard SQL statement to work in mySQL/ASP? Any help
would be GREATLY appreciated.
Thank you,
Andy
strSql = "SELECT MA VisitorCount) FROM (SELECT LogYear, LogMonth,
LogDay, COUNT(pl_ipaddress) As VisitorCount FROM (SELECT DISTINCT
YEAR(pl_datetime) AS LogYear, MONTH(pl_datetime) AS LogMonth,
DAY(pl_datetime) AS LogDay, pl_ipaddress FROM " & strInstance & "PageLog
WHERE pl_datetime BETWEEN " & FormatDatabaseDate(datReportStart & "
00:00:00") " AND " & FormatDatabaseDate(datReportEnd & " 23:59:59") & "
) DT_PageLog " "GROUP BY LogYear, LogMonth, LogDay)"
Set rsCount = objConn.Execute(strSql)
--
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
|
| | 9 answers | Add comment |
Sunday, 28 September 2008
|
| mysqldump: Error 2013 David Perron 20:21:25 |
| |
Hello - Since recently switching from MyISAM to InnoDB tables in 4.1 on RH
Linux I receive this error when attempting to dump some tables.
mysqldump: Error 2013: Lost connection to MySQL server during query when
dumping table `campaigns` at row: 14721
Any idea what could be causing this?
--
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
|
| | 14 answers | Add comment |
Tuesday, 15 July 2008
|
| Can't find file: './mysql/host.frm' (errno: 13) Pushpinder Singh Garcha 09:13:18 |
| | Hello All,
I am installing MySQL on my Mac OS Jaguar system. I was having some
trouble with the starting up my MySQL Server. I kpt getting "mysqld
ended" error and my logs showed that file "user.MYI" was corrupted. So
I decided to uninstall MySQl and re-install it.
I installed MySQL (mysql-standard-4.0.13-apple-darwin6.4-powerpc) ...
but now I get this error in the log file and I am unable to still start
the MySQL Server.
------------------------------------------------------------------------
-
030623 15:59:05 mysqld started
030623 15:59:05 InnoDB: Started
030623 15:59:05 Fatal error: Can't open privilege tables: Can't find
file: './mysql/host.frm' (errno: 13)
030623 15:59:05 Aborting
030623 15:59:05 InnoDB: Starting shutdown...
030623 15:59:07 InnoDB: Shutdown completed
030623 15:59:07 /usr/local/mysql/bin/mysqld: Shutdown Complete
------------------------------------------------------------------------
-
Thanks in advance for any help on this matter.
--Pushpinder
|
| | 3 answer | Add comment |
Saturday, 5 July 2008
|
| SQL Injection Tony Thomas 20:19:02 |
| | Hi All,
I've been hearing a bit about SQL injection lately, but the only
documentation I can find refers to Microsoft or Oracle. Anyone know of
good articles about injection in MySQL? Prevention? Detection? Is MySQL
less vulnerable?
Thanks,
Tony
--
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
|
| | 10 answers | Add comment |
Thursday, 26 June 2008
|
| RecordCount Peter Stöcker 14:57:03 |
| | Hi there!
I'm using MySQL with Delphi 5.
After running a query i get a recordcount of -1. But when I check the result there are records.
Can anybody help me?
Thanks,
peter
______________________________________________________________________________
FreeMail in der Premiumversion! Mit mehr Speicher, mehr Leistung, mehr
Erlebnis und mehr Pramie. Jetzt unter http://club.web.de/?mc=021105
---------------------------------------------------------------------
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-thread112859@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
|
| | 22 answer | Add comment |
Wednesday, 25 June 2008
|
| Unsubcribe Kmlee 11:10:58 |
| | To whom it may concern,
Please help me to unsubscribe from this mailing list. Thank you.
LEE Kwei Mean
Project Manager
OpenFeel Pte Ltd
Email: kmlee@openfeel.com
HP : (+65) 9646 1132
Tel: (+65) 6334 5716
Fax: (+65) 6334 5718
|
| | 6 answers | Add comment |
Saturday, 7 June 2008
|
| mysqlhotcopy as a replication scheme Will Lowe 17:04:04 |
| | I've got an application that uses a fairly large (~50MM rows, ~1GB of
disk) table of read-only data. The table changes maybe once a month,
but when it changes, (almost) EVERY row in the table changes.
The app needs to be replicated into several datacenters worldwide
using relatively slow backend links. For this reason and others (I
need to be able to control when each datacenter picks up updates,
etc.) native MySQL replication isn't attractive. I'm considering
building a scheme where I insert the data into a table once and ship
around a gzipped mysqldump and load it into each datacenter -- this is
easy, uses less bandwidth, is easy to control via cron and fits well
into the rest of our infrastructure.
Then I found mysqlhotcopy. Neato! I've tested, and this seems to work:
1) use mysqlhotcopy to copy the table on the "replication master"
2) gzip the table/index/data files and ship them someplace remote
3) (on the slave) unzip them
4) LOCK TABLES foo WRITE
5) FLUSH TABLE foo
6) copy the unzipped data files over the running mysql data files for
the single table I'm intersted in. There's clearly a problem here if
the machine crashes during this step, but it can be worked out to just
3 calls to rename(2), which is atomic on a POSIX fs, so that's less an
issue than it could be.
7) FLUSH TABLE foo
8) profit! It looks like table foo now contains the new data. It
takes a LOT less time than reinserting all the data into the table.
Other than "you should really use mysql native replication", does
anyone have any comments on whether this is likely to be reliable, or
why it's a bad idea? I'm using 3.23.49 (Debian stable); Is FLUSH
TABLE likely to change in future versions in a way that will break
this?
--
thanks,
Will
--
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
|
| | 2 answer | Add comment |
Wednesday, 28 May 2008
|
| SQLException with EOFException connecting to DB Arieh Bibliowicz 17:52:03 |
| | I am having problems connecting to my server provided DB.
When my programs tries to connec I get the following:
java.sql.SQLException: Communication link failure: java.io.EOFException,
underlying cause: null
** BEGIN NESTED EXCEPTION **
java.io.EOFException
STACKTRACE:
java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1319)
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:1338)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:565)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1654)
at com.mysql.jdbc.Connection.<init>(Connection.java:432)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:40
0)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.vainolo.photoviewer.DBManager.<init>(DBManager.java:33)
at com.vainolo.photoviewer.GUI.TestManager.init(TestManager.java:36)
at com.vainolo.photoviewer.GUI.TestManager.main(TestManager.java:87)
** END NESTED EXCEPTION **
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:1371)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:565)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1654)
at com.mysql.jdbc.Connection.<init>(Connection.java:432)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:40
0)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.vainolo.photoviewer.DBManager.<init>(DBManager.java:33)
at com.vainolo.photoviewer.GUI.TestManager.init(TestManager.java:36)
at com.vainolo.photoviewer.GUI.TestManager.main(TestManager.java:87)
java.lang.NullPointerException
at com.vainolo.photoviewer.GUI.TestManager.main(TestManager.java:88)
Exception in thread "main"
I am running inside a home network usign a router where most of the
incomming ports are closed. Could this be the problem?
Thanks.
Arieh.
--
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe: http://lists.mysql.com/java?unsub=gcdmj-java@m.gmane.org
|
| | 4 answer | Add comment |
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
|
| | 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.
|
| | 2 answer | Add comment |
Friday, 4 April 2008
|
| SQL Question Dawn Lockhart 17:15:36 |
| | Sorry, but I haven't used SQL in about 5 years and I don't remember
which type of join I need for this example.
Table 1 Table 2
ID ID
I need to write a query that returns all of the Table 1.ID records that
do not have a matching ID in Table 2.
Thanks!
Dawn
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/doc/ (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <java-thread4666@lists.mysql.com>
To unsubscribe, e-mail <java-unsubscribe-gcdmj-java=m.gmane.org@lists.mysql.com>
|
| | 106 answers | Add comment |
Monday, 24 March 2008
|
| Update Multiple Records Rich 17:28:55 |
| | Hi folks.
I want to set the status of 5 records to 'completed'. how do I go about
that without having to prepare 5 different instructions?
"update myTable set status = 'completed' where id=10 OR id=20 OR id=30
OR id=40 OR id=50"
I'm trying to reduce the number of instructions.
Cheers
--
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
|
| | 8 answers | Add comment |
|
