1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

PhpMyAdmin

Discussion in 'Web Development & Web Hosting' started by jackd, Aug 22, 2006.

  1. jackd

    jackd Megabyte Poster

    555
    7
    64
    Is there a script i could use to restore a full database from a .sql file i have. Im not restoring on top of a database. Is this possible (the file is on my web server) if so how.

    Thanks Jack
     
  2. SimonV

    SimonV Petabyte Poster Administrator

    6,616
    149
    228
    If you have your own host you can install phpmyadmin and import the .sql file, if the file is large then phpmyadmin will time out so you may need to use other methods. Does your host support SSH you could use something like putty to upload the file. Failing that try bigdump.
     
    Certifications: MOS Master 2003, CompTIA A+, MCSA:M, MCSE
    WIP: Keeping CF Alive...
  3. jackd

    jackd Megabyte Poster

    555
    7
    64
    My Hosts got phpmyadmin by default, thanks si im off to try some of those methods!

    Jackd
     
  4. jackd

    jackd Megabyte Poster

    555
    7
    64
    PhpMyAdmin should work and ive figured out what im going to do with it. But unfortunatley i need to wait till i get home to try it.
     
  5. Mr.Cheeks

    Mr.Cheeks 1st ever Gold Member! Gold Member

    5,369
    85
    190
    so are you in school now Jack?
     
  6. jackd

    jackd Megabyte Poster

    555
    7
    64
    No im with a friend, i think ive got another 2 weeks off something like that i think because my birthday is on sunday so it must be another 2 weeks
     
  7. Mr.Cheeks

    Mr.Cheeks 1st ever Gold Member! Gold Member

    5,369
    85
    190
    you enjoy yourself Jack, cuz when school starts, things are never the same, until the next hols...

    btw: hope your not smoking behind the shed! :biggrin
     
  8. jackd

    jackd Megabyte Poster

    555
    7
    64
    CM, LOL! Smoking Behind The Shed :biggrin
     
  9. hbroomhall

    hbroomhall Petabyte Poster Gold Member

    6,623
    115
    224
    Depends on what is actualy in the .sql file, but doing something like
    Code:
    mysql < query.sql
    should be all you need.

    Harry.
     
    Certifications: ECDL A+ Network+ i-Net+
    WIP: Server+
  10. jackd

    jackd Megabyte Poster

    555
    7
    64
    Thanks Harry Ill tell you the results soon
     
  11. jackd

    jackd Megabyte Poster

    555
    7
    64
    Yes i got it working with bigdump though i had to edit the dump a bit. Phpmyadmin just kept timing out. Thank you everybody who contributed here. :biggrin

    Jack
     
  12. jodsclass

    jodsclass Byte Poster

    170
    3
    39
    Get hold of a copy of Mysql front. Its a great frontend for mysql and runs on your pc so doesnt present the same security risks as using phpmyadmin (looking at our server logs at work, people try every combination of url to get to phpmyadmin on your site in the hope and getting in and messing up your database). We always use Mysql Front at work, and its really handy. On the downside, it has been discontinued due to legal reasons http://www.mysqlfront.de/ but you can still get copies here and there. Also good when using large sql dumps (we backup our databases for clients which run into the excess of 100+mb).

    If you can get a copy of Mysql front, you will love it.

    Jodsclass
     
    Certifications: BSc IT & Web Development
    WIP: MSc Advanced Computing, Oracle Cert
  13. jackd

    jackd Megabyte Poster

    555
    7
    64
    Thanks I'll try that later :biggrin

    Jack
     

Share This Page

Loading...