large mysql problem

Discussion in 'MySQL' started by darrens, Sep 24, 2006.

0
  1. #1
    Hi,

    I have just installed xampp that contains php, mysql, phpmyadmin etc on a win xp pc.
    The xampp installed MySQL - 5.0.24a and phpMyAdmin - 2.8.2.4

    I have downloaded my mysql dump from my real time web site and the sql file is 300+ mb

    Im trying to import it locally but i keep getting errors about the size.
    Any suggestions how i can import locally a 300+mb file ?

    Thnaks in advance.
     
    darrens, Sep 24, 2006 IP
  2. lordmenace

    lordmenace Well-Known Member

    Messages:
    541
    Likes Received:
    20
    Best Answers:
    0
    Trophy Points:
    140
    #2
    You need to go into your php.ini file (it's a config file) nand change the maximun size from 2mb to 310mb (Just to be sure it fits). Then refresh your mysql server.
     
    lordmenace, Sep 24, 2006 IP