dbsake
dbsake copied to clipboard
Collection of mysql tools
In MariaDB versions 10.4 onwards, it looks like all mysqld* scripts have been symlinked to mariadbd* or mariadb-*: [root@1155792-slave1 bin]# ls -ltr mysql* lrwxrwxrwx. 1 root root 14 Feb 1...
Per the title, if you create an InnoDB table with page_compressed=1 table option then frmdump doesn't decode this option from the .frm file.
I'm trying to extract the schema data from .frm files. It works perfectly for most tables but I have one file that gives me the following error : Uncaught exception!...
I'm using your excellent tool to extract the schema data from the `.frm` files of a database to recreate it on another server (the plan is to have a disaster...
i have read your document: The first bit is always set and column bits start a 1 offset in the null map. If a bit is set for the current...
``` # pon4ipay@DESKTOP-347OOI8:~$ sudo ./dbsake frmdump --type-codes ./db/users_data.frm Uncaught exception! (╯°□°)╯ ︵ ┻━┻ Traceback (most recent call last): File "./dbsake/dbsake/core/mysql/frm/mysqltypes.py", line 298, in unpack_default return dispatch(defaults, context) File "./dbsake/dbsake/core/mysql/frm/mysqltypes.py", line...
Right now sieve --defer-foreign-keys takes a CREATE TABLE statement and extracts out the foreign key definitions. These are then emitted after the table data is loaded along with another other...
The logic exists to track !include/!includedir directives in dbsake.core.mysql.mycnf.parser but the front-end returns the first result and just stops without processing the remaining entries. This seems to be a simple...
I've been asked a few times to allow frmdump to search existing frms. Namely looking for things like certain column types (i.e. old DATE/TIME types) or no primary keys. Frms...
The ability to import settings from say a file or even a datasourse to the sandbox's my.sandbox.cnf file could be useful to automatically provision custom sandboxes in the "creation" phase...