restore MySQL for new lampp install

Problems with the Linux version of XAMPP, questions, comments, and anything related.

restore MySQL for new lampp install

Postby metalball2 » 25. January 2011 20:24

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
metalball2
 
Posts: 1
Joined: 25. January 2011 20:12

Re: restore MySQL for new lampp install

Postby JonB » 29. January 2011 01:32

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
8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 10 guests