Help Me in Uploading My Forum Database

Discussion in 'MySQL' started by manjifera, Dec 19, 2008.

0
  1. #1
    Hi Members,

    I have a forum datatbase of 23 Mb, i would like to upload it to my new host, i tried through php myadmin but My host Godaddy isnt allowing me to upload database more than 2 MB, Can anyone help me to do the same via any other method ?

    Thanks
    Prashanth
     
    manjifera, Dec 19, 2008 IP
  2. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #2
    Upload the file via ftp to your account and then use bigdump tp import it.
     
    mwasif, Dec 19, 2008 IP
  3. demondestiny

    demondestiny Peon

    Messages:
    65
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Use your FTP account. Ones such as filezilla are really good.
     
    demondestiny, Dec 19, 2008 IP
  4. 1959

    1959 Peon

    Messages:
    8
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Yes, search the web for bigdump.php it's a good way to import a large database.

    What kind of forum is it? If it is phpBB you might experience some errors with the search tables. I ended up deleting the insert into statements for those and re-generating the search index after moving.
     
    1959, Dec 22, 2008 IP
  5. kailash

    kailash Well-Known Member

    Messages:
    1,248
    Likes Received:
    42
    Best Answers:
    0
    Trophy Points:
    190
    #5
    If you have shell access enabled, you can restore your database from it.

    mysql -uyourmysqlusername -pmysqluserpassword yourdatabasename < path_of_your_database_backup_file

    You will need to upload the backup via FTP.

    Or you can use bigdump or you can request your host to restore it on your behalf.

    Kailash
     
    kailash, Dec 22, 2008 IP