1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Transferring large database via ssh

Discussion in 'Plesk for Linux - 8.x and Older' started by greenchicken, May 7, 2006.

  1. greenchicken

    greenchicken Guest

    0
     
    Ok I have Plesk8

    I have a Vbulletin forum

    I have a large database I want to transfer via ssh

    I am new to ssh very new

    Say I upload a database to httpdocs on account example.com

    and I wanted to move that database to my database list by ssh

    what are the exact command lines to do this and is it possible?

    TIA
    Total newbie, wanting to learn
     
  2. freaky@

    freaky@ Regular Pleskian

    26
     
    Joined:
    May 2, 2006
    Messages:
    104
    Likes Received:
    0
    Don't really get ur question....

    From the machine the file is on

    scp /path/to/file.tgz user@host.somedomain.com:/path/to/store

    will ask for password of <user> then

    man scp
     
  3. albans

    albans Regular Pleskian

    26
     
    Joined:
    Nov 29, 2005
    Messages:
    173
    Likes Received:
    0
    If you've got a mysql DB, I think that the easiest thing to do is to export/import it via PHPMyAdmin rather than moving the DB files from one server to the other...

    Or the best way, not the easiest would be to use a mysql client like SQLyog, you connect to the old server and to your actual plesk web server (via VPN module of Plesk, OpenSSL). Then you select to "copy a database to a different Host/DB".

    You might find this article usefull:
    backup and restore a mysql database
     
  4. !Blob!

    !Blob! Guest

    0
     
    The question is: what've you uploaded?

    It can be *.sql, then just simply you enter directory with that file, and execute:
    mysql -u username -p -D database < yourfile.sql

    You can create user and database via PHPMyAdmin for example. Don't even think of uploading large db via PHPMyA - it won't work. ;)

    If you have a hardcopy of *.MYD, *.MYI, *.frm files just upload them to mysql's data directory (it depends on what system you have). For example to /var/lib/mysql/database/ and you're done (just remember to create a user for that database).
     
Loading...