Please help : move 9Mb sql file from php myadmin

Discussion in 'MySQL' started by mydeuter, Sep 9, 2008.

  1. #1
    i need help ,

    I want to move sql file size 9Mb through phpmyadmin but failed ...

    please advise
     
    mydeuter, Sep 9, 2008 IP
  2. themaster

    themaster Well-Known Member

    Messages:
    934
    Likes Received:
    33
    Best Answers:
    0
    Trophy Points:
    140
    #2
    Try to use HeidiSQL - http://www.heidisql.com/
    Or better if you have ssh access to your host you can use following to upload;
    mysql -u username -p database_name < file_name_to_be_upploaded.sql

    to backup;
    mysqldump --opt -Q -u username -p database_name> file_name_to_be_backup.sql
     
    themaster, Sep 9, 2008 IP
  3. gizmoid

    gizmoid Peon

    Messages:
    27
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3

    or you can split this SQL file to small one ( i assume that you have size issues )

    i see one tool for that somewhere

    try here

    http://www.madbabble.com/sql-dump-file-splitter
     
    gizmoid, Sep 15, 2008 IP
  4. demonzmedia

    demonzmedia Guest

    Messages:
    21
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    No, just increase the maximum file size in your php.ini. You may also need to increase the max execution time.
     
    demonzmedia, Sep 16, 2008 IP
  5. demonzmedia

    demonzmedia Guest

    Messages:
    21
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Also, if your host allows remote connections use the backup utility in the MySQL Administrator program from the MySQL website.
     
    demonzmedia, Sep 16, 2008 IP