I have two db's I want to transfare content of post table to other table called act_post

Using command line, a scheduled task or something else?

@sinnbeck thank for your answer how can implement this in laravel as you see there is one .env fil ?

Can you give some context? Do you just need to run this once? Or like every day?

A bit to get you started. Set the connection on each model to the respective database

protected $connection = 'mysql1';

And do something like this

$data = Model1::all(['col1', 'col2'] );
Model2::insert($data->toArray);

This my post table on the first database

    Schema::create('posts', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->text('post_name');
            $table->text('post_content');
            $table->timestamp();
        });

This my buss_post table on the second database

    Schema::create('buss_posts', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->text('post_name');
            $table->text('post_content');
            $table->timestamp();
        });

and this my controller BlogController

class BlogController extends Controller
{
    public function run()
    {

        $oldPosts = \DB::table('buss_posts')->get();
      
            
    }
}

so my question how to changes between two databases to access tables inside it.

Set up 2 connections with different databases. (database.php)

@sinnbeck than you a lot someone helped me you can check it here

The difference is that their code inserts one line at the time and mine inserts all (only 2 queries)