By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,027 Members | 1,111 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,027 IT Pros & Developers. It's quick & easy.

upgrading from 3.23 to 4.0.16

P: n/a
Hi!

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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.