Consider the following situation.
I currently have an Ubuntu installation installed in my Virtual Machine. This installation has mysql installed in it.
Data for the mysql-server can be found under;
/var/lib/mysql
A default installation contains;
Folder "mysql"
Folder "performance_schema"
ibdata + ib_logfiles
mysql_upgrade_info
Someone recently supplied me with a folder with this exact same structure, containing data. How can I succesfully implement the folder that I've received into the "clean installation"? Plain copying didnt work since it caused all kinds of permission issues. Is there any way to succesfully extract the data in the ibdata files, to my new mysql installation? The engine used is InnoDB. I'm just interested in viewing the actual content of this database. If there's any sort of viewer available to quickly have a "peek" in this structure, that would come in handy too.