I have a Laravel 9 project and in the migration of one of the tables, I would like to insert some data as well when creating the table: public function up() { Schema::create('tag_filters', function (Blueprint $table) { $table->id(); $table->string('tag_name'); $table->string('tag_uri')->nullable();…
I'm trying to create foreign keys in Laravel however when I migrate my table using artisan i am thrown the following error: SQLSTATE[HY000]: General error: 1005 Can't create table `bright`.`carts` (errno: 150 "Foreign key constraint is incorrectly formed") (SQL: alter…
I transfer my client's CMS from a domain to another domain. I also change the directory where CMS was installed. CMS in old domain was installed in client's subdirectory and in new domain is in wwwroot. I would like not…
Team, We have working flyway docker image (flyway community edition version 6.x) setup for postgresql 11.x version working. After upgrading our postgresql version to 14.x and now the existing flyway migration scripts (with updated community edition version 8.x) were failing…
How can I easily change MongoDB documents on a production database? Having a small downtime is not a dealbreaker for me. I want to change for example from... export const paintingSchema = new Schema({ design: string, }); to export const…
I have some S3 buckets in one AWS account which have large amount of data (50+ Tbs) I want it to move it to new S3 buckets in another account completely and use the 1st AWS account for another purpose.…
I am working on a sensitive migration. The scenario is as follows: I have a new table that I need to populate with data There is an existing table, which contains a column (type = json), which contains an array…
I have set up a migration file: use IlluminateDatabaseMigrationsMigration; use IlluminateDatabaseSchemaBlueprint; use IlluminateSupportFacadesSchema; class LogggingTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::connection('mysql2')->create('webServiceLogs', function (Blueprint $table) { $table->bigIncrements('id'); $table->timestamps(); $table->string('query');…
I was following this blog https://wanago.io/2022/07/25/api-nestjs-database-migrations-typeorm/ to setup migrations in my nestjs project but got the error that dataSourceFileExport i.e DataSource object exported from the migration.config.ts is not iterable. And I don't know why it's not iterable. I couldn't find…
I have a Wordpress site that I developed with Local and has localhost url. I got a new hosting plan and domain name and I successfully pointed the domain to the new hosting. I tried to do the migration and…