MySQL reset master server

circus78 · 07-31-2013, 01:37 PM

Hi,
how can I completely reset a MySQL master server?
I mean, I need to import a previous backup and start from a new point.
Should I only type "reset master" on MySQL console?
I need to manually delete all the previous bin log file in /var/lib/mysql directory?

Thank you!

YankeePride13 · 07-31-2013, 03:32 PM

Just import the database dump that you have, it will overwrite the data that exists.

circus78 · 08-02-2013, 04:15 AM

Quote:

Originally Posted by YankeePride13

Just import the database dump that you have, it will overwrite the data that exists.

Ok for MySQL databases, but what about binary log (master-bin.0000x and mysql-relay.bin.0000x)? Can I safely delete them?
I'd prefer to start with the "cleanest" server as possible
Thank you