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 |
|