How to save data
Posted: Mon Nov 06, 2017 9:36 am
Hello.
I have files with database and files of the site.
BUT i cant restore database complitely...
Where i have a mistake?
I install vestaCP on Debian 8, then add some sites and create some empty databases (my_db).
Then i copy the same named files above empty databese and go to phpmyadmin.
I can see there for about 150 tables but i cant open it (wrong rights).
So i have changed rights to this folder and files to "chmode -R mysql:mysql /var/lib/mysql/my_db"
After if i can see only 30-37 tables and have access to half of them..
But, for example, in phpmyadmin search i can see all tables... But cant search in them...
HOW can i restore database complitely??
P.S.
When i get debian and install apache +php5+mysql+phpmyadmin and go to the phpmyadmin...
Create database and copy my database above empty i get the same result..
I have files with database and files of the site.
BUT i cant restore database complitely...
Where i have a mistake?
I install vestaCP on Debian 8, then add some sites and create some empty databases (my_db).
Then i copy the same named files above empty databese and go to phpmyadmin.
I can see there for about 150 tables but i cant open it (wrong rights).
So i have changed rights to this folder and files to "chmode -R mysql:mysql /var/lib/mysql/my_db"
After if i can see only 30-37 tables and have access to half of them..
But, for example, in phpmyadmin search i can see all tables... But cant search in them...
HOW can i restore database complitely??
P.S.
When i get debian and install apache +php5+mysql+phpmyadmin and go to the phpmyadmin...
Create database and copy my database above empty i get the same result..