Hi,
Can you try passing the dump file through hexdump or some binary editor to
see if the data is there. Most text editors will treat 0x00 as end of string
and this most likely this is causing the problem.
Additionally you can try running the import with --default-character-set=utf8
in case
= mysql_query( $sql4, $db);
?
And you should always sanitize the input from forms - the above example is
just to show you how this works. You should check all the values in
$categoriesIN whether they are the ones you are expecting from the form.
Hope this helps
Dobromir Velev
WebSitePulse
On Monday 23
Hi,
I guess the id_file_set is an INT?
The problem si most likely due to the fact you are comparing integer to
string, which forces MySQL to use type conversion. For more information
check http://dev.mysql.com/doc/refman/5.0/en/type-conversion.html
When type conversion occurs MySQL will not
was not shut down normally!
InnoDB: Starting crash recovery.
Thanks for your help
Dobromir Velev
On Wednesday 23 April 2008 22:05, Jerry Schwartz wrote:
If Linux works the same way as HP-UX (and it should), anything you do to an
open file (including deleting it) has no effect until the file
relevant results and still the test.ibd file to which the symlink
points hasn't been changed or accessed at all.
Any ideas are welcome
Dobromir Velev
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
Thanks for pointing it out - I just found the following commands.
ALTER TABLE tbl_name DISCARD TABLESPACE;
ALTER TABLE tbl_name IMPORT TABLESPACE;
I will test it and let you know if it works
Thanks
Dobromir Velev
On Wednesday 23 April 2008 16:27, Sebastian Mendel wrote:
Dobromir Velev
table structure there is an UNIQUE index on LocID and InvDate so there
should not be more than one record.
Dobromir Velev
WebSitePulse.com
On Tuesday 22 January 2008 02:39, Daniel Kasak wrote:
On Tue, 2008-01-22 at 11:23 +1100, Chris wrote:
Why is it saying 'Impossible WHERE noticed after
Dobromir Velev
On Saturday 06 May 2006 01:23, Heikki Tuuri wrote:
Dobromir,
you are running a 32-bit operating system. Then the size of the mysqld
process is limited to 2 GB, or at most to 4 GB. The amount of total RAM 8
GB does not help here, since 2^32 = 4 G.
You should reduce
Hi,
I'm trying to resolve why InnoDB is crashing. It happened twice for the last
month without obvoius reason
Any help will be appreciated.
Dobromir Velev
My Server is
Red Hat Enterprise Linux ES release 3 (Taroon Update 7) 2.4.21-32.0.1.ELsmp
Dual 3.2 GHz Intel Xeon
8 GB RAM
with 3 x 146GB
anything.
Check the MySQL Reference for more details
http://dev.mysql.com/doc/refman/4.1/en/create-table.html
HTH
--
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
On Friday 11 November 2005 14:14, Luke wrote:
Hey all,
I've got a question for you. What would be the best way
);
If there are any products for the selected session_id this should return one
row for every status like this
| status |
+-+
| unknown |
| shipping_now |
| shipping_soon |
HTH
--
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
On Tuesday 25 October 2005 01:00, Scott Haneda wrote
I think there should be no problem to use the SUM() function - did you tried
it like this
select SEC_to_time(SUM(unix_timestamp(TTendTime) -
unix_timestamp(TTstartTime))) as endtime
FROM TimeTracking
WHERE TTperson = 1 and date(TTstartTime) = '2005-10-19'
HTH
--
Dobromir Velev
[EMAIL
where to_uid=1 and read_timestamp0 order by
timestamp desc limit 100,1)
HTH
--
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
On Friday 21 October 2005 11:44, Eric Persson wrote:
Hi,
Is it possible to delete from a table with some sort of offset? I did
the following select query
saw his response using the LAST_DAY()
function.
--
Dobromir Velev
On Tuesday 18 October 2005 19:01, grKumaran wrote:
- Original Message -
From: grKumaran [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, October 18, 2005 16:08
Subject: query help
: Hello,
:
: CREATE
/5.0/en/dns.html and the
related articles in the MySQL documentation
HTH
Dobromir Velev
On Thursday 13 October 2005 15:38, Anil wrote:
Hi List,
When I am trying to connect to mysql 4.0.20 database it is taking very long
time when I specified host like
Mysql -ux -p -h192.168.3.111
or not. Then
you will have to modify your UPDATE/DELETE queries to not affect locked
records.
HTH
--
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
On Wednesday 07 September 2005 23:36, Rich wrote:
Hi there.
I started a different thread on this, but then I realized I might
' );
HTH
--
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
On Friday 02 September 2005 14:37, Klemens Ullmann wrote:
hello!
I've got two tables for an IT hardware inventory:
### table inventory:
invid model
---
1001 HP Notebook// no attributes
1002
the IP-addresses instead of the
hostnames and use skip_hostname_resolve - the connection overhead will be
smaller this way.
You can also check the comments on
http://dev.mysql.com/doc/mysql/en/dns.html
--
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
On Friday 02 September 2005
or a numeric value will
satisfy this condifition also?
HTH
--
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
On Sunday 31 July 2005 16:37, Martin Lancaster wrote:
Hi all,
I am using MySQL 4.1.11nt
I have two MyISAM tables:
Table 1 holds usage information about users accessing various
://www.prupref.com;Simply Chicago Real Estate/A
--
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Asia Pacific
+61 415 638757
--
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
04:21, Joeffrey Betita wrote:
hello
what command should i type to see all the user connected to the database.
thank you very much.
rgds,
Joeffrey
--
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
results
HTH
--
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
On Wednesday 27 July 2005 03:47, Blogfreaks.com wrote:
I'm using a boolean query to perform an exact match on musicians within a
text field. However, if the musician's name contains a quote, I get
inaccurate results
:
TABLE LOCK table `db_name/slogs` trx id 2 559663507 lock mode AUTO-INC waiting
--
Dobromir Velev
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
)
at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:2209)
at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:413)
at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:1899)
at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1347)
--
Dobromir Velev
[EMAIL PROTECTED]
http
Hi,
I'm running quite a large database - mostly inserts (4-5 million rows a day)
and an occasional select to generate some report based on the inserted data
which works very well.
Once a month I need to generate a larger number of reports. The SELECT queries
are optimized quite well but some of
Hi,
Is there anything your mysql errog log? Did MySQL crashed or stopped
unexpectedly while the script was running? I guess it is probably something
with your memory usage configuration - please send your my.cnf file and on
what machine you are running your MySQL server.
--
Dobromir Velev
to retrieve the
dates when a week starts/ends but this should nto be a problem
HTH
--
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
On Tuesday 26 October 2004 16:28, shaun thornburgh wrote:
Hi,
I am creating an online timesheet application. Most parts are done, however
I have
|
+--+
1 row in set (0.15 sec)
the average time to execute the procedure will be 0.15/1000 = 0.00015 seconds
HTH
--
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
On Tuesday 12 October 2004 19:47, Thomas Schager wrote:
Hi,
I need to messure the time needs of my procedures
to convert
all INNODB tables to MYISAM (or dump them to a SQL file), recreate the INNODB
file (s) and then recreate the original INNODB tables. This process could
take a lot of time depending on the size of your tables so you should
proceed with care.
HTH
--
Dobromir Velev
[EMAIL PROTECTED
queries - one for the total and one for the percentages. If field1 is
indexed
select count(*) from table where field1='myvalue'
should be quite fast, so I don't think you should worry about having an
additional query.
HTH
--
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com
/innodbfile:100M:autoextend:max:60G
When Innodb first started it created a 100 MB file and with the time this file
has growed to 20GB. For more information check
http://dev.mysql.com/doc/mysql/en/InnoDB_configuration.html
HTH
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com
CallingStationId and
CalledStationId pair, otherwise you will receive a lot of irrelevant results.
--
Dobromir Velev
On Friday 03 September 2004 15:21, Peter J Milanese wrote:
If it were all in one row, you may be able to compare datetime fields.
I do not know if you can do this with 2 rows
Warnier wrote:
Le mar 31/08/2004 à 16:21, Dobromir Velev a écrit :
Hi,
Make sure that the mysql user have permissions to write into the folder
/var/lib/mysql (or whatever your data folder is) .
Thanks Eric and Dobromir. This was a problem of permissions on
/var/lib/mysql indeed. Although
idea?
Thanks,
Yannick
--
Dobromir Velev
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
You can use a query like this one
SELECT string, COUNT(string) as co FROM searchstat GROUP BY string order by co
DESC;
HTH
--
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
On Friday 27 August 2004 16:03, Dialogcentret wrote:
Example: I have a search box on my webpage
something like this
should work though I would personally add some additional error testing.
if(mysql_result($result,0,0)=5){ }
HTH
--
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
On Wednesday 25 August 2004 18:02, Stuart Felenstein wrote:
Thought earlier that I could get
))){
usedata(row);
}
Of course it depends on what do you need the mysql data for - but if you can
make it to use one row at a time it should run a lot more faster.
--
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
On Tuesday 29 June 2004 08:50, Matt Eaton wrote:
Hi all,
I
unless all slaves have already processed it.
--
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
On Friday 11 June 2004 00:55, Jeff Smelser wrote:
On Thursday 10 June 2004 08:03 am, Josh Trutwin wrote:
Would you be willing to share your perl script? Perhaps offlist if you
]') or mysql_die();
$dbh-disconnect;
print Logs purge end: .localtime().\n;
--
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
On Friday 11 June 2004 00:55, Jeff Smelser wrote:
On Thursday 10 June 2004 08:03 am, Josh Trutwin wrote:
Would you be willing to share your perl script? Perhaps
I've made a simple perl script that uses the
show master logs
and
purge master logs to 'mysql.???'
queries to remove all but the last seven logs and it works perfectly for me.
Check http://dev.mysql.com/doc/mysql/en/PURGE_MASTER_LOGS.html for details.
--
Dobromir Velev
[EMAIL PROTECTED
Check out the BENCHMARK function
http://dev.mysql.com/doc/mysql/en/Information_functions.html
On Tuesday 08 June 2004 20:22, Jeffrey M. Johnson wrote:
How do you determine the average time per query in MySQL?
Jeff Johnson
--
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com
- the additional
index will never be used and it will just take unneccessary space in your index file.
You should check the SQL query syntax - for example adding brackets might help.
HTH
Dobromir Velev
- Original Message -
From: Koen Van Mulders
To: Dobromir Velev
Sent: Friday, December
will be made like
SELECT * FROM (tbl_v_batch b LEFT JOIN tbl_v_levering l ON l.ver_lev_id =
b.batch_lever_id) LEFT JOIN tbl_klanten k ON k.klant_id = l.ver_lev_klant_id;
HTH
Dobromir Velev
[EMAIL PROTECTED]
- Original Message -
From: Koen Van Mulders
To: Dobromir Velev
Sent: Thursday
Hi,
Have you indexed the fields you're using in the JOIN clauses?
Dobromir Velev
[EMAIL PROTECTED]
- Original Message -
From: Koen Van Mulders [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, December 18, 2003 15:45
Subject: Problem with EQ_REF and ALL
Someone please help me
Can you please send the tables structure. This happens when the fields you
are using in the JOIN clause are with different types fro example when
trying to join a VARCHAR with INT
Dobromir Velev
[EMAIL PROTECTED]
- Original Message -
From: Koen Van Mulders [EMAIL PROTECTED]
To: [EMAIL
Hi,
You can do it in several smaller and faster deletes using the LIMIT option -
for example
DELETE QUICK from table WHERE indexed_row UNIX_TIMESTAMP()-86400 limit
1;
HTH
Dobromir Velev
[EMAIL PROTECTED]
- Original Message -
From: Chris Elsworth [EMAIL PROTECTED]
To: [EMAIL
Hi,
You need to index the column that is used in the where clause
try this
ALTER TABLE tempo_resposta ADD INDEX idmaquina (idmaquina);
HTH
Dobromir Velev
- Original Message -
From: Leonardo Rodrigues Magalhães [EMAIL PROTECTED]
To: MySQL ML [EMAIL PROTECTED]
Sent: Friday, June 13, 2003
They both use 1 byte
Check this for more information
http://www.mysql.com/doc/en/Storage_requirements.html
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
- Original Message -
From: Mattias Barthel [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 25, 2003
Hi,
most probably there should not be a space after -p.
Try this
mysql -h localhost -uroot -pmysql did.query did.out
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
- Original Message -
From: Marianadin, Didier [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday
)){
$line=fgets($fp,4096);
mysql_query(delete from table where id = $line,$db);
}
fclose($fp);
}
HTH
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
- Original Message -
From: Scott Haneda [EMAIL PROTECTED]
To: MySql [EMAIL PROTECTED]
Sent: Tuesday, March 25, 2003 09
Hi,
you can use something like this
select count(*) as co
from ...
group by ...
order by co DESC limit 0,1
HTH
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
- Original Message -
From: Hu Qinan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 25, 2003 16:03
Hi,
I use it in queries like
SELECT * FROM table WHERE field REGEXP patern;
It is the same as using the LIKE operator wit more complex patterns
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com
- Original Message -
From: Darren Young [EMAIL PROTECTED]
To: [EMAIL PROTECTED
you'll have to wait long time before the query executes.
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
- Original Message -
From: Dallas Engelken [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 05, 2003 17:30
Subject: sql_big_selects
i have a datbase
Hi
you can use
SELECT * FROM table WHERE expireNOW();
or
SELECT * FROM table WHERE to_days(expire)to_days(NOW());
HTH
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
- Original Message -
From: Stephen of Blank Canvas [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent
HI,
To test for records that are not present in a table you should use
journoNatOpt.journoid is NULL
instead of
journoNatOpt.journoid = ''
HTH
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
- Original Message -
From: David Phipps [EMAIL PROTECTED]
To: MySQL List [EMAIL
You van use the LOAD DATA INFILE statement
Check this
http://www.mysql.com/doc/en/LOAD_DATA.html
for more information
HTH
Dobromir Velev
[EMAIL PROTECTED]
www.websitepulse.com
- Original Message -
From: Andrew [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 30, 2003 12
Hi,
a query like this should do the job
select user_profile.user_id from user_profile left join team_member on
(team_member.user_id=user_profile.user.id and team_member.team_id=2) where
team_member.user_id is NULL;
Dobromir Velev
[EMAIL PROTECTED]
www.websitepulse.com
- Original Message
/Cast_Functions.html for more information
HTH
Dobromir Velev
[EMAIL PROTECTED]
- Original Message -
From: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]
To: Brian Lindner [EMAIL PROTECTED]; Octavian Rasnita
[EMAIL PROTECTED]
Cc: MySQL [EMAIL PROTECTED]
Sent: Monday, January 20, 2003 01:09
Subject: Re
Hi,
It looks you haven't updated the mysql client configuration. Adding this
lines to your my.cnf file should solve the problem.
[client]
port=3306
socket=/raidarrary2/data/mysql/mysql.sock
HTH
Dobromir Velev
[EMAIL PROTECTED]
- Original Message -
From: Michael Pelley [EMAIL PROTECTED
Hi,
Please read
http://www.mysql.com/doc/en/Problems_with_float.html
It is a common problem when working with floating point numbers
Dobromir Velev
[EMAIL PROTECTED]
- Original Message -
From: Octavian Rasnita [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Monday, January 20
and the negative value will be displayed. For example this should give you
what you need
select 15.0 - id from test;
3. Use CAST function. Example:
select cast(15-id as signed) from test;
HTH
Dobromir Velev
[EMAIL PROTECTED]
- Original Message -
From: Octavian Rasnita [EMAIL PROTECTED
|
| 18446744073709551609 |
| 18446744073709551607 |
| 18446744073709551609 |
| 18446744073709551607 |
| 18446744073709551615 |
Tested on Linux Redhat 7.3 and on a Slackware 7.0.0
TIA
Dobromir Velev
In addition to the previous I just want to say that the problem is most
likely with the unsigned columns - I altered the integer column to remove
the 'unsigned' property and now it is working properly
Regards
Dobromir Velev
[EMAIL PROTECTED]
- Original Message -
From: Dobromir Velev
decided to optimize one of my tables (5 milion rows) and
altered a varchar(250) field to a varchar(100).
The size of the MYD data file changed with less than 1Mb so you see that
there was not much use of doing it.
Dobromir Velev
Software Developer
http://www.websitepulse.com/
-Original Message
stops. I know my table is OK - I used myisamchk
before trying to delete records and there were no problems
Any ideas?
Dobromir Velev
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
Hi,
Try to change the alias - group is a reserved word and it is causing the syntax error
This one should work
SELECT members.name, gr.id, gr.name
FROM members
LEFT JOIN members AS gr
ON gr.id = members.group_id
WHERE members.id = 6
Dobromir Velev
Web developer
http://www.websitepulse.com
HI,
The 127 error message is Record-file is crashed - use
myisamchk -r table_name
to fix it.
For further information on this topic check
http://www.mysql.com/doc/R/e/Repair.html
Hope this helps
Dobromir Velev
Web Developer
http://www.websitepulse.com/
-Original Message-
From
AND products.Class=0002
AND prodcat.category=Animal
AND prodcat.subcategory=Bear
ORDER BY products.Title
LIMIT 100
Check http://www.mysql.com/doc/L/I/LIMIT_optimisation.html
for further information on how MySQL deals with LIMIT
Hope this helps
Dobromir Velev
Web Developer
http
69 matches
Mail list logo