Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005
    Posts
    435

    Importing large mysql DB in shell

    This is all done through shell.

    I was wondering if there was a way for me to cut up a large mysql database in shell. We're talking almost 8 gigs here.

    I would like to import it in chucks, something like 1 gig per shot. Is that doable with some software that I can use in shell? I wouldn't want to use vim to splice up that sucker.

    Or is there a better method of doing this? I already dumped this and I rather not do it again unless if I could perhaps dump this in chunks.

    Any advice?



    Thanks

  2. #2
    Join Date
    Oct 2004
    Location
    Kerala, India
    Posts
    4,750
    You can take the database backup by taking separate backups of selected tables at a time. By this you can create multiple dump files that are not of huge size.

    Code:
    mysqldump --add-drop-table table1 table2 table3 > tabl1_tabl2_tabl3.sql
    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
  •