As title, MySQL version 8.0.11 X64, centos6.9
Mysql encountered error was heavy.
When the backup data without mysqldump also did not open the binlog, directly under the cp/var/lib/mysql file, reinstall 8.0.11, cp to the backup file to the/var/lib/mysql. Starts, however, cannot use.

 
Yes | cp -r/var/WWW/HTML/data_bak/var/lib/mysql/
Chown -r mysql: mysql/var/lib/mysql/data_bak 
Sudo chmod -r 0640/var/lib/mysql/data_bak/
Chmod 0750/var/lib/mysql/data_bak/

 
mysql> Select * from information_schema. ` TABLES ` where TABLE_SCHEMA='data_bak'; 
The Empty set (0.00 SEC) 

mysql> Show the databases; 
+ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- + 
| Database | 
+ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- + 
| information_schema | 
| mysql | 
| performance_schema | 
| sys | 
+ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- + 
4 rows in the set (0.00 SEC) 

Can't see the backup library
Consult everybody bosses have such questions, help to solve the grateful! ~
This operation under 5.1, 5.5, 5.7 can be normal use, 8.0.11 a little meng circle..

CodePudding user response:

Myisam can directly copy the innodb engine is designed to a table space

CodePudding user response:

reference 1st floor weixin_40579234 response:

myisam can directly copy the innodb engine is designed to a table space

hello, myisam is file, deny, cp after mysql under 8.0.11 version to solve!

CodePudding user response:

Backup of the library is on the right below the datadir?

CodePudding user response:

Normal is can't play the default innodb engine is the engine of the metadata in the system tablespace, every idb files in the corresponding SCN, had better use innobackup to backup or mysqldump then

CodePudding user response:

The

reference 3 floor crynono response:

backup library is on the right below the datadir?

right, the file path is/var/lib/mysql user account group also is mysql.

In version 5.7, continue to not want to ask what, 8.0 this way backup restore faster dump slow

CodePudding user response:

Myisam database can be directly copied, innodb, there is also a space_id need consistent to normal

CodePudding user response:

refer to 6th floor weixin_40579234 response:

myisam database can be directly copied, innodb, there is also a space_id need to agree to normal

hello, mysql8.0 direct copy is not enough..

CodePudding user response:

The building Lord solve have no? How can directly copy to 8.0 database identified,

CodePudding user response:

refer to the eighth floor superfans98 response:

I solve? How can directly copied to 8.0 database,

? Yes, temporarily gave up...

CodePudding user response:

Heavily armoured, there may be some documents to support the registry,

CodePudding user response:

references to the tenth floor herrsching root moss Ken 0937 response:

reshipment, there may be some documents to support the registry,

Sorrow people, is now two mysql co-exist but not running at the same time, need data from the old database mysqldump, again into a new,,,