469,892 Members | 2,145 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,892 developers. It's quick & easy.

upgrading from 3.23 to 4.0.16


Few days ago I upgraded my MySQL 3.23.xx (can't remember those two
last, really) to 4.0.16. And then three problems came up (well, more
than two came up, but I solved all the others).

1. problem
I'm pretty sure I don't have any ISAM tables, but I'm not 100% sure.
How do I list types of all tables in ALL databases? SHOW TABLE STATUS
works only for curent database...

2. problem
$ mysqldump -A -uroot -ppassword > /dev/null
mysqldump: Can't get CREATE TABLE for table `forum_01posts` (Can't
open file: 'forum_01posts.MYI'. (errno: 145))

What's that???

3. problem
PHP returns this while trying to connect to MySQL server from machine
WHICH IS NOT LOCALHOST (when trying to connect from localhost,
everything's fine)
($link = mysql_connect($MYSQL_HOST, $MYSQL_USER, $MYSQL_PASS) is line
3 in data_connect.php):
Warning: Lost connection to MySQL server during query in
/home/users2/nick/public_html/umzpa/data_connect.php on line 3

Warning: MySQL Connection Failed: Lost connection to MySQL server
during query in /home/users2/nick/public_html/umzpa/data_connect.php
on line 3

I tried to fix this by experimenting with GRANT command, but haven't
succeded. Before upgrading everything was fine. I haven't been
changing mysql.host table. What do I do?
Jul 19 '05 #1
0 1106

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by S. Crespel | last post: by
1 post views Thread by bartolomesintes | last post: by
6 posts views Thread by Michael Foord | last post: by
reply views Thread by Jonathan Hilgeman | last post: by
2 posts views Thread by wellington fan | last post: by
5 posts views Thread by Mike Owen | last post: by
11 posts views Thread by Aidan Tobin | last post: by
1 post views Thread by progTiger | last post: by
1 post views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.