I Am Soo Stuck! Please Someone Help!

Discussion in 'MySQL' started by awaisuk, Mar 22, 2007.

0
  1. #1
    ok,

    I have a databse about 150MB and i cannot back it up for some reason through phpmyadmin.... I am on Windows server with Plesk.

    I have been looking for days now, for some script or ANYTHING to back my DB up...It waas pretty easy in Linux where i used SSH.

    HOW CAN I BACK MY DATABASE ?

    Will be really greatful for people to help me out, as i myself is so frustrated at the moment.

    Hope i get a positive response.

    Thanks
     
    awaisuk, Mar 22, 2007 IP
  2. commandos

    commandos Notable Member

    Messages:
    3,648
    Likes Received:
    329
    Best Answers:
    0
    Trophy Points:
    280
    #2
    What is the error you are receiving from phpmyadmin when you try to backup ?
     
    commandos, Mar 22, 2007 IP
  3. Pat Gael

    Pat Gael Banned

    Messages:
    1,331
    Likes Received:
    68
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Obviously, phpMyadmin sucks since long awhile, just pure "cosmetic" improvements.

    For very large databases there are two must-have scripts

    www.ozerov.de/bigdump.php for dumping, and www.bitesser.de/freeware/script.php?id=1 for backing up

    .
     
    Pat Gael, Mar 22, 2007 IP
    commandos likes this.
  4. awaisuk

    awaisuk Banned

    Messages:
    1,013
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #4
    I get no error, the downloading just stops.... and when i open the SQL its cutted, as not completed.
     
    awaisuk, Mar 23, 2007 IP
  5. commandos

    commandos Notable Member

    Messages:
    3,648
    Likes Received:
    329
    Best Answers:
    0
    Trophy Points:
    280
    #5
    Maybe you can cut it , like go database by database and if only 1 database go tables by tables .

    or see other software .
     
    commandos, Mar 23, 2007 IP
  6. awaisuk

    awaisuk Banned

    Messages:
    1,013
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Its only 1 database, and all the others tables backup where the MAIN One doesnt. So thers some problem in that one table...

    Ayway to fix?
     
    awaisuk, Mar 23, 2007 IP
  7. awaisuk

    awaisuk Banned

    Messages:
    1,013
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #7
    anyone?? Please......
     
    awaisuk, Mar 24, 2007 IP
  8. conceptcrew

    conceptcrew Active Member

    Messages:
    547
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    60
    #8
    Using phpmyadmin, you can choose what table you wish to back up. Split the dataabase into smaller groups of tables instead of trying to backup the entire thing at one time.

    I have a mysql database that very large as well and that is how I handled the issue.
     
    conceptcrew, Mar 24, 2007 IP
  9. aredhelrim

    aredhelrim Peon

    Messages:
    7
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #9
    You can backup the tables one by one or by using any trigger. And take a look into mysql data directory :)
    Have a nice day
     
    aredhelrim, Mar 24, 2007 IP
  10. awaisuk

    awaisuk Banned

    Messages:
    1,013
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #10
    That has backed my table up, but its not in the form of PHPMYADMIN Structure..

    Yeah i tryed 1 by 1 but it doesnt backup fully aswell, so theres something wrorng with the table.

    However it backed it up using MYSQL COMMANDER, Can someone tell me how to restore it?
     
    awaisuk, Mar 24, 2007 IP
  11. prilep

    prilep Well-Known Member

    Messages:
    3,852
    Likes Received:
    228
    Best Answers:
    0
    Trophy Points:
    185
    #11
    Well 150 MB is pretty big. Maybe thats why it stops.

    - Prilep :D
     
    prilep, Mar 24, 2007 IP