dolt
dolt copied to clipboard
Drop revision database from SQL
I want to drop a database at a commit, but getting a database not found error:
mysql> show databases;
+-------------------------------------------+
| Database |
+-------------------------------------------+
| coronavirus |
| information_schema |
| types |
| types/main |
| us_jails |
| us_jails/main |
| us_jails/tjj1kp2mnoad8crv6b94mh4a4jiq7ab2 |
| us_jails/tjj1kp2mnoad8crv6b94mh4a4jiq7ab2 |
+-------------------------------------------+
8 rows in set (0.04 sec)
mysql> drop database `us_jails/tjj1kp2mnoad8crv6b94mh4a4jiq7ab2`;
ERROR 1105 (HY000): database not found: us_jails/tjj1kp2mnoad8crv6b94mh4a4jiq7ab2
Also tried:
mysql> drop database 'us_jails/tjj1kp2mnoad8crv6b94mh4a4jiq7ab2';
ERROR 1105 (HY000): syntax error at position 58 near 'us_jails/tjj1kp2mnoad8crv6b94mh4a4jiq7ab2'
mysql> drop database "us_jails/tjj1kp2mnoad8crv6b94mh4a4jiq7ab2";
ERROR 1105 (HY000): syntax error at position 58 near 'us_jails/tjj1kp2mnoad8crv6b94mh4a4jiq7ab2'
mysql> drop database us_jails/tjj1kp2mnoad8crv6b94mh4a4jiq7ab2;
ERROR 1105 (HY000): syntax error at position 24 near 'us_jails'
Prevents the workaround for this issue for hosted instances, where I only have access to the sql server