Description:
I ran the following simple test script:
USE test;
CREATE TABLE t (i INTEGER);
INSERT INTO t VALUES (1), (2), (3);
BACKUP DATABASE test TO 'tmp.bak';
RESTORE FROM 'tmp.bak' OVERWRITE;
SELECT * FROM t;
I got the following output:
USE test;
CREATE TABLE t (i INTEGER);
INSERT INTO t VALUES (1), (2), (3);
BACKUP DATABASE test TO 'tmp.bak';
backup_id
270
RESTORE FROM 'tmp.bak' OVERWRITE;
backup_id
271
Warnings:
Warning 1738 The grant 'ALTER ON test.*' for the user ''@'%' was skipped because the user does not exist.
Warning 1738 The grant 'CREATE ON test.*' for the user ''@'%' was skipped because the user does not exist.
Warning 1738 The grant 'CREATE ROUTINE ON test.*' for the user ''@'%' was skipped because the user does not exist.
Warning 1738 The grant 'CREATE TEMPORARY TABLES ON test.*' for the user ''@'%' was skipped because the user does not exist.
Warning 1738 The grant 'CREATE VIEW ON test.*' for the user ''@'%' was skipped because the user does not exist.
Warning 1738 The grant 'DELETE ON test.*' for the user ''@'%' was skipped because the user does not exist.
Warning 1738 The grant 'DROP ON test.*' for the user ''@'%' was skipped because the user does not exist.
Warning 1738 The grant 'EVENT ON test.*' for the user ''@'%' was skipped because the user does not exist.
Warning 1738 The grant 'INDEX ON test.*' for the user ''@'%' was skipped because the user does not exist.
Warning 1738 The grant 'INSERT ON test.*' for the user ''@'%' was skipped because the user does not exist.
Warning 1738 The grant 'LOCK TABLES ON test.*' for the user ''@'%' was skipped because the user does not exist.
Warning 1738 The grant 'REFERENCES ON test.*' for the user ''@'%' was skipped because the user does not exist.
Warning 1738 The grant 'SELECT ON test.*' for the user ''@'%' was skipped because the user does not exist.
Warning 1738 The grant 'SHOW VIEW ON test.*' for the user ''@'%' was skipped because the user does not exist.
Warning 1738 The grant 'TRIGGER ON test.*' for the user ''@'%' was skipped because the user does not exist.
Warning 1738 The grant 'UPDATE ON test.*' for the user ''@'%' was skipped because the user does not exist.
SELECT * FROM t;
i
1
2
3
How to repeat:
See description.