OVH Community, your new community space.

mysql restore with files

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.

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.?

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.

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?

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

and database directorys with frm etc.


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?

31-01-2015, 18:06

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