Home > Site Updates > Help in Uploading my SQL Database

Help in Uploading my SQL Database

Posted by : Dexter Panganiban on July 26, 2008 | ; Filed Under Site Updates

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
  • Search and Replace Function in MySQL thru MyPhp Admin
    Warning if you don't know how to use MySql Query better make a trial to those database that you will not loose anything if your ruin it.. You have been warned. !!! If you want to search and update any broken links that you may find using your Google Webmaster Tools, changing it from MySQL will be ...
  • E-mail & Phone Call Database
    BBC reported that UK is proposing to have a Phone calls database :  Ministers are to consider plans for a database of electronic information holding details of every phone call and e-mail sent in the UK, it has emerged. The plans, reported in the Times, are at an early stage and may be incl...
  • Just Finished Some Fixes at my Comment Database
    This post is intended to share some fixes that I have Done. I have seen this comment in yellow at my database : See Pictures below More than one INDEX key was created for column `comment_approved’ Problem : When Commenting in my blog it will redirect you to 404 Page then after refreshing...
Related Posts Plugin for WordPress, Blogger...

Enter your email address:

Tags: Dreamhost, hosting, Instruction, SQL Data, SSH

About the author

Dexter is a person that love technology,new gadget, SEO, Social Media and Christianity. Follow him at twitter via @techathand and add him @ Google+ and contact us at admin@techathand.net

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

Interesting 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




My Sponsors

Help My Father's Kidney Dialysis Expenses

Help in My Father’s Kidney Dialysis by Contributing Articles and/or Being Our Link Builder

Subscribe to RSS feed

Subscribe to RSS feed

Enter your email address:

Categories