File manager - Edit - /opt/dedrads/mysql/__pycache__/myisam_repair.cpython-313.pyc
Back
� z �i � � � S r SSKrSSKJr SSKrSSKrS rS\S\S\4S jr S r S r \ S :X a \ " 5 gg! \ a gf = f) zMass MyISAM table fixer� N)�Pathc # � # � [ S5 R 5 H( n U R 5 ( d M U R v � M* g7f)z&Iterate over folders in /var/lib/mysqlz/var/lib/mysqlN)r �iterdir�is_dir�name)�entrys �#/opt/dedrads/mysql/myisam_repair.py�iter_databasesr s5 � � � �&�'�/�/�1�� �<�<�>�>��*�*� � 2�s �0A �A �database�tmpdir�returnc � � [ U5 R SSSS9 [ R " SU S35 =n( a [ S[ U5 SU 35 O [ SU 5 gSnU HJ n[ S U- 5 [ R " S S S S X/S[ R [ R S9 ML U$ ! [ R a Sn Mi f = f)zRuns a repair on a tablei� T)�mode�exist_ok�parentsz/var/lib/mysql/z/*.MYIzFixing z tables in database z#No MyISAM tables to fix in databasez Fixing %s� myisamchkz-rz-q�-t)�check�stderr�stdoutF) r �mkdir�glob�print�len� subprocess�run�DEVNULL�CalledProcessError)r r �tables�repaired�tables r �repair_databaser" s� � ���L���E�D�$��?����_�X�J�f�=�>�>�v�>� ���F� �}�$8�� �C�D� �3�X�>���H��� �o��%�&� � �N�N� �d�D�$��>��!�)�)�!�)�)� � � �O�� �,�,� � �H� �s �:8B8�8C�Cc �� � [ 5 n U R SL a& [ 5 H n[ XR 5 M U R ( a! [ U R U R 5 gg)zDefault functionTN)� parse_args� repair_allr r" r r )�args�dbnames r �mainr( - sL � � �<�D� ���$� �$�&�F� �F�K�K� 0� '� �}�}��� � �t�{�{�3� � c �� � [ R " [ S9n U R SS9nUR SSSSSS 9 UR S S S S S9 U R SSSSS9 U R 5 $ )z"Defines valid command line options)� descriptionT)�requiredz-az--allr% � store_truezRepair all databases)�dest�action�helpz-dz --databaser z)The name of a specific database to repair)r. r0 r z--tmpdirr z /root/tmp)r. �default)�argparse�ArgumentParser�__doc__� add_mutually_exclusive_group� add_argumentr$ )�parser�groups r r$ r$ 8 s� � � � $� $�� 9�F� � /� /�� /� >�E� ��� �g�L� � #� � � ��� �l�� 8� � � ����j�x���M� � � � � r) �__main__)r4 r �pathlibr r2 r r �str�boolr" r( r$ �__name__�KeyboardInterrupt� r) r �<module>r@ sl �� � � � � � ��c� �3� �4� �04� �$ �z�� � �� �� � � � �s �9 �A�A
| ver. 1.4 |
Github
|
.
| PHP 8.3.31 | Generation time: 0 |
proxy
|
phpinfo
|
Settings