Jump to content


Photo

Restore a big mysql db file in Windows


  • Please log in to reply
10 replies to this topic

#1 Kevin

Kevin

    Beta Team Veteran

  • Member
  • Pip
  • 27 posts

Posted 21 April 2005 - 08:06 PM

I have a 2.8 GB mysql file (700 MB in sql.gz) and I want to restore it. However, I tried MySQL Administrator and it didnt even start up :angry: Any ideas how to restore this big db? ;)

#2 Kdaddy

Kdaddy

    Junior Member

  • Member
  • Pip
  • 31 posts

Posted 22 April 2005 - 12:21 AM

Hopefully this will help you take a look here. BigDump

#3 Kevin

Kevin

    Beta Team Veteran

  • Member
  • Pip
  • 27 posts

Posted 22 April 2005 - 01:01 AM

I can't get the DB again so, that script is helpless :angry:
Thanks anyway

#4 Kevin

Kevin

    Beta Team Veteran

  • Member
  • Pip
  • 27 posts

Posted 22 April 2005 - 01:13 PM

Oops, let me try this script hee

#5 elyk

elyk

    Beta Team Veteran

  • Member
  • PipPip
  • 85 posts
  • Location:Planet Earth
  • SourceForge IDelyk
  • Wiki ID: elyk
  • IRC Nickname: elyk

Posted 22 April 2005 - 08:12 PM

have you tried to restore it using phpmyadmin? I'm not sure whether it'll work with that big of a file though.

#6 olajideolaolorun

olajideolaolorun

    Project Manager

  • Admin
  • PipPipPipPipPip
  • 2,347 posts
  • Gender:Male
  • Location:Atlanta, GA
  • SourceForge IDempirex
  • Wiki ID: olajideolaolorun
  • IRC Nickname: Olajide
  • Main OS: Windows 10

Posted 23 April 2005 - 12:39 AM

No way for phpMyAdmin. Too big nd it wn't work cause of the maximum execution time/size.

#7 Kevin

Kevin

    Beta Team Veteran

  • Member
  • Pip
  • 27 posts

Posted 23 April 2005 - 01:51 AM

nvm
I tried mysql.exe -u usr -p db < file.sql
Took ~15 mins to restore lol

#8 olajideolaolorun

olajideolaolorun

    Project Manager

  • Admin
  • PipPipPipPipPip
  • 2,347 posts
  • Gender:Male
  • Location:Atlanta, GA
  • SourceForge IDempirex
  • Wiki ID: olajideolaolorun
  • IRC Nickname: Olajide
  • Main OS: Windows 10

Posted 23 April 2005 - 01:06 PM

lol... That is the only way possible, but i believe that MySQL Administrator should be able to do that. :angry:

#9 Kevin

Kevin

    Beta Team Veteran

  • Member
  • Pip
  • 27 posts

Posted 23 April 2005 - 01:12 PM

lol... That is the only way possible, but i believe that MySQL Administrator should be able to do that. :D

View Post

No MA is a piece of crap :angry: ;) :P It didnt even start to run 1 single query B)

#10 olajideolaolorun

olajideolaolorun

    Project Manager

  • Admin
  • PipPipPipPipPip
  • 2,347 posts
  • Gender:Male
  • Location:Atlanta, GA
  • SourceForge IDempirex
  • Wiki ID: olajideolaolorun
  • IRC Nickname: Olajide
  • Main OS: Windows 10

Posted 23 April 2005 - 01:19 PM

lol... I got it to work :angry: and i used it for a while until i found no use for it ;)

Planned to make it a plugin but also discarded it because it is easy to install... :P

#11 MrX

MrX

    The Mad Theorist

  • Support Team
  • PipPip
  • 167 posts
  • Location:IRC :P
  • Wiki ID: MrX
  • IRC Nickname: MrX, MrX- and MrX_

Posted 24 April 2005 - 10:06 AM

nvm
I tried mysql.exe -u usr -p db < file.sql
Took ~15 mins to restore lol

View Post

Shall I say.. I told you so?
:angry:




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users