I have a project and I want to migrate the database files, but when I try to run the PHP artisan migrate command I get an error
I did a lot of searches, but I didn't get any useful results, please help me
it is my database file code:
<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateBlogTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('blogs', function (Blueprint $table) {
$table->id();
$table->integer('user_id');
$table->string('name');
$table->string('text');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('blogs');
}
}
and it is an error message
Migrating: 2022_07_12_122514_create_blog_table
Illuminate\Database\QueryException
SQLSTATE[HY000]: General error: 1 table "blogs" already exists (SQL: create table "blogs" ("id" integer
not null primary key autoincrement, "user_id" integer not null, "name" varchar not null, "text" varchar not null, "created_at" datetime, "updated_at" datetime))
at C:\Users\Modiran\Desktop\blog\vendor\laravel\framework\src\Illuminate\Database\Connection.php:712
708▕ // If an exception occurs when attempting to run a query, we'll format the error
709▕ // message to include the bindings with SQL, which will make this exception a
710▕ // lot more helpful to the developer instead of just the database's errors.
711▕ catch (Exception $e) {
➜ 712▕ throw new QueryException(
713▕ $query, $this->prepareBindings($bindings), $e
714▕ );
715▕ }
716▕ }
716▕ }
1 C:\Users\Modiran\Desktop\blog\vendor\laravel\framework\src\Illuminate\Database\Connection.php:495
PDOException::("SQLSTATE[HY000]: General error: 1 table "blogs" already exists")
2 C:\Users\Modiran\Desktop\blog\vendor\laravel\framework\src\Illuminate\Database\Connection.php:495
PDO::prepare("create table "blogs" ("id" integer not null primary key autoincrement, "user_id" integer not null, "name" varchar not null, "text" varchar not null, "created_at" datetime, "updated_at" datetime)")
