Skip to main content
1 vote
Accepted

Duplicating tables from database1 to database2 LIKE on same server fails, error 1064

EXPLAIN doesn't support CREATE TABLE the supported commands are: EXPLAIN tbl_name [col_name | wild] Or EXPLAIN [EXTENDED | PARTITIONS | FORMAT=JSON] {SELECT select_options | UPDATE update_options | ...
nbk's user avatar
  • 8,490
1 vote

MariaDB 10.7 to 10.5 replication issue with DROP DATABASE

Incorrect definition of table mysql.event This kind of error normally indicates that the DB that is throwing the error has been upgraded and not had mysql_upgrade run on it. The rest of the error I'd ...
Phil Sumner's user avatar
  • 1,897
1 vote
Accepted

Dynamically populate table values for migrating data

Thanks to Ergest Basha and nbk for their helpful comments I was able to copy newer records to an older database without complications or problems by using: INSERT IGNORE INTO $db1.$table SELECT * FROM ...
John's user avatar
  • 737
1 vote
Accepted

Merge old and new versions of the same MariaDB database

If you're willing to do an extra query per table you can completely drop the IGNORE syntax and get results with zero warnings via SHOW WARNINGS;: INSERT INTO $database1.$table SELECT * FROM $...
John's user avatar
  • 737
1 vote
Accepted

mysql - show all users/hosts with privileges to access a certain database

Is there a way in which I can provide the database in the request? And then get all different users that have been granted access to that db in a single shot? You can use the mysql.db table which ...
Ergest Basha's user avatar
  • 4,025
1 vote

MariaDB Crashes Every Time Restarted

I was having a similar problem, except I was getting [ERROR] InnoDB: Missing FILE_CHECKPOINT(10514035995) at 10514035995. Would completely reinstall mariadb with brew, it would run fine, but after ...
Krislunde's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible