Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Page 1 of 2 1 2 LastLast
Results 1 to 10 of 11
  1. #1
    Junior Member chrisr's Avatar
    Join Date
    May 2003
    Posts
    7
    Member #
    1531
    Well, this question is regarding the import of large .SQL Files. I've been running a forum and a downloads page on my database. I have a Databse Backup at 114 megs. I've just converted my server into the CPanel age, which required transfering my files onto a new drive. I've got the files up, but as some of you may know, a Database is an entire site.

    How do I import my SQL file so my website can be restored? I've tried a few tmies in PHPMyadmin but the page just dorta sits there all day and doesnt do anything..

    I hope some of yuo reading this have imported huge SQL backups before and can assist me by directing me to the procedure that you used.

    I searched the forum and browsed topics and didn't find any topics regarding my issue, I appologize if I missed it, just link me to the thread..


    p.s. Great site, very happy to be apart

  2.  

  3. #2
    Senior Member nsr81's Avatar
    Join Date
    Oct 2002
    Posts
    1,132
    Member #
    250
    Liked
    15 times
    Do you have Telnet/SSH access to the server? If so, you can upload the .sql file on the server and run the following command to import it. (make sure that the database is empty, else it might abort with errors if there are no IF EXIST clause to drop the tables)

    Code:
    mysql -u DB_USERNAME -p DB_PASSWORD  DATABASE_NAME < /path/to/sq/dump.sql
    DB_USERNAME: is the username you have in your board's config to let it access the db server.
    DB_PASSWORD: goes with the above (if you leave it out, mysql will ask for it later, in case you wanna keep password out of your history logs).
    DATABASE_NAME:
    and full or rleative path to dump file.

    Remember this needs to executed in a Telnet/SSH session.

    If you don't have SSH access, upload the file and ask your host to run that command. It won't take more than a couple of minutes tops.

    Hope that hleps
    There and Back Again :Ogre:

  4. #3
    Junior Member chrisr's Avatar
    Join Date
    May 2003
    Posts
    7
    Member #
    1531
    That did it. Thank you very much!

  5. #4
    Senior Member nsr81's Avatar
    Join Date
    Oct 2002
    Posts
    1,132
    Member #
    250
    Liked
    15 times
    not a problem
    There and Back Again :Ogre:

  6. #5
    Junior Member Bilal's Avatar
    Join Date
    Jun 2003
    Location
    Planet Bob
    Posts
    8
    Member #
    1851
    I have the same problem of DB import, but I don't have a access to Telnet/SSH! but I have access to PHPmydamin, so I can import my .sql file in my newly created database, I uploaded my .sql on my server?

    Please help, I am a newbie in field of SQL

    Thanks,
    Bilal

  7. #6
    Senior Member filburt1's Avatar
    Join Date
    Jul 2002
    Location
    Maryland, US
    Posts
    11,774
    Member #
    3
    Liked
    21 times
    If the .sql file is pretty tiny, then browse through phpMyAdmin's pages, they'll be an import dump area with a file upload element in a form.

    If the dump is anything but tiny, then you're out of luck. PHP methods of restoring or dumping large amounts of mySQL data are very unreliable due to the default PHP 30 second script timeout.
    filburt1, Web Design Forums.net founder
    Site of the Month contest: submit your site or vote for the winner!

  8. #7
    Junior Member Bilal's Avatar
    Join Date
    Jun 2003
    Location
    Planet Bob
    Posts
    8
    Member #
    1851
    Thanks for the info, my dump file is about 3MB big, Can I use PHPMyAdmin upload option?

  9. #8
    Senior Member filburt1's Avatar
    Join Date
    Jul 2002
    Location
    Maryland, US
    Posts
    11,774
    Member #
    3
    Liked
    21 times
    Possibly, although even that is pushing it.
    filburt1, Web Design Forums.net founder
    Site of the Month contest: submit your site or vote for the winner!

  10. #9
    Junior Member Bilal's Avatar
    Join Date
    Jun 2003
    Location
    Planet Bob
    Posts
    8
    Member #
    1851
    Is there any other application in PHP which import my dumb file in a new empty database, I uploaded the file on my server!

  11. #10
    Senior Member nsr81's Avatar
    Join Date
    Oct 2002
    Posts
    1,132
    Member #
    250
    Liked
    15 times
    Look through http://www.hotscripts.com/PHP/Script...ols/index.html

    You are sure to find something
    There and Back Again :Ogre:


Page 1 of 2 1 2 LastLast

Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 01:07 PM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com