dolt icon indicating copy to clipboard operation
dolt copied to clipboard

Drop revision database from SQL

Open tbantle22 opened this issue 1 year ago • 0 comments

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

tbantle22 avatar Aug 05 '22 22:08 tbantle22