Skip to content

Second-cup-of-coffee

Web Development

Category: MySQL

Importing a MySQL Dump with Bad Dates

A problem that I run into fairly regularly when transferring older sites to my local environment is that, when importing the MySQL dump, I get an error like: ERROR 1292 – Incorrect date value: ‘0000-00-00’ It seems that, prior to version 5.7, MySQL used to allow invalid dates like 0000-00-00. However, this behavior changed in… Continue reading Importing a MySQL Dump with Bad Dates

Published December 27, 2021
Categorized as MySQL, Web Development

Recent Posts

  • Using Flexbox and Pseudo Elements for Text Between Lines
  • Programmatically Adding a Menu Item to a WordPress Menu
  • Hiding empty paragraphs
  • Importing a MySQL Dump with Bad Dates
  • Adding the Page Order to the Page List in the WordPress Admin

Recent Comments

  • John on Creating Unique IDs for ACF Repeaters
  • Mark on Creating Unique IDs for ACF Repeaters
  • David on Using an SVG Icon for a WordPress Custom Post Type
  • David on WordPress Plugin for the BotMan Web Widget
  • Ian on Creating Unique IDs for ACF Repeaters

Archives

  • January 2023
  • April 2022
  • February 2022
  • December 2021
  • November 2021
  • May 2021
  • April 2021
  • February 2021
  • January 2021
  • December 2020
  • July 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • March 2019
  • January 2018
  • October 2017
  • September 2017
  • August 2017
  • June 2017
  • May 2017
  • October 2016
  • March 2016
  • November 2015
  • July 2015
  • June 2015
  • February 2014
  • January 2014
  • July 2013
  • June 2013
  • May 2013
  • March 2013
  • January 2013
  • December 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012

Categories

  • CodeIgniter
  • CSS
  • Javascript
  • Macintosh
  • Movies
  • MySQL
  • PHP
  • Quick Tip
  • TextMate
  • Uncategorized
  • Unix
  • Web Development
  • WordPress
Second-cup-of-coffee
Privacy Policy
Proudly powered by WordPress.