Re: Please help - MySQL4.1.10 don't run properly after data restored from 5.0.1

2005-03-04 Thread Gleb Paharenko
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

Please help - MySQL4.1.10 don't run properly after data restored from 5.0.1

2005-03-03 Thread sam wun
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