Why isn't Django returning a datetime field from the database?

For my first Django app, I'm trying to write a simple quote collection site (think bash.org), with really simple functionality, just to get my feet wet. I'm using sqlite as my database, since...

What is the fastest way to load an XML file into MySQL using C#?

Question What is the fastest way to dump a large (> 1GB) XML file into a MySQL database? Data The data in question is the StackOverflow Creative Commons Data Dump. Purpose This will be used in an...

create dump file from database in mysql

following is the that I create dump from mysql database. mysqldump -u root tempbkk > ttt.dump but I want to create a dump that exclude one or more file while creating dump from database we...

Using pg_dump to only get insert statements from one table within database

I'm looking for a way to get all rows as INSERT statements from one specific table within a database using pg_dump in PostgreSQL. E.g., I have table A and all rows in table A I need as INSERT...

Liquibase, "Migration Failed: Java heap space" error when generateChangeLog with "data"

I am trying to create a baseline on one of my development database using liquibase, here's my environment Database, -> Oralce 10g, with 500+ Tables with lots of configuration data, the oracle...

On the fly anonymisation of a MySQL dump

I am using mysqldump to create DB dumps of the live application to be used by developers. This data contains customer data. I want to anonymize this data, i.e. remove customer names / credit card...

How to use php artisan migrate command of Laravel4 in Heroku?

I am suing Heroku dev plan for creating database using PostgreSQL. Database is created in Heroku. After running heroku pg:info command $ heroku pg:info === HEROKU_POSTGRESQL_XXX_URL Plan: ...

How can I get a plain text postgres database dump on heroku?

Due to version incompatibilities of my postgres database on heroku (9.1) and my local installation (8.4) I need a plain text sql database dump file so I can put a copy of my production data on my...

Setting up MySQL and importing dump within Dockerfile

I'm trying to setup a Dockerfile for my LAMP project, but i'm having a few problems when starting MySQL. I have the folowing lines on my Dockerfile: VOLUME ["/etc/mysql", "/var/lib/mysql"] ADD...

Maria DB not starting. Job for mariadb.service failed. See 'systemctl status mariadb.service' and 'journalctl -xn' for details

I am trying to install maria db and getting the following issue. [[email protected] ~]# service mysqld start Redirecting to /bin/systemctl start mysqld.service Job for mariadb.service failed. See...

Django CMS how to create nested plugins programatically

I am writing a migration script to parse an old html website into Django CMS pages. The thing I need is to understand on how to nest plugins programatically. In particular case I need to have html...

Copying a postgres database from one server to another

I have a postgres database with a number of schemas and a number of tables within each of the schemas, and the tables have a bunch of foreign key relationships with one another. All I want to do...

How can I copy CMS pages from a development site to a live site?

I've been integrating Django CMS to a Django project that has been in production already for over a year. As part of my development activities, I've converted to CMS pages those pages that used to...

MySQLDump Backup of UTF-8 Database Has Character Corruption, But Default Charsets are Correct

When I'm trying to make a full dump of the database as follows: mysql --default-character-set=utf8 -uUSER -p database -r output.sql It creates a UTF-8 file but all international data...

pg_dump setting of sequences

I've recently started developing apps with PostgreSQL as backend DB (imposed on me) with no previous experience of Postgres. So far it hasn't been too bad, but now I run into a problem to which I...

Restoring the database dump of an older version of mongo to a new version of mongo

Currently, I have an older version of mongo, i.e 2.6 running on my system. I already have my site in production and have a lot of client data. I am planning an upgrade to mongo 3.2. So, my...

Restore database state after integration test using Docker?

We are using PostgreSQL along with EAR deployed to JBoss. During the build process we have a development database dump that is used then in integration test: special artifact is deployed and tests...

Symfony 3.2: OneToMany collection not initialized

Entity/User.php: // ... use Doctrine\Common\Collections\ArrayCollection; // ... /** * @var ArrayCollection * * @ORM\OneToMany(targetEntity="Picture",...

Steps to restore one table from impdp in oracle 10g

I need to import only one table from a full backup (expdp) to a newly create table on the same database. So can i import the table directly with a new name? or i have to create a new table first...

Docker Compose: MySQL Syntax Error "DELIMITER" On Line 1

I have the Problem that I want Docker Compose to directly import my Database.sql file after setting up MySQL. But it always throws me the Error: You have an error in your SQL syntax; check the...

php_network_getaddresses: getaddrinfo failed error in Docker's adminer

I have problem with access to adminer in my docker container with laravel 5/mysql app. I got error : SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name does not resolve My...

Azure Function App access to on-prem resource (Gateway?)

I have a requirement to use an Azure Function App to query data in an on-premise SQL database, extract that data, dump it to a blob. By these requirements ADF is not permissible. The on premise...

How to define the same field for load_only and dump_only params at the Marshmallow scheme?

I am trying to build a marshmallow scheme to both load and dump data. And I get everything OK except one field. For load data its type is Decimal. And I used it like this before. Now I want to use...

pg_restore: [archiver] unsupported version (1.14) in file header

I have a live server and development box, call them live and dev respectively both running postgresql. I can see both and manage both with pgadmin4 without trouble, and both are fully functional...

Job for mariadb.service failed because the control process exited with error code

i deleted and reinstall mariadb and i get this error: *"Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl...

Laradock mysqldump not found when executing artisan backup:run (Spatie Laravel Backup)

I have deployed a Laravel application with Laradock. I want to point out that the database connection works fine (users can register, login, ... etc.). In order to back up the application, I have...

Replace string in big sql file (15 go) bash

I have to replace this string in dump file : use clients_db; by use client; The name of database is different between the environment src and dest. I tried with using sed, but it doesn't work...

Rabbitmq on docker: Application mnesia exited with reason: stopped

I'm trying to launch Rabbitmq with docker-compose alongside DRF and Celery. Here's my docker-compose file. Everything else works fine, except for rabbitmq: version: '3.7' services: drf: ...

Laravel application hang on Google Cloud Run but runs fine on home setup

I am testing out Google Cloud Run as a platform to run a new project. Project is developed using NodeJS and Laravel. Created a docker images based on php-fpm. This image runs fine on my dev...