Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ALTER TABLE `dinoking`
- CHECKSUM=1,
- AUTO_INCREMENT=0;
- SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='dinokings';
- SHOW TABLE STATUS FROM `dinokings`;
- SHOW FUNCTION STATUS WHERE `Db`='dinokings';
- /* SQL Error (1728): Cannot load from mysql.proc. The table is probably corrupted */
- SHOW PROCEDURE STATUS WHERE `Db`='dinokings';
- /* SQL Error (1728): Cannot load from mysql.proc. The table is probably corrupted */
- SHOW TRIGGERS FROM `dinokings`;
- SELECT *, EVENT_SCHEMA AS `Db`, EVENT_NAME AS `Name` FROM information_schema.`EVENTS` WHERE `EVENT_SCHEMA`='dinokings';
- /* SQL Error (1577): Cannot proceed because system tables used by Event Scheduler were found damaged at server start */
- SHOW CREATE TABLE `dinokings`.`dinoking`;
- /* Entering session "dinoking" */
- SHOW CREATE TABLE `dinokings`.`dinoking`;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement