I've forgot to mysqldump one of my databases. But I have files in /old_linux/var/lib/mysql/mydatabase Could I just move it to /var/lib/mysql and it will work? Should I do something more?
Hey mr_dean I am pretty sure that I was able to move the old data to the new data spot before and it worked. As long as you get all the proper files and the Mysql is the same version. I also think I had to redo the permissions but it did work for me.
unfortunately, MySQL isn't the same version . I will try to see does it go with cp and chown, if not, won't use them
Figured there was a logical reason. Copying the folder should work, unless versioning becomes a problem. Failing that... Do you know anyone that has a server with the same mysql version as your old one? If so, you could tar the directory, move it to a public_html folder, wget it to a buddy's server with the same mysql version, have them copy it to their lib directory, then run the dump for you. Bit of a work-around, which should work ... never had this happen before What version is the old and new?
I used to have CentOS4 and there comes 4.0.x. I've changed mainboard and Linux weren't able to mount / properly when booting. I've googled the problem and seen some people aren't be able to fix it. I tried to modify /etc/mtab and /etc/fstab /boot/grub/grub.conf to make it boot properly. Didn't work. Than I deleted one partition and I've installed Ubuntu Edgy (6.10). I'm quite satisfied for my needs but I've installed 64bit version and now default Java don't work properly and I don't have flash plug-in. Avoid 64bit version of Linux, still. Thank for your effort guys!