Help in Uploading my SQL Database

You are invited to have my FREE RSS Feeds or you may Subscribe to me via email for latest information in this website.

I am happy to inform that I am now back to Blogging World, After my site had problem due to hosting issues, I am now back online. There is some other things I need to fixed in this blog. I need to learn SSH in order to put back some of my database, Anybody can help. It will be great if you could make a post in Type of Instruction and I can link back to you and will be better as future reference of other bloggers.

I have about 26,000+ Kb SQL Files and I am not successful in putting it back where it belong. So I think You know what is my problem. Anybody care to help.

BTW sorry to inform you that all comments from July 17,2008 until today was not properly back up. But if I can resolve issue about my database there will still be a chance to put it back.

I am hosted now at DreamHost.

Related Posts

Email This Post Email This Post

; Filed Under Site Updates

If you are new here, and you would like be updated on the things happening on this site, Try to Subscribe to my FREE RSS Feeds  and Subscribe to me via email


Next post in category: My Site is Not Cached By Google »

« Previous post in category: Is There Something Wrong With Technorati?

Tags: ,

Trackback Links

del.icio.us |Digg it |Furl |ma.gnolia |Maple.nu |Netscape |reddit |Scuttle |Shadows |Simpy |Spurl |StumbleUpon |Wink |Yahoo MyWeb |

Permalink : Help in Uploading my SQL Database

Sign up for PayPal and start accepting credit card payments instantly.

Comments

16 Responses to “Help in Uploading my SQL Database”

  1. Hussein | Random Blog on July 26th, 2008 9:50 pm

    Dreamhost ka na? Dapat hostgator na lng. hehe What’s the problem?

    Hussein | Random Blogs last blog post..PR Update, Prediction is True

    [Reply]

    Dexter | Tech At Hand Dot Net Reply:
    July 30th, 2008 at 2:18 am

    Siguro sa mga susunod kong Project subukan ko yan

    Dexter | Tech At Hand Dot Nets last blog post..When Will Nokia Tube Be Out in The Market ( 5800 XpressMusic )

    [Reply]

  2. sylv3rblade on July 26th, 2008 10:05 pm

    SSH 101 for dreamhost

    For large SQL dumps..

    1. Download BigDump and configure with the necessary details (username and pass for your new host)

    2. Upload the exported SQL file (AKA as dump) from to your new host.

    3. Run Bigdump

    If you exported your database without specifying the DROP TABLE option, you have to manually drop (delete) all tables on your current database before you BigDump can import it.

    Hope that helps.

    [Reply]

    Dexter | Tech At Hand Dot Net Reply:
    July 30th, 2008 at 2:19 am

    Gumana na yung Phpmyadmin kaya di ko na sinubukan ito. For future refence ko na lang siguro

    Dexter | Tech At Hand Dot Nets last blog post..When Will Nokia Tube Be Out in The Market ( 5800 XpressMusic )

    [Reply]

  3. admin on July 26th, 2008 11:15 pm

    @ sylv3rblade

    Plugin ba yang Bigdump ? Php kasi I am now studying it.. I will do it after Office hour

    [Reply]

  4. Blogger on July 27th, 2008 5:54 am

    WAH! DreamHost is the worst hosting company in the universe. I heard many reports and complaints on DH against their clients about content issues and I think you’re one of the victim now.

    [Reply]

    Dexter | Tech At Hand Dot Net Reply:
    July 30th, 2008 at 2:19 am

    Well I also heard good reports at DH.. Let see :)
    Dexter | Tech At Hand Dot Nets last blog post..When Will Nokia Tube Be Out in The Market ( 5800 XpressMusic )

    [Reply]

  5. Dexter | Tech At Hand Dot Net on July 27th, 2008 8:33 am

    @ Blogger

    Ooopsss scary…

    [Reply]

  6. Amy on July 27th, 2008 10:28 pm

    nawala yung mahabang reply ko :( test lang muna

    Amys last blog post..WordCamp Philippines 2008

    [Reply]

  7. Amy on July 27th, 2008 10:30 pm

    yung back up mo ba SQL file?
    usually kasi, I use PHPMyAdmin and use the Import facility

    Basically, all you have to do is to specify the sql file and click [Go]
    everything will then be imported to your new database…

    I am not sure though if it will work on very large source file…

    Amys last blog post..WordCamp Philippines 2008

    [Reply]

  8. Amy on July 27th, 2008 10:32 pm

    cont…
    in assumption that you are using linux and PHPmyadmin is available in your Cpanel

    :)
    Amys last blog post..WordCamp Philippines 2008

    [Reply]

    Dexter | Tech At Hand Dot Net Reply:
    July 30th, 2008 at 2:17 am

    Thanks it is now working fine. I have manage to use the Php MY Admin.

    Dexter | Tech At Hand Dot Nets last blog post..When Will Nokia Tube Be Out in The Market ( 5800 XpressMusic )

    [Reply]

  9. Bob Reyes on July 29th, 2008 7:50 am

    Try my post at http://www.bobreyes.com/myblog/2007/11/17/importing-big-mysql-databases/

    [Reply]

  10. Bob Reyes on July 29th, 2008 7:59 am

    You may use Putty SSH to run bash scripts and manage your site thru the command line: http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html

    [Reply]

  11. Dexter | Tech At Hand Dot Net on July 29th, 2008 8:02 am

    @ Bob Reyes

    Thanks for the link well actually as Already download it before but I cannot connect maybe I have research more on how to use it..

    [Reply]

  12. Webhostingbuzz Coupon on August 24th, 2008 9:55 pm

    Webhosting uptime is very important for me. So if you have to get a good hosting, get the best uptime server, I think dreamhost can provide maximum uptime, 99.99%. But of course you have to pay more. :P

    [Reply]

1 pingsLinks To This Post

  1. Pages tagged "help" on July 26th, 2008 10:44 pm

    [...] bookmarks tagged help Help in Uploading my SQL Database saved by 10 others     metalskater2 bookmarked on 07/27/08 | [...]

Leave a Reply




Subscribe to RSS feed

Subscribe to RSS feed

Enter your email address:

Other Topic