3. Import the lyrics database into your server via the phpAdmin

Discussion in 'Databases' started by Browning, Feb 4, 2008.

  1. #1
    Trying to install a lyrics script.

    This is the instructions from the read me:

    3. Import the lyrics database into your server via the phpAdmin
    Code (markup):
    The sql file is very large. 250MB +

    How do I do this?

    Edit-Found the place where I need to upload the file but it's way beyond the max file size(Max: 51,200 KiB). What to do:(
     
    Browning, Feb 4, 2008 IP
  2. deccanbazaar.biz

    deccanbazaar.biz Banned

    Messages:
    2,349
    Likes Received:
    40
    Best Answers:
    0
    Trophy Points:
    0
    #2
    i can help you quick just need a site wide link from any good of your website :D that is a link back from your proxy website for y proxy website its online proxy
     
    deccanbazaar.biz, Feb 4, 2008 IP
  3. Browning

    Browning Banned

    Messages:
    1,928
    Likes Received:
    29
    Best Answers:
    0
    Trophy Points:
    0
    #3
    You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit
    Code (markup):
    tell me how and I'll give you footer link
     
    Browning, Feb 4, 2008 IP
  4. thsadmin

    thsadmin Notable Member

    Messages:
    4,889
    Likes Received:
    133
    Best Answers:
    1
    Trophy Points:
    240
    Digital Goods:
    2
    #4
    Goodluck Browning - I hope you work it out, sorry but there's not much I can do.
     
    thsadmin, Feb 4, 2008 IP
  5. Browning

    Browning Banned

    Messages:
    1,928
    Likes Received:
    29
    Best Answers:
    0
    Trophy Points:
    0
    #5
    going to try bigdump
     
    Browning, Feb 4, 2008 IP
  6. Bryce

    Bryce Peon

    Messages:
    1,235
    Likes Received:
    93
    Best Answers:
    0
    Trophy Points:
    0
    #6
    If you have remote access to the database in question, you can use Navicat (http://www.navicat.com/) to insert the database. Otherwise you will need to break the database into 5-6 parts and insert them seperately.

    I can help you break the database into smaller components using a perl or php script and if you want to trade the footer link, I'll trade you a link on my PR4 musician resources links page. PM me if you still need help or even if you're just interested in trading links.
     
    Bryce, Feb 5, 2008 IP
  7. thsadmin

    thsadmin Notable Member

    Messages:
    4,889
    Likes Received:
    133
    Best Answers:
    1
    Trophy Points:
    240
    Digital Goods:
    2
    #7
    He finished the install and sites functioning now - thanks anyway Bryce.
     
    thsadmin, Feb 5, 2008 IP
  8. login

    login Notable Member

    Messages:
    8,849
    Likes Received:
    349
    Best Answers:
    0
    Trophy Points:
    280
    #8
    I know that the problem is solved, but here is how I did it the easiest way.
    I just splitted up the db to 6 parts in a text editor and then just imported each part in phpAdmin.
     
    login, Feb 5, 2008 IP
  9. Browning

    Browning Banned

    Messages:
    1,928
    Likes Received:
    29
    Best Answers:
    0
    Trophy Points:
    0
    #9
    well the script already had bigdump with it. so all I had to do was upload the sql, fill in the dump details and wala
     
    Browning, Feb 5, 2008 IP