Stack Overflow
Stack Overflow

Questions tagged [mysqlcheck]

12 questions
2
votes
1 answer

MySQL: mysqlcheck taking too much disk space to perform operations

Every saturday at 8am I've the following sh script which makes a maintenance on all my databases. I run a mysqlcheck with --check, --optimize and --analyze. This is the script: # check: checks table for integrity errors mysqlcheck -u root -h…
Avión
  • 7,963
  • 11
  • 64
  • 105
2
votes
2 answers

How to skip a database in mysqlcheck

There's a command to optimize and repair all databases mysqlcheck --user=root --password=PASSWORD_FOR_ROOT --auto-repair --optimize --all-databases How can I skip the database from this process? --skip-database=DATABASE_NAME seems don't work
Stas Ponomaryov
  • 103
  • 11
1
vote
1 answer

What is the alternative of mysqlcheck in python3?

I need to use mysqlcheck cmd for optimizing tables in the database. I've created a Lambda function in python for the whole process, now to execute the whole process first I need to optimize all tables of the database. I'm using PyMSQL module in…
manish soni
  • 515
  • 1
  • 7
  • 19
1
vote
1 answer

WP CLI Claims DB Needs Repairing but WP Itself Works

I use wp-cli in my deploy/upgrade script. I'm currently getting the following error from wp core is-installed (first command my script does with wp cli) Error: One or more database tables are unavailable. The database may need to be repaired. So I…
Adam
  • 6,539
  • 3
  • 39
  • 65
1
vote
1 answer

mysqlcheck won't repair tables (errno: 2)

I'm trying to repair some corrupted tables throught mysqlcheck command, but it returns the following "errno 2" error: # mysqlcheck -u user -p --repair database Enter password: database.users OK database.notes Error …
AngeLOL
  • 106
  • 2
  • 9
1
vote
1 answer

mysqlcheck return error message mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect

I am doing mysqlcheck command such as root@com-dev:/var/lib/mysql# mysqlcheck databasedirectory and you would think root will have access to any file system, but it returns this error message not sure what to do. mysqlcheck: Got error: 1045:…
Dung
  • 19,199
  • 9
  • 59
  • 54
0
votes
0 answers

Query got stuck while we fetch for specific timestamp

I have a TableA with data around 1.4Billion which was partitioned by timestamp. TableA ( Column1, Column 2....Column N, timestamp) Partition by times I was able to see a weird behavior recently on this table where querying specific timestamp ended…
ragul rangarajan
  • 167
  • 2
  • 12
0
votes
1 answer

MySQL crash while mysqldump / mysqlcheck

everytime I try to backup or check all tables mysql server crashes on Windows server 2012, I am using XAMPP stack for my development environment. The database crypto has more then 1100+ tables in DB. I am including the logs below. InnoDB: End of…
Vishal Patel
  • 33
  • 7
0
votes
1 answer

What would be the minimum priveledges required to check/fix crashed MySQL tables

I'm using the mysqlcheck command for an automated script. I want to give, the user running the script, the minimum permissions required to be able to successfully run the command with the --all-databases and --repair arguments.
Ryan
  • 269
  • 1
  • 3
  • 15
0
votes
1 answer

How to Repair MySQL InnoDB Table That Has Issues?

Our company is using SailPoint IIQ for its IAM solution. When trying to run: delete IdentityRequest * I get an error of sailpoint.tools.GeneralException: null index column for collection: sailpoint.object.IdentityRequest.items Doing a select *…
James Oravec
  • 19,579
  • 27
  • 94
  • 160
0
votes
0 answers

mysqlcheck returns Errors

I have 4 MySQL database VMs, all with the same HD/RAM schemas. Server version: 5.6.27 - MySQL Community Server (GPL) I ran the mysqlcheck command on each Machine: $ mysqlcheck -u USERNAME -pPASSWORD --auto-repair --check --all-databases Btw,…
coffeemonitor
  • 12,780
  • 34
  • 99
  • 149
-1
votes
1 answer

how can I verify that each row of a table is associated with at least one row of another table in MySQL?

I'm trying to verify that in a table of my DB each row is associated with at least one row of another table. In particular I have these 3 tables: CREATE TABLE IF NOT EXISTS coltraneShop.Personage ( `Name` VARCHAR(20) NOT NULL, CONSTRAINT…
user9165701