Community Forum
https://forum.vestacp.com/
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)
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`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 ?
Code: Select all
mysqlcheck -A --auto-repairOh, 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
mestresan wrote:I think the error is in my.cnf ... package size... change variable
max_allowed_packet = 256M
put high value if necessary...
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