MySQLのデータベースを別のサーバーにコピーする

MySQLサーバーのデータベースを別のサーバーにコピーする方法を紹介します。

MySQLデータベースをコピーするのにはMySQLのWorkBenchを利用します。

利用しているOSによってポート開放のやり方が違うためここでは、記載しませんが、コピー先のMySQLのポートを開放しておく必要があります。

ポート開放したらコピー元のサーバーでWorkBenchを起動します。(WorkBench)はMySQLサーバーのインストール時についてきます。

この部分の+をクリックしてコピー先のサーバーを追加します。

このような画面が表示されますのでここにコピー先の情報を入れていきます。

  • Connection Name:好きな名前を設定してください
  • Connection Method:変更しなくて良いです
  • Hostname:コピー先のIPアドレスです。
  • Port:MySQLサーバーのポートを変えている場合は変更してください
  • Username:root権限があるアカウントの名前(通常は変更しない)
  • Password:Store in Vaultをクリックしてパスワードを入力します

設定を終えたらOKで閉じます。

次にlocalhostのコピー元サーバーを開きます。画像のような感じに表示されています

このような画面が表示されます。

次に左上のDatabaseからSchemaTransfar Wizardを開きます

次にStart Wizardをクリックします。すると、下のような画面になります。

SourceConnectionからlocalhostを選択します。次にTargetConnectionからコピー先のデータベースを選択します

Nextで次へ進みます。データベースの一覧が表示されますので、選択してStartします。しばらく待てばコピーが完了します

“MySQLのデータベースを別のサーバーにコピーする”へのコメント53

  1. sex doll Should I Purchase My Better half A Sex Doll? Sex Dolls For Craftsmen: How It Affects Them Should Men Separation Spouses For Sex Dolls? Where Would i be able to Purchase A Sex Doll

  2. Write more, thats all I have to say. Literally, it seems as though you relied on the
    video to make your point. You obviously know what youre
    talking about, why throw away your intelligence on just posting
    videos to your weblog when you could be giving us something enlightening to read?

  3. wonderful submit, very informative. I’m wondering why the opposite experts
    of this sector do not notice this. You should continue your writing.

    I am sure, you have a huge readers’ base already!

  4. Fantastic blog! Do you have any hints for aspiring writers?
    I’m planning to start my own site soon but I’m a little lost
    on everything. Would you propose starting with a free
    platform like WordPress or go for a paid option? There are so
    many options out there that I’m totally confused
    .. Any recommendations? Many thanks!

  5. Hmm is anyone else experiencing problems with the images
    on this blog loading? I’m trying to determine if its a problem on my end or if
    it’s the blog. Any responses would be greatly appreciated.

  6. Howdy! Quick question that’s completely off topic. Do you
    know how to make your site mobile friendly? My website looks weird when browsing
    from my iphone. I’m trying to find a template or plugin that
    might be able to correct this problem. If you have any recommendations, please share.
    Cheers!

  7. I know this if off topic but I’m looking into starting my own weblog and was
    wondering what all is needed to get set up? I’m assuming having a blog like yours would cost a pretty penny?
    I’m not very internet smart so I’m not 100% sure.
    Any recommendations or advice would be greatly appreciated.

    Many thanks

  8. Excellent beat ! I would like to apprentice while you amend
    your site, how can i subscribe for a blog web site?
    The account helped me a acceptable deal. I had been tiny bit acquainted of this
    your broadcast provided bright clear idea

  9. RELEASE SPINS NO SET ASIDE LARGESSE
    As we all recognize, video sulcus games overlook the casino pigeon-hole games world so it makes coherence that a bonus that is designed specifically in search notch machines should be the most popular. Allowing for regarding place enthusiasts, untrammelled spins no accumulation bonuses are a legal goldmine, because they get to have a ball their favorite freed no deposit slots with a company of at liberty spins included, which can besides their chances of winning considerably.

    UNSHACKLED CREDITS / DEMOCRATIC PLAY NO DEPOSIT PERQUISITE
    Rather than of redeem spins, some casinos prefer to offer free credits quest of players who state no deposit bonuses. These can be used within a predetermined timeframe to lay on casino games and spawn some licit winnings. Open credits no save bonuses are ready for both at liberty bonus slots and other casino games.

    slots free

    SELF-GOVERNING BREAD NO DEPOSIT EXTRA
    Similarly to easy credits no lodge bonuses, let go legal tender no lodge bonuses can be in use accustomed to on slots and other casino games. After claiming and playing finished with a freed cash no stash away remuneration, you can retrieve your remuneration dough and additional winnings as large as you unite the requirements payment specie withdrawal.

コメントを残す

メールアドレスが公開されることはありません。 * が付いている欄は必須項目です