SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    AdSpeed.com Son Nguyen's Avatar
    Join Date
    Aug 2000
    Location
    Silicon Valley
    Posts
    2,241
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I have a big MySQL backup that need to dump back to the DB, however, using telnet, it seems that it can't finish the job. I've waited for a while then I stopped it.

    Do you think it has a limit on the size of the text file when restoring a database or I should just keep waiting? The file size is about 24MB.

    Thanks
    - Son Nguyen
    AdSpeed.com - Ad Serving and Ad Management Made Easy

  2. #2
    SitePoint Wizard
    Join Date
    Apr 2000
    Posts
    1,483
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    There's no limit - I know a few people from the vBulletin.com forums who've dumped databases of up to 200Mb through telnet.
    Try just waiting a bit longer - shouldn't take more than a couple of minutes though. If you still have no success, try contacting the host.

  3. #3
    SitePoint Guru prequel's Avatar
    Join Date
    Nov 1999
    Location
    Brisbane, Australia
    Posts
    682
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    when you run the mysqldump command use the -- opt command so as not to load the mysql dump into memory before dumping

    i.e

    mysqldump --opt -u username -p databasename > dump.sql


  4. #4
    SitePoint Wizard silver trophy Karl's Avatar
    Join Date
    Jul 1999
    Location
    Derbyshire, UK
    Posts
    4,411
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I think on most MySQL installations there is a limit to how large a packet can be, I think the default is 1MB, so that could be your problem.
    Karl Austin :: Profile :: KDA Web Services Ltd.
    Business Web Hosting :: Managed Dedicated Hosting
    Call 0800 542 9764 today and ask how we can help your business grow.

  5. #5
    AdSpeed.com Son Nguyen's Avatar
    Join Date
    Aug 2000
    Location
    Silicon Valley
    Posts
    2,241
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for the replies,

    I am in the process of restoring it, so I used:

    mysql -u username -p database_name < backup.file

    And I've waited for about over 10 minutes.
    When I stopped the process, and checked the DB, it got a few tables (but not all the tables)
    - Son Nguyen
    AdSpeed.com - Ad Serving and Ad Management Made Easy


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
  •