Moving MySQL Database to a new computer

[noff]

I am trying to move my db to my new computer. I really know nothing of databases (this is for mythtv). I don't know how to copy it to a new computer and not lose all of my info.
_________________
What Larry was saying is that if you make it too easy for programmers, then poor programmers will be able to do things best left to good programmers, and will inevitably do them poorly. Everyone will suffer in the long term as a result." - Tom Chance

[ikaro]

If you have phpmyadmin, you can dump/export the whole thing into a file and the import it from the new location.

If you dont have phpmyadmin, iam affraid i cant say the exact command how to do it, however i think if you search a little bit on google for export database or something similiar you will probably find some clues.

maybe someone else knows ?

[Janne Pikkarainen]

If the new computer has a same version of MySQL, you can simply copy the contents of /var/lib/mysql/ (or whatever is the location for your database files) to the new computer and everything's working fine.

But more official way to backup and restore MySQL databases is to use mysqldump, which dumps your databases to text file, which you can later load back to database with