I’ve used MySql for a number of years and never incurred an error with mysqldump until today. Fortunately there is an easy solution to the problem.
mysqldump: Error 1194: Table ‘comments’ is marked as crashed and should be repaired when dumping table `comments` at row: 12o
MySql provides a “repair table `table_name`” command to fix it. In my case I logged into the mysql database and executed the following commands.
mysql> use mydb;
mysql> repair table `comment`
Create a User Defined Variable and initialize the value. In this case the value is zero.
Here’s an example of incrementing the “my_counter” value in an HTTP request. The request URL will include the name value pair: counter=1
Transient properties are useful to carry additional meta data in a domain class without a direct database mapping required. Transient properties can be useful to handle read only information queried from multiple databases.
- static transients = [‘manuf’, ‘make’, ‘model’]
- String manuf
- String make
- String model