Capistrano:如何为PHP应用程序部署MySQL数据库？

require 'capistrano/deploy'
require 'capistrano/bundler'
require 'capistrano/composer'
require 'capistrano/rails/assets'
require 'capistrano/rails/migrations'
require 'capistrano/passenger'

set :application, 'your_application_name'
set :repo_url, 'your_repository_url'
set :deploy_to, '/path/to/deploy'
set :linked_files, fetch(:linked_files, []).push('config/database.php')
set :linked_dirs, fetch(:linked_dirs, []).push('vendor')

namespace :deploy do
  after :published, :restart do
    on roles(:app) do
      execute :touch, release_path.join('tmp/restart.txt')
    end
  end
end

<?php
return [
    'default' => [
        'hostname' => 'your_database_hostname',
        'database' => 'your_database_name',
        'username' => 'your_database_username',
        'password' => 'your_database_password',
        'port' => 'your_database_port',
    ],
];

<?php
return [
    'default' => [
        'deploy_path' => '/path/to/deploy',
        'user' => 'your_server_username',
        'password' => 'your_server_password',
        'host' => 'your_server_hostname',
        'port' => 'your_server_port',
    ],
];

cap production deploy