mysql max_execution_time

Discussion in 'Databases' started by estevandido, May 11, 2020.

0
  1. #1
    mysql 5.7.
    I ran the following to backup a database in mysql and I get this error. Anyone knows why it won't complete? I ran the 2 statements on the Linux terminal.

    $mysql u p -e "SET local max_execution_time=0"

    $mysqldump u p labels > labels.sql

    mysqldump: Error 3024: Query execution was interrupted, maximum statement execution time exceeded when dumping table `abels` at row: 400325
     
    estevandido, May 11, 2020 IP
  2. actionspec

    actionspec Greenhorn

    Messages:
    10
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    13
    #2
    Try setting 

    $ mysql u p -e "SET local max_execution_time=0"
    Code (markup):
    To: 

    $ mysql u p -e "SET global max_execution_time=0"
    Code (markup):
    Is this on a RedHat/CentOS install by chance?
     
    actionspec, May 12, 2020 IP