Results 1 to 3 of 3

Thread: copy sql?

  1. #1
    Join Date
    Jan 2007
    Posts
    688

    copy sql?

    Quick question.

    How do I copy an entire mysql sql database file via ssh?

    Inside /var/lib/mysql the sql are per table, not one single sql. The db is over 300mb in size too.

    Using mysql 5 / centos 4.6

  2. #2
    Join Date
    Nov 2001
    Location
    Ann Arbor, MI
    Posts
    2,978
    -Mark Adams
    www.bitserve.com - Secure Michigan web hosting for your business.
    Only host still offering a full money back uptime guarantee and prorated refunds.
    Offering advanced server management and security incident response!

  3. #3
    Join Date
    Oct 2004
    Location
    Kerala, India
    Posts
    4,750
    Quote Originally Posted by Calibaba View Post
    Quick question.

    How do I copy an entire mysql sql database file via ssh?
    You need to copy the entire directory /var/lib/mysql/databasename/
    ?
    David | www.cliffsupport.com
    Affordable Server Management Solutions sales AT cliffsupport DOT com
    CliffWebManager | Access WHM from iPhone and Android

Posting Permissions

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