Backup problem from 5.0 to mysql 4.1

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:http://lists.mysql.com

RE: Backup problem from 5.0 to mysql 4.1

-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 I have local mysql 5.0 and I have

Got error 127 from storage engine

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 parameters

Lost connection to MySQL server during query - on long queries

. However running from the same place check table... reproduce the error !. Again running the same select * from some big table from all the other palaces cause the server to fall Amir Server parameters 'back_log', '50' 'basedir', '/' 'binlog_cache_size', '32768

Re: Lost connection to MySQL server during query problem

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 JDBC

Lost connection to MySQL server during query problem

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

Query with IF acting wierd.

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, -Amir. -- MySQL General Mailing List For list

Re: Query with IF acting wierd.

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.id, etc

Warning, Found xxx parts Should be: 0 parts

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

Re: Warning, Found xxx parts Should be: 0 parts

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

Re: Distributed Fulltext?

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

Re: Suggestions - FullText ??

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

RE: Full Search

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

isamchk / myisamchk return error 22

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

select HELP from HERE where HELP_NEEDED = TRUE !

sponse i'm in desparate need for help... !!! H E L P ! ! ! 10q amir [EMAIL PROTECTED]