We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
Database error after transfer to new server
Re: Database error after transfer to new server
Thanks for reply, and trying to resolve my problemskurudo wrote: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)
I`m already did that, and used bigdump script, but same result .
What can I do too ?
Re: Database error after transfer to new server
May be tables in source broken? Try to fix / optimize tables and then make dump.dyaaez wrote: I`m already did that, and used bigdump script, but same result .
What can I do too ?
Re: Database error after transfer to new server
I`ve 30 backup, one of that maybe broken not allskurudo wrote:May be tables in source broken? Try to fix / optimize tables and then make dump.dyaaez wrote: I`m already did that, and used bigdump script, but same result .
What can I do too ?
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)
Re: Database error after transfer to new server
from console on old server -
(c) http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html
then try to backup databases or export databases one by one
Code: Select all
mysqlcheck -A --auto-repair
then try to backup databases or export databases one by one
Re: Database error after transfer to new server
Oh, my old server expired. I can not access again .skurudo wrote:from console on old server -(c) http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.htmlCode: Select all
mysqlcheck -A --auto-repair
then try to backup databases or export databases one by one
But I`ve lots of backups, anyway to do something ?
Re: Database error after transfer to new server
I think the error is in my.cnf ... package size... change variable
max_allowed_packet = 256M
put high value if necessary...
max_allowed_packet = 256M
put high value if necessary...
Re: Database error after transfer to new server
mestresan wrote: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
Re: Database error after transfer to new server
Someone said to me: "You must change/convert DB type From MyISAM to InnoDB "