Laravel artisan migrate crashes database

Asked Oct 22 '18 at 05:12

Active Oct 22 '18 at 05:12

Viewed 457 times

I created a migration for a table which has over 2 million records. migration is adding a new column to that table as follow.I am using vagrant as my environment.

Schema::table('tb_selection', function(Blueprint $table) {
            $table->tinyInteger('retired_flag')->after('display_flag')->default(0);
        });

when i ran php artisan migrate, it keeps still and doing nothing. then it throws error

error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

then i checked my database and it is crashed. no tables were there. i had to import the DB again. what can be the solution for this?

asked Oct 22 '18 at 05:12

Deemantha

did you run the php artisan migrate command while connected to ssh? – kapitan Oct 22 '18 at 05:15
You can check out this [link](https://stackoverflow.com/questions/11990708/error-cant-connect-to-local-mysql-server-through-socket-var-run-mysqld-mysq) for help – kellymandem Oct 22 '18 at 05:15
You need to check mysql error logs to find out what went wrong. – Shadow Oct 22 '18 at 05:36
Please do check you started mysql service: "sudo service mysql start" without quotes – DPS Oct 22 '18 at 06:41
@kapitan yes mate – Deemantha Oct 23 '18 at 08:04
@DPS tried but it gives error error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' – Deemantha Oct 23 '18 at 08:04

Laravel artisan migrate crashes database

0 Answers0