> -Original Message-
> From: Addison, Mark [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 18, 2006 1:22 PM
> To: Amir Bukhari; mysql@lists.mysql.com
> Subject: RE: Backup problem from 5.0 to mysql 4.1
>
> From: Amir Bukhari Sent: 18 July 2006 09:23
> >
from 5.0 to 4.1 doesn't work,
it seem they are not compatible.
I realy don't know what to do, it is hard to insert all data again, it is so
big.
Any help well be appreciated!
-Amir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:htt
successfully and try to delete again, however this time we got
the error
"Got error 127 from storage engine" and the table become corrupted -
need to repair it
When deleting few records there is no problem
However there is no trace to the error in the log file
Any Help ?
Amir
Server
same "select * from . However running
from the same place "check table..." reproduce the error !. Again
running the same "select * from " from all the other
palaces cause the server to fall
Amir
Server parameters
'back_log', '50'
'basedir&
Hi,
Yes the server dies during the queries from JDBC.
Regarding the client parameters, what if the client doesn't have mySQL
installed?
Amir
Hello.
Does SHOW STATUS executed from JDBC client return increased values of
this parameters? Could your server die during queries from
ays after 4.7 seconds and only in "heavy"
queries (not only SELECT, even DELETES )
The problem is probably not in the communication parameters, like
max_allowed_packet or connection_timeout on the server because I
increased then
Does anyone know how can I control those parameters from JDBC?
Amir
Thanks,
but this is just a nicer way to apply my second solution,
I'm looking for a more efficient solution (and if someone can than for an
explanation - why are the results getting duplicated?)
-Amir.
On Thursday 11 March 2004 15:40, Hans van Dalen wrote:
> SELECT distinct main
er solution?
My solution which I guess is not good is adding GROUP BY:
SELECT main.id, IF(main.type,categories.name,items.name),
IF(main.type,"cat","item") AS type FROM main,items,categories WHERE
IF(main.type,categories.id,items.id)=main.id GROUP BY id, type;
Thanks,
I had a typo I was trying to use myisamchk -r not -f to fix it which did
not fix it.
myisamchk -o seems to fix the problem.
The real question is why am i getting this when creating index(s).
Although I'm using the Alpha version, I don't get a warm fuzzy
Any responses on what could be causi
Description:
After inserting 1062351 records into a table I create 2 index on the table.
It seems like after creating the indexs (test have shown that the error appears after
creating the first index) I get the following warning when i do a CHECK TABLES
mytablename or a mysisamchk -a myt
How do you make something like this fault tolerant?
The answer is probably what I suspect, 2 of every thing.
How does the aggregator handle this or are these machines in a cluster?
We are thinking of how to rebuild our fulltext search. Currently it is
in MS SQL 7.0 - MySQL 4.0 seems to blow the
I'm able to index 600,000 records in about 5 to 6 minutes on a dual PII
450
running Win2K and MySQL 4.0.0a
Similar stucture
ID
Title
Description
Indexing Title and Description.
On Wed, 2002-01-09 at 20:26, Jon Shoberg wrote:
>
> I have a simple table with A LOT of data, 2.1M rows. this is p
I've been looking hard at the FULLTEXT features of MySQL 4.0.1 on Linux
and 4.0.0a on Win32 and comparing it to MS SQL 2000 / and MS SQL 7.0 as
well as MySQL 3.XX.XX (latest stable release).
MySQL 4 on Win2K (dual 550 1gig memory) can crawl 90MB of data in about
5 minutes . MS SQL 7 and 2000 on
i am trying to run isamchk / myisamchk on some table files in my database. the tables
are read just fine from the mysql terminal
and the ANALYZE TABLE query returns no errors, yet the isamchk / myisamchk say"error:
22 when opening ISAM-table ... "
the file name is correct ( i get a totaly differ
nse
i'm in desparate need for help... !!!
H E L P ! ! !
10q
amir
[EMAIL PROTECTED]
15 matches
Mail list logo