I need to back up some of my databases and migrate them over to a new server.
I would use mysqldump , but the problem is that I'm having issues starting mysqld/mysql (part of the reason I'm migrating). I kept getting
# /etc/init.d/mysqld start MySQL Daemon failed to start. Starting mysqld: [FAILED]
Basically, I was on a media temple dv server and I used yum to try and upgrade stuff and that messed up a bunch of configuration because mediatemple didn't use yum originally to install mysql, php, etc...
ANYWAY, thankfully it appears my old tables are still around (I can see them in
my question is:
Is it possible for me to somehow migrate the files that are in my
/var/lib/mysql to my new server? I was thinking I could possibly just "copy and paste" them into my new server's
/var/lib/mysql directory... Would that theoretically work?
Or do I have any other options to move the tables?
I'm on CentOS.