1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

mysql max_execution_time

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

  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.
    SEMrush
    $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
    SEMrush
  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