SitePoint Sponsor

User Tag List

Results 1 to 5 of 5

Hybrid View

  1. #1
    SitePoint Enthusiast
    Join Date
    Jan 2003
    Posts
    74
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Mysql Dump Question...regarding gigantic file

    Hello. I am trying to recover a database for a 118 mb file for a client

    I tried phpmyadmin and saw there were 10,000 + rows and the browser crashed trying to display them

    so I attempted to do a mysql dump, and it just pauses in the command line, and the file grew to 200+ mb

    How long should it take to do the dump? IT was growing to 200+ mb before I shut out of telnet. I felt it would not stop growing lol

    Or is it possible that it CAN be 200+ mb and I should NOT worry?

    When I waited 3 minutes and saw mysql did not confirm it was done, I got a bit spooked

    What should I do? And is there a way to conserve memory when I do the dump?
    Last edited by nyc03; May 29, 2003 at 15:45.

  2. #2
    Hi there! Owen's Avatar
    Join Date
    Jan 2000
    Location
    CA
    Posts
    1,165
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Look in phpmyadmin... there's an option to show how big the database is... that's how big the backup file will be (more or less). I have a 1 gig database... it's a hassle to work w/ the backup files which are not conincidentally 1 gig. Nothing much you can do about it.

    Owen

  3. #3
    Non-Member Icheb's Avatar
    Join Date
    Mar 2003
    Location
    Germany
    Posts
    1,474
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It's usually smaller due to the indexes. Our forum's database is currently 161 mb big and the backup is about 115 mb.

  4. #4
    Froot r gewd SubKamran's Avatar
    Join Date
    May 2002
    Location
    North Star State
    Posts
    597
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I would use a software to dump, since there's no timeout (downloading is fine, but the backup part is the problem).

    I'd go with http://www.mysqlstudio.com/ I'm buying their software, it's excellent.
    "Sometimes little is more."
    Kamran A
    Web Dev/Designer
    Keyboard not found: Please Press F1 to Continue

  5. #5
    Prolific Blogger silver trophy Technosailor's Avatar
    Join Date
    Jun 2001
    Location
    Before These Crowded Streets
    Posts
    9,446
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    nyc, if you need help, give me a shout. I can do that for you in a few mins.
    Aaron Brazell
    Technosailor




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
  •