Timezone missing in mysql database (celery periodic task)

-

 Ref: https://stackoverflow.com/questions/21351251/database-returned-an-invalid-value-in-queryset-dates#21571350

You have to load timezone tables into mysql (http://dev.mysql.com/doc/refman/5.6/en/mysql-tzinfo-to-sql.html). Try execute on your database server:

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -D mysql -u root -p

And then run "flush tables" or "flush query cache", otherwise the problem may not disappear even though you've loaded the correct timezone data:

mysql -u root -p -e "flush tables;" mysql

Comments

Post a Comment

Popular posts from this blog

Generate SHA-1 and SHA-256 for Debug and Release android app

-
Go to the Root directory of the project and generate on Terminal. Debug SHA-1 and SHA-256:      keytool -list -v -keystore ~/.android/debug.keystore -alias androiddebugkey -storepass android -keypass android Release SHA-1 and SHA-256: keytool -list -v -keystore /home/than/flutterProjects/PlayStoreKeystore/farm_to_retail.jks - alias key0
Read more

Transfer file to Server and vice versa

-
Local to Server:   scp -P 2222 /absolute_path/source-folder/some-file user@example.com:/absolute_path/destination-folder Server to Local: scp -P 2222 u ser@example.com:/absolute_path/destination-folder /absolute_path/source-folder/some-file How do I extract tar.xz files in Linux? The syntax is: Install xz using the  dnf install xz  on a CentOS/RHEL/Fedora Linux. Debian/Ubuntu Linux users try  apt install xz-utils  command. Extract tar.xz using the  tar -xf  backup.tar.xz  command To decompress filename.tar.xz file run:  xz -d -v  filename.tar.xz
Read more

How to Import and Export MySQL Database Command line in Linux

-
************ TO EXPORT ************ 1. SSH login as root. 2. Run command   mysqldump -a -u ejobsolution_db_user --password= db_password ejobsolution_db > ejobsolution_db.sql Download ejobsolution_db.sql from root directory Reference:  https://webhostinggeeks.com/howto/import-and-export-mysql-database-command-line-in-linux/ Reference:  https://archive.virtualmin.com/node/6032 How to Export MySQL Database Command line in Linux 1. Syntax to Export: mysqldump -u USERNAME -p DATABASE_NAME > filename.sql How to Export MySQL Database Command line in Linux 2. Syntax to Import: mysql -u USERNAME -p DATABASE_NAME < filename.sql CREATE USER 'db_user'@'localhost' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON * . * TO 'db_user'@'localhost'; mysql -u db_user -p CREATE DATABASE db_name;
Read more