Database error after transfer to new server

[dyaaez]

If backup was made bad (not all db in there or mysql fail), then you see, what you see.
As I wrot before, try to unpack db and import manually (in ssh console)

Thanks for reply, and trying to resolve my problem

I`m already did that, and used bigdump script, but same result .

What can I do too ?

[skurudo]

I`m already did that, and used bigdump script, but same result .
What can I do too ?

May be tables in source broken? Try to fix / optimize tables and then make dump.

[dyaaez]

I`m already did that, and used bigdump script, but same result .
What can I do too ?

May be tables in source broken? Try to fix / optimize tables and then make dump.

I`ve 30 backup, one of that maybe broken not all
I tried to restore another backup file, but same result
when I`m using bigdump a lots of errors, and restored 8 tables only (same result)

[skurudo]

from console on old server -

Code: Select all

mysqlcheck -A --auto-repair

(c) http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html

then try to backup databases or export databases one by one

[dyaaez]

from console on old server -

Code: Select all

mysqlcheck -A --auto-repair

(c) http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html

then try to backup databases or export databases one by one

Oh, my old server expired. I can not access again .
But I`ve lots of backups, anyway to do something ?

[mestresan]

I think the error is in my.cnf ... package size... change variable
max_allowed_packet = 256M

put high value if necessary...

[dyaaez]

I think the error is in my.cnf ... package size... change variable
max_allowed_packet = 256M

put high value if necessary...

my.cnf contents:

Code: Select all

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
symbolic-links=0
max_connections=200
max_user_connections=30
wait_timeout=30
interactive_timeout=50
long_query_time=5
#log-queries-not-using-indexes
#log-slow-queries=/var/log/mysql/log-slow-queries.log

#innodb_use_native_aio = 0
innodb_file_per_table

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[dyaaez]

Someone said to me: "You must change/convert DB type From MyISAM to InnoDB "