Apache Friends Support Forum

hey all,

i've reinstalled my OS and lampp and i'm trying to restore MySQL databases.

i've tried to copy the database folders from the old /opt/lampp/var/mysql to the new one,
but all i can see in phpmyadmin is empty dbs.

i've tried to add datadir=/opt/lampp/var/mysql/somedb to my.cnf
and MySQL failed to start, so i had to rollback.

what else is there to restore the dbs??

thanx

did you back them up originally with either mysqldump or phpMyAdmin? (so that you now have either .sql or .sql.gz files)

(generally copying DB folders is a poor, poor idea and rarely works as database files are really containers.)

I guess a really good question also is 'what the h is in those MYSQL files'??? LOL. are they 'roll your own' or from scripts etc???

Good luck