SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: MySQL Backup

Hybrid View

  1. #1
    SitePoint Member
    Join Date
    Oct 2009
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL Backup

    Hi

    I want to move a MySQL database from one server to another. Since this database is having more than 150 tables with humongous data inserted, I canít take a regular backup like downloading as SQL file and then uploading it at the other MySQL server.
    Also the server that currently hosts the database is not having SSH installed in it.
    So is there any easy way by which u can move the database to the other server.
    Is there any way by which I can login to the second server via putty and connect to the current server and move the databases?

    Please advise me.

  2. #2
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,580
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    You can use the -h flag on mysqldump to tell it to connect to the old database, and produce the .sql dump on the new server. Then run it through mysql to populate the database on the new server.

    mysqldump --help


Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •