SitePoint Sponsor

User Tag List

Results 1 to 5 of 5

Thread: Upload database

Hybrid View

  1. #1
    SitePoint Guru mmarif4u's Avatar
    Join Date
    Dec 2006
    Location
    /dev/swat
    Posts
    619
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Upload database

    How can i upload a bigger size mysql database to server.
    Plz its urgent.
    Size is around 30mb.

  2. #2
    SitePoint Enthusiast joejoe04's Avatar
    Join Date
    Mar 2006
    Location
    Akron, OH
    Posts
    78
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It might be helpful to post the exact error message you are getting when you try to upload it. I'm definitely not an expert with databases but you might want to try and contact your host if there is a size limit for databases uploaded to their servers and see if they will allow you permission to upload this one. Also, try just uploading the database to your server (as opposed to importing it through phpmyadmin), and maybe your host will try to import it for you. I know that mine did so for me some time ago.
    Thank you, Chuck Norris.

  3. #3
    SitePoint Guru mmarif4u's Avatar
    Join Date
    Dec 2006
    Location
    /dev/swat
    Posts
    619
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yeh i know that by phpmyadmin i can, but it did not support large files.
    I need some script that will upload the database without time exit out.

  4. #4
    SitePoint Enthusiast
    Join Date
    Jun 2007
    Location
    Frankfurt/Germany
    Posts
    66
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Smells like max_execution_time outage.

    Better get shell access and run something like:

    mysql -uroot -pPASSWORD < /path/to/dump

  5. #5
    SitePoint Guru mmarif4u's Avatar
    Join Date
    Dec 2006
    Location
    /dev/swat
    Posts
    619
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for ur idea.
    I already fix it. may be next time i will try ur idea.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •