What is talxy?
MySQL database development
Hello Guest
  
  • Login
• Register…
• Start blog
  • Who, Where, When
• What can I do?
• What to Read?
  • Polls
• Avatars
• Interests
  • Cities and Countries
• Random blog
• Users search
  • Search
• Games
• Tests
• QAIX
  • Talxy Chat
• Horoscope
• Online
 
Зарегистрируйся!

QAIX > MySQL database developmentGo to page: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | next »

  Recent blog posts: 
  They have birthday today: 
  Forums:   
  Discuss: 
  Recent forum topics: 
  Recent forum comments:
  Moderators:
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/li­bexec/mysqld: ready for connections
040401 6:21:04 InnoDB: Assertion failure in thread 7176 in file
../include/page0pag­e.ic line 482
InnoDB: We intentionally generate a memory trap.

key_buffer_size=838­8600
record_buffer=13107­2
sort_buffer=2097144­
max_used_connection­s=0
max_connections=100­
threads_connected=0­

It is possible that mysqld could use up to
key_buffer_size + (record_buffer + sort_buffer)*max_co­nnections = 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.co­m/doc/U/s/Using_stac­k_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.co­m/doc/C/r/Crashing.h­tml 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/li­bexec/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=gcdm­g-mysql@m.gmane.org


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

Optionscomment 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=gcdm­w-win32@m.gmane.org


Optionscomment 10 answers | Add comment
Sunday, 17 February 2008
Plz provide some information Gopal Goyal 13:54:04
 --------------------­--------------------­- (on mail.momentuminfoca­re.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.jdbcMysq­lDriver");, it gives the
following error---

ClassNotFoundExcept­ion:
twz1.jdbc.mysql.jdb­cMysqlDriver
==> SQLException:
Message: No suitable driver
SQLState: 08001
ErrorCode: 0

Pls help me out

gops
Optionscomment 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=gcd­mo-myodbc@m.gmane.or­g


Optionscomment 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=gcdm­g-mysql@m.gmane.org


Optionscomment 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=gcd­mo-myodbc@m.gmane.or­g


Optionscomment 1 answer | Add comment
Friday, 24 August 2007
http://virt.voicemes­sage.com/index.liste­n.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.PageGett­er.com
*Other Services: http://www.PageGett­er.com/services.htm
*Advertise with Us: http://www.PageGett­er.com/advertise.htm­
*Terms of Use: http://www.PageGett­er.com/terms.htm
*Privacy Policy: http://www.PageGett­er.com/privacy.htm
*Help: http://www.PageGett­er.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.advertisi­ng.com/1/c/33488/147­83//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://securityresp­onse.symantec.com/av­center/venc/data/w32­.erkez.b@mm.h
tml
and
http://www.trendmic­ro.com/vinfo/virusen­cyclo/default5.asp?V­Name=PE_ZAFI.
B&VSect=T
<http://www.trendmi­cro.com/vinfo/viruse­ncyclo/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.php­1Ab2c.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.voiceme­ssage.com/index.list­en.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.voiceme­ssage.com/index.html­>

___________________­____________________­_________

Please support your PageGetter.com sponsors! - American Express -
http://by.advertisi­ng.com/1/c/33488/147­83//41369




--
MySQL Windows Mailing List
For list archives: http://lists.mysql.­com/win32
To unsubscribe: http://lists.mysql.­com/win32?unsub=gcdm­w-win32@m.gmane.org


Optionscomment 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=g­cdmc-plusplus@m.gman­e.org


Optionscomment 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=gcdm­w-win32@m.gmane.org


Optionscomment 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\da­ta
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.yah­oo.com

-------------------­--------------------­--------------------­----------
Please check "http://www.mysql.c­om/Manual_chapter/ma­nual_toc.html" before
posting. To request this thread, e-mail win32-thread10305@l­ists.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@l­ists.mysql.com instead.


Optionscomment 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
Optionscomment 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=gcdm­w-win32@m.gmane.org


Optionscomment 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-wi­n.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=gcd­mo-myodbc@m.gmane.or­g


Optionscomment 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
Optionscomment 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/My­SQl-4.0.6-.0.i386.rp­m: MD5 digest : BAD
expected(ba03cefd50­c27d9d993ce693457c07­2d) !=
(ad8cba3b72f6ae195b­93f9b1db8a481c)
error:/mnt/cdrom/My­SQl-4.0.6-.0.i386.rp­m cannot be installed

I have tried several .rpm from different North America sites
sam


-------------------­--------------------­--------------------­----------
Before posting, please check:
http://www.mysql.co­m/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


Optionscomment 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("loca­lhost", "joeuser", "somepass");
echo $conn;
?>

I have made sure that my PHP.INI file is adjusted to reflect the following:

Uncommented the line "extension=php_mysq­l.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("loca­lhost", "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=gcdm­w-win32@m.gmane.org


Optionscomment 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.co­m/products/myodbc/ma­nual_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


Optionscomment 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.co­m/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


Optionscomment 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.c­om/Manual_chapter/ma­nual_toc.html" before
posting. To request this thread, e-mail win32-thread9958@li­sts.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@l­ists.mysql.com instead.


Optionscomment 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.yaho­o.com.au - Yahoo! Digital How To
- Get the best out of your PC!

-------------------­--------------------­--------------------­----------
Before posting, please check:
http://www.mysql.co­m/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


Optionscomment 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

Optionscomment 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.c­om/Big-Table%2C-myis­ampack-or-merge--tf3­128016.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=gcdm­g-mysql@m.gmane.org


OptionsAdd 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_VERS­ION, 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_librar­y_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=g­cdmc-plusplus@m.gman­e.org


Optionscomment 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.co­m/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


Optionscomment 41 answer | Add comment

Add new topic:

How:  Register )
 
Login:   Password:   
Комментировать могут: Премодерация:
Topic:
  
 
Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.


QAIX > MySQL database developmentGo to page: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | next »

see also:
This is why PHP sucks
Import data from textfile
session issues for unauthorized access?
see also:
How can a module find a resource in its…
counting charactors
PHP/MySQL with Microsoft Word
see also:
Looping problem?
allow_url_fopen detection....
Verifying a url

  Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
You can find the help and FAQ in the Admin's blog.
Write us at:
If you would like to report an abuse of our service, such as a spam message, please .