mysql and phpmyadmin (local)

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

0
  1. #1
    Sorry - wrong forum ... reposted in databases !

    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. Evoleto

    Evoleto Well-Known Member

    Messages:
    253
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    108
    #2
    Upload by FTP, the go to the SQL link on the desired DB in phpMyAdmin, you'll see at the bottom of the page an option to select a local file, fill in with the path of the sql dump.

    [Later Edit...]

    Or you can use the system() command in PHP to call the mysql client like:

    
system("mysql --user=yourusername --password=your password < /path/to/the/sql.dump")
    Code (markup):
     
    Evoleto, Sep 24, 2006 IP