Web Hosting Forums

Results 1 to 6 of 6

This is a discussion on ShoutCast Estimated needed bandwidth in the Hosting Talk & Chit-chat forum
OK... if i have this backup database and i want to restore it on a new webhost... what's hte easiest way. My database is a ...

  1. #1
    JPC Member
    Join Date
    Dec 2006
    Posts
    0

    Fastest way to restore MySQL database

    OK... if i have this backup database and i want to restore it on a new webhost... what's hte easiest way.

    My database is a 5MB SQL file... can phpMyAdmin run the file directly from my PC desktop?

    Or i'll have to insert the content manually?
    Thanks

  2. #2
    DEHE PR manager imported_Robert's Avatar
    Join Date
    Jun 2005
    Posts
    0
    You will need to ask us to enable SSH for you(if you know how to restore the database under SSH) or upload the sql file to your account and ask us to restore it by opening a ticket and providing us with the path to the sql file on your account and the database you want it imported to. This means you will firstly need to create the database in cPanel -> MySQL if it doesn't exist.
    Robert McGregor
    PR manager

    DEHE.com - Definition of Hosting Experts

  3. #3
    New Client Soon
    Guest

    ShoutCast Estimated needed bandwidth

    Hello

    as i found out, that shoutcast is acceptable at dehe
    but i want help in estimating bandwidth needed

    for example:
    the average of listeners = 100 listeners (online)
    and stream rate is 56 kb/s
    and running time is 24/7 = 43200 minute

    so how much is the expected bandwidth?

    i found many calculators, but didnt understand anything from them
    so i requested help here

    Thank You

  4. #4
    consultant Andre's Avatar
    Join Date
    Apr 2005
    Posts
    1,142
    Hi there,

    If you would have 100 listeners online 24/7 at 56kbps, here's a calculation of how much traffic you would use:

    100 x 56 = 5600kbps
    5600kbps = 5600 kilobit per second = 700 kilobytes per second
    700 x 3600 = 2,520,000 kilobytes per hour = 2461 megabytes per hour
    2461 x 24 = 59,064 megabytes per day = 57.68 gigabytes per day
    57.68 x 30 = 1730.4 gigabytes per month
    Andre van Vliet

    DEHE.com - Definition of Hosting Experts

  5. #5
    Loyal Client
    Join Date
    Sep 2005
    Posts
    2
    whats the exact command to import a sql file into an existing db via ssh?

  6. #6
    Jag Veteran imported_Luke's Avatar
    Join Date
    Jun 2006
    Location
    Houston, TX
    Posts
    838
    mysql -h localhost -u$username -p$password $database < $sqldump
    obviously you'de replace $username,$password,$database,$sqldump with actual values.

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
  •