There is a database, there are tables in it, but I can’t withdraw from it, dosent not exist, why?

Question

MySQL

Good evening, how to transfer the database from Windows to ubuntu?
I tried here myself, but something went wrong, who knows, explain, I will be grateful . Thank you
There is a database on Windows, mysql is there, I need to take it and transfer it to ubuntu, what I did: I
copied the entire database folder on Windows and pasted it on ubunte in var/lib/mysql (where all the bases lie)
Rights to the base gave everything.
In mysql, SEE this database, SEE all the tables in it, but when you enter a banal SELECT * FROM command, it says that there is no such table !!!

Answer 1

You can't do that.
The transfer process looks like this:

• You need to dump the database using mysqldump databasename > filename (or another tool like phpmyadmin, heidisql, etc.)
  
• Create a database on a new machine, optionally create a user with access to it.
  
• Upload the dump to a new machine, and upload the dump: mysql databasename < filename (or again, use other means that allow you to upload dumps).