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 t
they are the ones you are expecting from the form.
Hope this helps
Dobromir Velev
WebSitePulse
On Monday 23 February 2009 17:25, PJ wrote:
> I think this is a tough one... and way above my head:
> PLEASE READ ALL OF THE ABOVE TO UNDERSTAND WHAT I AM TRYING TO DO.
> Having a bit of a r
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 be
ld restarted
080424 4:31:57 InnoDB: Database 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
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 Ve
BLE STATUS" command
displays 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]
ording to
your 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
future.
Thanks
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 =
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
ot do 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 wo
ion_id = " & prepSQL(tConn, tSessionID);
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.websit
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 Ve
om messages where to_uid=1 and read_timestamp>0 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 LAST_DAY()
function.
--
Dobromir Velev
On Tuesday 18 October 2005 19:01, grKumaran wrote:
> - Original Message -
> From: "grKumaran" <[EMAIL PROTECTED]>
> To:
> Sent: Tuesday, October 18, 2005 16:08
> Subject: query help
>
> : Hello,
> :
> : CREA
/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
>
&
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 realize
o use 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
te='pcname' );
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
> --
be empty, NULL 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 u
27;EmailMessage_j.MYI' is corrupted
> Fix it using switch "-r" or "-o"
>
>
> --
> --
> please respond to the list .. if you need to contact me direct
> cgmckeever is the account
> prupref.com is the domain
>
er by feed_date DESC
but it is not as accurate and returns more irrelevant 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
> te
2005 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 Mail
backups.
>
> Thanks in advance!
>
> Jeff
>
> --
> Jeff Richards
> Consulting Architect
> Openwave Systems 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]
0)
--- TRX HAS BEEN WAITING 7 SEC FOR THIS LOCK TO BE GRANTED:
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]
7;max_join_size', '4294967295'
> 'max_length_for_sort_data', '1024'
> 'max_relay_log_size', '0'
> 'max_seeks_for_key', '4294967295'
> 'max_sort_length', '1024'
> 'max_tmp_tables
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
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, ho
0 |
+--+
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
way. I'd rather use
two 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 P
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
y
work if there is only one session for each 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.
/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/
On
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
(nor any possibility
> to do so easily).
>
> Any 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
he query 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 th
))){
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,
&g
eplace the $keyword_id with the id of the keyword you are looking for.
Personally I would prefer the first option and put an index on the keywords
field but you should check for yourself which query will work faster.
--
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
On Friday 11 Ju
$cmycres->execute() or mysql_die();
my $i=7; #this will leave the last seven logs intact
while ($i<=$cmycres->rows){
@log=$cmycres->fetchrow;
$i++;
}
$cmycres->finish();
print localtime()." purging logs to $log[0]\n";
$dbh->do("purge master logs
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 yo
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
[
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.website
e problem - 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
ins 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 Ve
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 P
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_R
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" <[EMAI
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 P
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: &l
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]>
S
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: T
the records line by line:
$fp=fopen("filename","r");
if($fp){
while (!feof($fp)){
$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 M
ield or every time 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, 2
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
Hi
you can use
SELECT * FROM table WHERE expire>NOW();
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: &l
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 PROT
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
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
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" <[EM
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 PROT
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 Pelle
com/doc/en/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:
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: "
Hi,
There might be a bug in mysql 4 (tested on 4.0.8-gamma and 4.0.9-gamma) when
combining simple arithmetic operations and date conversion
I have a table with the following structure
date_col date -00-00
int_col tinyint(3) unsigned
This is what happens when I try to run a query like the one
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
query execution 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
;0001"
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
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
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
70 matches
Mail list logo