Ryfujk

How did passengers keep warm on sail ships?

how can a perfect fourth interval be considered either consonant or dissonant?

What aspect of planet Earth must be changed to prevent the industrial revolution?

Mortgage adviser recommends a longer term than necessary combined with overpayments

How to split my screen on my Macbook Air?

Did the new image of black hole confirm the general theory of relativity?

Is every episode of "Where are my Pants?" identical?

Road tyres vs "Street" tyres for charity ride on MTB Tandem

Didn't get enough time to take a Coding Test - what to do now?

First use of “packing” as in carrying a gun

Does Parliament hold absolute power in the UK?

Why did all the guest students take carriages to the Yule Ball?

Create an outline of font

How does this infinite series simplify to an integral?

What can I do if neighbor is blocking my solar panels intentionally?

Do warforged have souls?

How to remove this toilet supply line that seems to have no nut?

How to delete random line from file using Unix command?

University's motivation for having tenure-track positions

Can withdrawing asylum be illegal?

"... to apply for a visa" or "... and applied for a visa"?

Can a 1st-level character have an ability score above 18?

Was credit for the black hole image misattributed?

The following signatures were invalid: EXPKEYSIG 1397BC53640DB551

How backup and restore information_schema.views in mariaDB or replica views?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}

0

I have two servers running MariaDB(Master 10.2.16, slave 10.2.22) with many DBs, they should be full sync, I check the data in both servers (in more important tables) and they are sync. This is "show slave status":

        Slave_IO_Running: Yes

        Slave_SQL_Running: Yes

        Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update i

but the different is in information_schema.views, the master has 105 rows or records and the slave has 54 records or rows.

MariaDB [(none)]> select table_name from information_schema.views;

..

+-----------------------------------+

104 rows in set (0.03 sec)



MariaDB [(none)]> select table_name from information_schema.views;

..

+-----------------------------------+

54 rows in set (0.04 sec)

I try to backup and restore, information_schema.views but failed:

MASTER-SERVER$mysqldump -u root -p INFORMATION_SCHEMA views > MASTER.INFORMATION_SCHEMA.VIEWS.sql

and try to restore in slave but show a Access denied error,(the issue is not the password or privileges)

SLAVE-SERVER$mysql -u root -p INFORMATION_SCHEMA <MASTER.INFORMATION_SCHEMA.VIEWS.sql

Enter password: 

ERROR 1044 (42000) at line 22: Access denied for user 'root'@'localhost' to database 'information_schema'

I don't know how to make both servers sync the views? or how to restore views in slave?

database mariadb synchronization backup-restoration

share

asked 44 secs ago

OsirisOsiris

11

New contributor

Osiris is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I have two servers running MariaDB(Master 10.2.16, slave 10.2.22) with many DBs, they should be full sync, I check the data in both servers (in more important tables) and they are sync. This is "show slave status":

        Slave_IO_Running: Yes

        Slave_SQL_Running: Yes

        Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update i

but the different is in information_schema.views, the master has 105 rows or records and the slave has 54 records or rows.

MariaDB [(none)]> select table_name from information_schema.views;

..

+-----------------------------------+

104 rows in set (0.03 sec)



MariaDB [(none)]> select table_name from information_schema.views;

..

+-----------------------------------+

54 rows in set (0.04 sec)

I try to backup and restore, information_schema.views but failed:

MASTER-SERVER$mysqldump -u root -p INFORMATION_SCHEMA views > MASTER.INFORMATION_SCHEMA.VIEWS.sql

and try to restore in slave but show a Access denied error,(the issue is not the password or privileges)

SLAVE-SERVER$mysql -u root -p INFORMATION_SCHEMA <MASTER.INFORMATION_SCHEMA.VIEWS.sql

Enter password: 

ERROR 1044 (42000) at line 22: Access denied for user 'root'@'localhost' to database 'information_schema'

I don't know how to make both servers sync the views? or how to restore views in slave?

database mariadb synchronization backup-restoration

share

asked 44 secs ago

OsirisOsiris

11

New contributor

Osiris is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I have two servers running MariaDB(Master 10.2.16, slave 10.2.22) with many DBs, they should be full sync, I check the data in both servers (in more important tables) and they are sync. This is "show slave status":

        Slave_IO_Running: Yes

        Slave_SQL_Running: Yes

        Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update i

but the different is in information_schema.views, the master has 105 rows or records and the slave has 54 records or rows.

MariaDB [(none)]> select table_name from information_schema.views;

..

+-----------------------------------+

104 rows in set (0.03 sec)



MariaDB [(none)]> select table_name from information_schema.views;

..

+-----------------------------------+

54 rows in set (0.04 sec)

I try to backup and restore, information_schema.views but failed:

MASTER-SERVER$mysqldump -u root -p INFORMATION_SCHEMA views > MASTER.INFORMATION_SCHEMA.VIEWS.sql

and try to restore in slave but show a Access denied error,(the issue is not the password or privileges)

SLAVE-SERVER$mysql -u root -p INFORMATION_SCHEMA <MASTER.INFORMATION_SCHEMA.VIEWS.sql

Enter password: 

ERROR 1044 (42000) at line 22: Access denied for user 'root'@'localhost' to database 'information_schema'

I don't know how to make both servers sync the views? or how to restore views in slave?

database mariadb synchronization backup-restoration

share

asked 44 secs ago

OsirisOsiris

11

New contributor

Osiris is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

        Slave_IO_Running: Yes

        Slave_SQL_Running: Yes

        Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update i

MariaDB [(none)]> select table_name from information_schema.views;

..

+-----------------------------------+

104 rows in set (0.03 sec)



MariaDB [(none)]> select table_name from information_schema.views;

..

+-----------------------------------+

54 rows in set (0.04 sec)

SLAVE-SERVER$mysql -u root -p INFORMATION_SCHEMA <MASTER.INFORMATION_SCHEMA.VIEWS.sql

Enter password: 

ERROR 1044 (42000) at line 22: Access denied for user 'root'@'localhost' to database 'information_schema'

share

asked 44 secs ago

OsirisOsiris

11

New contributor

Osiris is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 44 secs ago

OsirisOsiris

11

New contributor

Osiris is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 44 secs ago

OsirisOsiris

11

New contributor

Osiris is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 44 secs ago

OsirisOsiris

11