What i need to increase?

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

0
  1. #1
    Hey

    I have a big db and whenever i try to get the whole backup, it always stops and gives me half db,

    Well someone told me its timing out and you need to increase your timeout time in php.ini , SO CAN SOMEONE TELL ME WHAT I NEED TO INCREASE TO MAKE IT UNLIMITED? ( I OWN THE SERVER )

    mysql.allow_persistent	On	On
mysql.connect_timeout	-1	-1
mysql.default_host	no value	no value
mysql.default_password	no value	no value
mysql.default_port	no value	no value
mysql.default_socket	no value	no value
mysql.default_user	no value	no value
mysql.max_links	Unlimited	Unlimited
mysql.max_persistent	Unlimited	Unlimited
mysql.trace_mode	Off	Off
    Code (markup):

     
    awaisuk, Mar 25, 2007 IP
  2. D'Godown

    D'Godown Well-Known Member

    Messages:
    1,093
    Likes Received:
    25
    Best Answers:
    0
    Trophy Points:
    140
    #2
    Are you using mysql dump command in SSH? I hope mysqldump can easily dump GB's worth of databases.

    mysqldump -u username -p databasename > backup.sql
     
    D'Godown, Mar 25, 2007 IP
  3. awaisuk

    awaisuk Banned

    Messages:
    1,013
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I am on Windows server, so no SSH. All i got is phpmyadmin...
     
    awaisuk, Mar 25, 2007 IP
  4. ccoonen

    ccoonen Well-Known Member

    Messages:
    1,606
    Likes Received:
    71
    Best Answers:
    0
    Trophy Points:
    160
    #4
    phpmyadmin only allows X size uploads. I would just upload the database to the server and run the mysql command to import the backup file. Do NOT upload with phpMyAdmin - its not reliable (for large databases)
     
    ccoonen, Mar 25, 2007 IP