OVH Community, your new community space.

mysql restore with files


ramcom
01-02-2015, 09:34
log file mysql after /var/lib/mysql copied with backup

150201 9:30:29 InnoDB: Initializing buffer pool, size = 8.0M
150201 9:30:29 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242871 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
150201 9:30:29 [ERROR] Plugin 'InnoDB' init function returned error.
150201 9:30:29 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
150201 9:30:29 [Note] Event Scheduler: Loaded 0 events
150201 9:30:29 [Note] /usr/libexec/mysqld: ready for connections.

ramcom
01-02-2015, 07:25
Thanks for reply
i do have only backup /var/lib/mysql
When i copy all over and restart mysql i have acces to my old db but innodb tables aren't working.?

heise
31-01-2015, 23:18
A simple file copy is not the right way to backup mysql. Google how to repair your DB. I hope you also copied the setup file and they are identical. Further I hope your config files didn't change.

freshwire
31-01-2015, 21:41
You said you cannot access phpmyadmin. If that's not the issue then what is? You already said you replaced the database files. Are you able to see the databases if you connect using the mysql command line?

ramcom
31-01-2015, 21:03
thats not the point i want restore my database i have all files
ib_logfile0
ib_logfile1
ibdata1

and database directorys with frm etc.

help

freshwire
31-01-2015, 20:10
but now i can't reach phpmyadmin .
This is a separate web based tool. Did you install it too? If so, what error do you get?

ramcom
31-01-2015, 18:06
hello

after my server is crashed did i a copy into rescue mode . so i have now mysql files ibdata1 ib_logfile0 ib_logfile1 and tables
i did a cleaninstall on server after this stopped mysql and replaced with old files after this restart mysql but now i can't reach phpmyadmin .

any suggestions?

thanks by advance