Thanks Marko :)
-Original Message-
From: Marko Knezevic [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 24, 2005 12:29 AM
To: MySQL list
Subject: Re: urgent : PLEASE HELP - problems with back up and restore
Dear Barak,
Save yourself year or two of your life and try using MySQL Front
file
thanks
Barak
snipped out backup file
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 23, 2005 9:30 PM
To: Barak Mery
Cc: mysql@lists.mysql.com
Subject: RE: urgent : PLEASE HELP - problems with back up and restore
There's a new option added in 5.0.13
Hello.
The start point for you in such kind of problems should be researching
the output of the following statement:
SHOW VARIABLES LIKE '%char%';
Please, run it from different environments (PHP, MySQL Query Browser),
and send results to the list. Include the CREATE statement for you
Hellou!
I have MySQL(charset is utf-8) + PHP 5.0.5. Latvian symbols(auczsnsczikl) not
correctly viewed in MySQL Query Browser, but in 'phpmyadmin' its ok. When i use
php to viewed data with latvian symbols in IE, then latvian symbols(aui.)
is converted to ? symbols.
Please Help!
Ar cienu
For an PHP example of how to import data getting around
max_packet_size, performance, etc. issues.. Be sure to read this
article.
Also linked from: http://dev.mysql.com/doc/refman/4.1/en/blob.html
Article @ http://php.dreamwerx.net/forums/viewtopic.php?t=6
--
MySQL General Mailing List
For list
Dan Buettner wrote:
I tend to disagree - at my place of employment, a newspaper, we have
hundreds of gigabytes of BLOB data (ad and page layouts digital
artwork) stored in SQL databases. Granted we are using Sybase for that
and not MySQL but there are a lot of advantages to it - access
, this is a big problem for me . i couldnt sorted out yet . I used mysqlcc
and sqlYOG as well to upload images ( contents ).
in like this situations how can we work with mp3 and such huge files
please . help me very very urgent
Thanx in advance,
Kane
Kane Wilson wrote:
But when i try to store little but huge gif files it wont store .
First of all, use the method described at
http://www.php.net/manual/en/features.file-upload.php for a safe way to
handle file uploads. It could be that you run into a server limit which
will show up if you
troubles. contents wont stored.
my requrement is any how keep the contents , in the mysql database, i have high
performance machine. so then i'm not worry about perforamnce.
please , let me know how could be the way to store such files in a mysql
databse ???
please help
Jigal van Hemert [EMAIL
.
please , let me know how could be the way to store such files in a
mysql databse ???
please help
Jigal van Hemert [EMAIL PROTECTED] wrote:
Kane Wilson wrote:
But when i try to store little but huge gif files it wont store .
First of all, use the method described at
http
I tend to disagree - at my place of employment, a newspaper, we have
hundreds of gigabytes of BLOB data (ad and page layouts digital
artwork) stored in SQL databases. Granted we are using Sybase for
that and not MySQL but there are a lot of advantages to it - access
control, change control
On Wed, Oct 05, 2005 at 11:23:00AM -0700, Mike Wexler wrote:
Jim Seymour wrote:
I have researched repeatedly and cannot find an answer to the following. I
need to do something like the following (There is probably an easier
way).
end_date - start_date = diff / start_date = return for
I have researched repeatedly and cannot find an answer to the following. I
need to do something like the following (There is probably an easier
way).
end_date - start_date = diff / start_date = return for period
The table contains 401k investment values. Ideas, pointers, etc.? I am using
mysql
Jim Seymour wrote:
I have researched repeatedly and cannot find an answer to the following. I
need to do something like the following (There is probably an easier
way).
end_date - start_date = diff / start_date = return for period
The table contains 401k investment values. Ideas, pointers,
;}
//if (mysql_result($result == 0))(
//echo sorry;
?
please , tell me how can i do this ?
Thanx
Kane.
__
Click here to donate to the Hurricane Katrina relief effort.
http://store.yahoo.com/redcross-donate3/
--
MySQL General
Kane Wilson wrote:
I wanted to check the following condition and if it is
success i wanted to display a massage.I tried as
follows. but no luck. nothing displayed.
$dbQuery = results;
$result = mysql_query($dbQuery) or die(Couldn't get
file list);
if (!isset($result))
{echo NULL;}
tried as
follows. but no luck. nothing displayed.
$dbQuery = results;
$result = mysql_query($dbQuery) or die(Couldn't get
file list);
if (!isset($result))
{echo NULL;}
//if (mysql_result($result == 0))(
//echo sorry;
?
please , tell me how can i do
, September 07, 2005 1:40 AM
To: mysql
Subject: please help .very urgent
hi ,
I wanted to check the following condition and if it is success i wanted to
display a massage.I tried as follows. but no luck. nothing displayed.
$dbQuery = results;
$result = mysql_query($dbQuery) or die(Couldn't
On Thursday 01 September 2005 20:41, Pooly wrote:
Hi,
what is the error in your error log ?
im using MySQL-client-4.1.12-1 binary from mysql website
i got this..
050901 14:50:44 [Warning] Asked for 196608 thread stack, but got 126976
-- im trying to fix this by adding set-variable
the error in the first place.
the error is somehow unpredictable.. sometimes when i access the first page..
its works.. trying refreshing it.. after sometime its works. trying to do it
every once so often then i encounter the problem...
Please describe what you are doing to create the error
Hi all,
Ive read this link http://dev.mysql.com/doc/mysql/en/gone-away.html;
hoping
this has something to do with the error...
Ive already checked based on the page the list of roots of error to
produce
gone-away.. w/c i hope leads to Lost connection to MySQL server during
Hi,
what is the error in your error log ?
Does your server crash for every query it makes ? Or only some ?
Are you using the official binary from MySQL or the one used for you
distro vendor ?
Are you using UDF ?
... We need more inputs ;-)
2005/9/1, JM [EMAIL PROTECTED]:
Hi all,
Ive
are connected through a LAN.
Based on ping an average of .1 ms reply..
tia,
OK, we have the error message (good). We know what you have looked at to
solve the error (also good). What we don't have is what you did to create
the error in the first place.
Please describe what you are doing
.
If this is off topic please accept my apologies and if possible direct
me to an appropriate forum.
Thanks
Rob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Greetings Rob,
What is the optimum way to structure the database to allow for the
simplest user search?
Is it more efficient to store images and large documents in their
respective format on disc and the URL in the database or as blob objects?
Most of the times, especially for read-only
Hi,
I have two simple tables:
CREATE TABLE `new_stations` (
`CD` char(3) default '',
`STATION` varchar(17) default NULL,
`ICAO` varchar(4) NOT NULL default '',
`IATA` varchar(4) default '',
`SYNOP` varchar(7) default '',
`LAT` varchar(6) default '',
`LON` varchar(7) default '',
John thegimper wrote:
This is what i need:
Posted by gogman on Monday May 5 2003, @10:42am on the mysql website:
MySQL defaults to an 'OR'. Example: 'dog cat' = 'dog OR cat'. Most fulltext
search engines default to an 'AND'. These include: AltaVista, Fast Search,
Svensson [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: Please help me: Boolean fulltext searches, AND instead of
OR
Date: Wed, 23 Mar 2005 22:32:49 +0100
Hi!
On Mar 23, Jessica Svensson wrote:
Is there any way i can get results with AND instead of OR?
Trying to search for black
!!
From: Sergei Golubchik [EMAIL PROTECTED]
To: Jessica Svensson [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: Please help me: Boolean fulltext searches, AND instead
of
OR
Date: Wed, 23 Mar 2005 22:32:49 +0100
Hi!
On Mar 23, Jessica Svensson wrote:
Is there any way i can
Hello.
/usr/local/mysql/libexec/mysqld: Out of memory (Needed 32704 bytes)
/usr/local/mysql/libexec/mysqld: Can't read dir of '/var/tmp/' (Errcode: 11)
/usr/local/mysql/libexec/mysqld: Out of memory (Needed 8156 bytes)
Decrease your memory related variables. You have rather old versions
Hi all
a few days a go i have troubles with mysql, the service stops and this is on
two boxes wiht diferents OS. The first one is a FreeBSD 5.3-RELEASE on a
sparc64 the mysql Version is '4.1.5-gamma' and i got this messages in my
logs:
050816 17:11:06 mysqld restarted
Fatal error 'gc cannot
Using OpenRowSet Transact SQL, I want to view/obtain data from MySql
using this function in MS SQL Query Analyzer. Can I do this at all?
I have MyODBC driver and the relevant OLE DB provider to connect to
MySQL db, I can connect to MySQL db, but having problem with the last
parameter (table
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
I installed mysql-standard-4.1.11-pc-linux-gnu-i686] in my system.
There is no file in '/var/lib/mysql/mysql.sock'.
Thanks.
--
MySQL General Mailing List
For list archives:
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
I have installed mysql-standard-4.1.11-pc-linux-gnu-i686 .
Please reply .
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
list.
Cheers, Jared.
-Original Message-
From: Kumar Gaurav [mailto:[EMAIL PROTECTED]
Sent: 02 August 2005 06:01
To: mysql@lists.mysql.com
Subject: Please Give me Solution for this
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
I installed
First check whether MySQL server is running on your machine or not.
You can use 'ps -aux | grep mysql' for checking this.
sujay
-Original Message-
From: Kumar Gaurav [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 02, 2005 10:31 AM
To: mysql@lists.mysql.com
Subject: Please Give me
Hello.
See:
http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html
Kumar Gaurav [EMAIL PROTECTED] wrote:
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
I installed mysql-standard-4.1.11-pc-linux-gnu-i686] in my system.
Just wondering if someone would be kind enough to take a look at it - Nishi
-Original Message-
Following query is taking a long time (upto 10 secs) to
return the resultset. Would greatly appreciate if someone
could help me understand why.
I have run 'analyze table tablename' on
At 01:58 PM 8/2/2005, you wrote:
Just wondering if someone would be kind enough to take a look at it - Nishi
Nishi,
What did EXPLAIN show? Also what happens if you have just one
Match? Is it faster? If so, why not run 2 queries and build a temporary
table from the results. Using OR
Kapoor, Nishikant [EMAIL PROTECTED] wrote on
08/02/2005 02:58:08 PM:
Just wondering if someone would be kind enough to take a look at it -
Nishi
-Original Message-
Following query is taking a long time (upto 10 secs) to
return the resultset. Would greatly appreciate if someone
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 02, 2005 3:14 PM
To: Kapoor, Nishikant
Cc: mysql@lists.mysql.com
Subject: RE: SQL query taking a long time...please
Kapoor, Nishikant [EMAIL PROTECTED] wrote on 08/02/2005 02:58:08 PM:
Just
Hello.
It is possible to obtain your results without temporary tables, but
with user variables. For a pity you should execute three queries.
With first query you're getting the Sum:
select @all_sum:= count( employee_id) from table_employee
where employee_hire_date between
Without knowing more of your requirements, I find seeing the grand total and
overall average repeated in every row strange from a usability perspective.
Do you really need that, or were you just hoping to get that information out
of your query?
I'd suggest something like:
SET @sum=0, @m=0;
Hello MySQL users,
Currently, I use MySQL 4.0.22 and I can do a straightforward count of
employees hired for each month.
select employee_hire_date, count(employee_id)
from table_employee
where employee_hire_date between 2005-01-01 and 2005-4-30
group by month(employee_hire_date)
Date |
Hai
Here is my Query.
When the LAN goes down the client mysql
process does not give any exception.Instead of that
it hangs for Long time in UNIX.But in windows it
raise exception immediately.How to configure in Linux
or Unix to behave as like in windows.
Please
exception.Instead of that
it hangs for Long time in UNIX.But in windows it
raise exception immediately.How to configure in Linux
or Unix to behave as like in windows.
Please reply me .Iam in urgent.
With regards
Ganesh
--
For technical support contracts, goto https://order.mysql.com
Just a test - thanks
There are no problems, only solutions.
Gabe Tucker
Bloomberg LP
(609) 750 6668 - P
(646) 268 5681 - F
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
with a table with 33 rows, i have the row in 0s using index on term.
mysql select * from tx where term like 'Britney Spears' ;
+++
| id | term |
+++
| 327681 | Britney Spears |
+++
1 row in set (0.00
Hi,
i have table which would contain data describing holiday houses. It's it:
idbigint(20) unsigned PRIauto_increment
nametinytext
descriptiontext
webpagetinytext
emailtinytext
whole_cantinyint(1) unsigned
whole_onlytinyint(1) unsigned
type
select * from terms where term like 'Britney Spears' limit 1;
This is taking anywhere from 35-55 seconds. There are only 350,000
records. Here are the indexes:
Keyname = PRIMARY; Type = PRIMARY; Field = id
Keyname = term; Type = UNIQUE; Field = term
Keyname = category; Type = INDEX;
Consultant
MySQL Inc, NY, USA, www.mysql.com
Are you MySQL certified? www.mysql.com/certification
-Original Message-
From: Brian Dunning [mailto:[EMAIL PROTECTED]
Sent: Friday, May 13, 2005 2:59 PM
To: mysql@lists.mysql.com
Subject: SLOW SLOW query - please help!
select * from terms
What is the output of the following:
EXPLAIN select * from terms where term like 'Britney Spears' limit 1;
select_type = SIMPLE
table = terms
type = range
possible_keys = term, term_2 (I just created term_2, fulltext)
key = term (this means it's not using the one I just created?)
key_len = 255
ref
Hi,
I am trying to create a query that returns a users availability for the next
ten days using version 4.1.11. A user has 8.5 hours available per day so a
users availability is equal to 8.5 less any bookings they have on that day.
I have a table called Bookings (see below), and each 'Booking'
is either Windows XP based or Mac OSX. I need to download a
version of mySql that can I can use on either of those platforms to build
the database, that I can then upload, and it will run smoothly on the above
Unix platform on the server.
please help.
--
MySQL General Mailing List
For list
Drew Reid wrote:
Hello I need to download a version of mySql v4, but I don't know which one
to download.
As the server is mySql compatible they must already be running mySql on the
system.
Uh-oh -- not the perennial faceless they, again!?
Shouldn't you ask them what version is on the server so
comes from user input. So
it can be anything like +cat -dog +big nose -horse white black -red
so parsing the input is not what i want, i just want to change the default
word separator to AND instead of OR.
Now i´m running 4.1.10 and also tried with 4.0.24
Please help me, there must be a way to change
but thats not what i want
since the query comes from a searchbox and i dont want to write som code to
manipulate the indata so ite shows correctly i just want to change the
default word separator from OR to AND.
Maybe it´s ft_boolean_syntax that should be changed? If so to what... please
help me
comes from user
input. So it can be anything like +cat -dog +big nose -horse white
black -red
so parsing the input is not what i want, i just want to change the
default word separator to AND instead of OR.
Now i´m running 4.1.10 and also tried with 4.0.24
Please help me, there must be a way
Hi!
On Mar 23, Jessica Svensson wrote:
Is there any way i can get results with AND instead of OR?
Trying to search for black cat should only return records that contains
both black and cat.
I'm using the following code to get my result:
SELECT * FROM `searchtbl` WHERE MATCH (text)
show results with all words present.
This is what i did, set global ft_boolean_syntax = ' +-()~*:|'
I really appreciate your help!!
From: Sergei Golubchik [EMAIL PROTECTED]
To: Jessica Svensson [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: Please help me: Boolean fulltext searches
= ' +-()~*:|'
I really appreciate your help!!
From: Sergei Golubchik [EMAIL PROTECTED]
To: Jessica Svensson [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: Please help me: Boolean fulltext searches, AND instead of OR
Date: Wed, 23 Mar 2005 22:32:49 +0100
Hi!
On Mar 23, Jessica Svensson
), can some explain this to me
please?
Thanks for your help.
TABLE DEFINITIONS:
mysql desc Claims;
+-+-+--+-+-++
| Field | Type| Null | Key | Default | Extra
(and vice versa), can some explain this to me
st please?
st Thanks for your help.
st TABLE DEFINITIONS:
mysql desc Claims;
st +-+-+--+-+-++
st | Field | Type| Null | Key | Default | Extra |
st
is if there are two mileage entries and one expense entry
the
expense total is doubled (and vice versa), can some explain this to me
please?
Thanks for your help.
TABLE DEFINITIONS:
mysql desc Claims;
+-+-+--+-+-++
| Field | Type
But when I execute a complex query, it hangs there forever. I don't have
a chance to see the result because I need to go home to have dinner. The
same query run in a FreeBSD system in Mysql5.01 just takes 2 seconds.
Please, execute this statements while the huge query is running,
and send
Hi,
I have removed all old data and restore the backup data to the directory
/usr/local/mysql/data
I also created root password with mysqladmin and flush its previliges...
Execute the following perl+dbi script seems fine, it retrieves all data
from the customer table in DB which I just
Hi,
I am having trouble with the following query:
SELECT U.User_ID,
U.User_Firstname,
U.User_Lastname
FROM Users U, Allocations A
WHERE (U.User_ID = A.User_ID OR U.User_ID = 101)
AND A.Project_ID = '12'
AND ( U.User_Type = 'Staff'
OR U.User_Type = 'Manager'
OR U.User_Type = 'Administrator' )
ORDER
- Original Message -
From: shaun thornburgh [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday, February 21, 2005 7:28 AM
Subject: Help with a query please
Hi,
I am having trouble with the following query:
SELECT U.User_ID,
U.User_Firstname,
U.User_Lastname
FROM Users U
From: Rhino [EMAIL PROTECTED]
To: shaun thornburgh
[EMAIL PROTECTED],mysql@lists.mysql.com
Subject: Re: Help with a query please
Date: Mon, 21 Feb 2005 08:22:29 -0500
- Original Message -
From: shaun thornburgh [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday, February 21, 2005
thornburgh [EMAIL PROTECTED]
To: [EMAIL PROTECTED], mysql@lists.mysql.com
Subject: Re: Help with a query please
Date: Mon, 21 Feb 2005 13:24:55 +
From: Rhino [EMAIL PROTECTED]
To: shaun thornburgh
[EMAIL PROTECTED],mysql@lists.mysql.com
Subject: Re: Help with a query please
Date: Mon, 21 Feb
shaun thornburgh schrieb:
Thanks for your reply, I would like the query to retun one
instance of user 101 rather than 15!
SELECT DISTINCT ...
Regards,
A.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
** Be prepared, rate R **
http://hk.geocities.com/blood1213/fur.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi leegold,
I don't know what mysql_real_escape_string would do, because it isn't a
standard-php-function. So I don't regard it and talk about the basics.
In fact you have a string delimiter in Librarian's Edition so you have to
escape it to make MySQL know where the string really ends.
OK, I use an older version of PHP where mysql_real_esacpe_strings isn't
avail. But nevertheless I would always prefer double-quoting with
$descrip_field=str_replace(','',$$descrip_field);
This is because I got lot's of Problems with different languages on
different databases when you try to make
I'm ripping hair out, here's the problem...I'm trying to insert content
cited below into a field and it's causing this error, ie. there's
content i just cannot insert into the DB an it's causing the following
error message:
You have an error in your SQL syntax; check the manual that corresponds
leegold wrote:
I'm ripping hair out, here's the problem...I'm trying to insert content
cited below into a field and it's causing this error, ie. there's
content i just cannot insert into the DB an it's causing the following
error message:
You have an error in your SQL syntax; check the manual that
Hi all,
On a Fedora Core 3 machine which releases with MySQL
3.23 I downloaded all necessary 4.1 RPMs and
installed, however the MySQL 3.23 existed, but it
didn't work. Also, all 4.1 RPMs had uninstalled
automatically MySQL 3.23 and had re-installed itself.
Then I removed all new installed 4.1
Read this:
http://www.whoopis.com/howtos/php5-mysql4-FC3-rpm.html
Quoting Helena Carlsson [EMAIL PROTECTED]:
Hi all,
On a Fedora Core 3 machine which releases with MySQL
3.23 I downloaded all necessary 4.1 RPMs and
installed, however the MySQL 3.23 existed, but it
didn't work. Also, all
Hello.
4.0.17 is old enough. You may switch to the debug version and attempt to
find the clues in debug or trace files. Can you reproduce an error on the
latest release (4.1.9 now)? Do you lost connection to the server with
other statements, than 'SHOW DATABASES'? Please answer
Hello.
Does the problem remain? What is in the error log? Please, send
us information about MySQL and operating system versions. There are
two variables: max_allowed_packet - one has client, another has server.
Run mysql with --max_allowed_packet=16M and mysqld with the same value.
May
...
David
Hello.
Does the problem remain? What is in the error log? Please, send
us information about MySQL and operating system versions. There are
two variables: max_allowed_packet - one has client, another has server.
Run mysql with --max_allowed_packet=16M
.
Does the problem remain? What is in the error log? Please, send
us information about MySQL and operating system versions. There are
two variables: max_allowed_packet - one has client, another has server.
Run mysql with --max_allowed_packet=16M and mysqld with the same value.
May be you have
access to write into my errorlog file
and in my directories.
David
David Marois
-Message d'origine-
De : Michael Dykman [mailto:[EMAIL PROTECTED]
Envoyé : 3 février, 2005 10:02
À : Marois, David
Cc : MySQL List
Objet : Re: help please : ERROR 2006: MySQL server has gone away
So far, you
Hello.
What's the value of the interactive_timeout system variable? See:
http://dev.mysql.com/doc/mysql/en/server-system-variables.html
http://dev.mysql.com/doc/mysql/en/gone-away.html
Marois, David [EMAIL PROTECTED] wrote:
[-- text/plain, encoding 7bit, charset: iso-8859-1, 19
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: woensdag 2 februari 2005 12:46
To: mysql@lists.mysql.com
Subject: Re: help please : ERROR 2006: MySQL server has gone away
Hello.
What's the value of the interactive_timeout system variable? See:
http
Hello.
I've asked you about interactive_timeout, not wait_timeout.
Mark [EMAIL PROTECTED] wrote:
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: woensdag 2 februari 2005 12:46
To: mysql@lists.mysql.com
Subject: Re: help please : ERROR 2006: MySQL
2 februari 2005 12:46
To: [EMAIL PROTECTED]
Subject: Re: help please : ERROR 2006: MySQL server has gone away
Hello.
What's the value of the interactive_timeout system variable? See:
http://dev.mysql.com/doc/mysql/en/server-system-variables.html
http://dev.mysql.com/doc/mysql/en/gone
Paharenko [mailto:[EMAIL PROTECTED]
Sent: woensdag 2 februari 2005 12:46
To: [EMAIL PROTECTED]
Subject: Re: help please : ERROR 2006: MySQL server has gone away
Hello.
What's the value of the interactive_timeout system variable? See:
http://dev.mysql.com/doc/mysql/en/server-system
Hi,
I have this error when I am connected in mysql:
ERROR 2006: MySQL server has gone away. No connection. Trying to reconnect...
I only did this command: show databases;
and received the error.
I noticed that if I don't send a command since 25 sec, I have the error.
Also, my variable
Lee wrote:
Are you escaping the data you insert? If you have apostrophies eg.
Sheryl's Website, you could have problem if you do not escape special
chars. See if it happens with just aa (without the quotes) in all
the fields in the record...then try unescaped words with apostrophies.
I'm
-Original Message-
From: Sheryl (Permutations Software) [mailto:[EMAIL PROTECTED]
Sent: maandag 31 januari 2005 14:44
To: 'leegold'; mysql@lists.mysql.com
Subject: RE: disappearing data - please help!
Par down the PHP or what ever script you're using to the minimum
ie. make
I've got a weird problem that's driving me nuts. I'm updating a set of
scripts for a customer database that supports sending out software
registration codes in real time. I've had this working for some time now,
but I'm having the most frustrating problem. Data I've inserted simply
VANISHES.
I've
On Sun, Jan 30, 2005 at 03:28:56PM -0500, Sheryl (Permutations Software) wrote:
but I'm having the most frustrating problem. Data I've inserted simply
VANISHES.
What is the setting for AutoCommit? If it is 0, are you sure
that commit is being called before the session ends?
-Jason Martin
--
-
From: Jason Martin [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 30, 2005 3:38 PM
To: mysql@lists.mysql.com
Subject: Re: disappearing data - please help!
On Sun, Jan 30, 2005 at 03:28:56PM -0500, Sheryl (Permutations Software)
wrote:
but I'm having the most frustrating problem. Data I've
On Sun, Jan 30, 2005 at 04:03:37PM -0500, Sheryl (Permutations Software) wrote:
transactions. It's just the default. I don't know where I'd check AutoCommit
settings (or it they even apply to the default database type). It doesn't
refer to this in phpinfo.php.
Try doing this immediately after
-Original Message-
From: Sheryl (Permutations Software) [mailto:[EMAIL PROTECTED]
Sent: zondag 30 januari 2005 21:31
To: mysql@lists.mysql.com
Subject: disappearing data - please help!
What makes this all the more mysterious is that it happens
intermittently. Sometimes when
From: Sheryl (Permutations Software) [mailto:[EMAIL PROTECTED]
Sent: zondag 30 januari 2005 21:31
To: mysql@lists.mysql.com
Subject: disappearing data - please help!
What makes this all the more mysterious is that it happens
intermittently. Sometimes when the script completes
Hello.
You can enable logging on the server. See:
http://dev.mysql.com/doc/mysql/en/log-files.html
You need the error log, query log, slow log. But be careful!
Heavy loaded server can produce a lot of messages and your
files will grow quickly. If you use InnoDB, you can enable
the
I have a mysql server running on WIN-XP (in a critical
health area) and it started to give me that error.
At first, the problem ocurred in a machine and then
started to scatter all over the system. On Saturday I
reset the Server Machine and the problem disapeared.
But today applications started
Hi,
I am trying to get all field names from my table that begin with
letter X or Y, however the following statement and many variations I
have tried produce an error:
SHOW COLUMNS FROM TABLE LIKE X% OR LIKE Y%
Any help here would be much appreciated :)
--
MySQL General Mailing List
For list
201 - 300 of 1426 matches
Mail list logo