1. This website uses cookies. By continuing to use this website you are giving consent to cookies being used.
    For information on cookies and how you can disable them visit our Cookie Usage page.
    Dismiss Notice

PHP Retore database !

Discussion in 'Web Development' started by camihuvn, Mar 7, 2006.

  1. camihuvn

    camihuvn New Member

    Hi !
    I have a database of forum, size is 20 Mb
    i can't retore it...please help me.
    thank a lot
     
  2. Mimoun

    Mimoun Administrator Staff Member Director Verified Member

    Do you have a backup of it? If so what kind of backup a sql file?
    Which database type is it? Mysql?
     
  3. themaximus

    themaximus New Member

    ...

    i have a same problem i have mysql database backup, tried to use my phpadmin to restore but was not able to find a place that will restore the database :(
     
  4. Scoooooty

    Scoooooty Member

    Im not sure because I have never used backups b4 but cant you just delete your forum thats having problems then copy and paste your backup using FTP?
     
  5. orpheusreborn

    orpheusreborn New Member

    themaximus....wht version of mysql?

    some general instructions:

    1. log on to phpmyadmin
    2.select your database and delete it. If you cant do it graphically, run this query,
    Code:
    DROP DATABASE your_db_name 
    You have to open the sql query window to do this. Look under the phpmyadmin logo on the left hand navigation bar. The first small simbol tht says sql will open up the sql query window.

    3. Ok. Now select the import files tab from this window (sql query window). Browse for your db backup.sql file and press go. IT will take a bit of time, but should work out fine at the end.

    Good luck.
     
  6. camihuvn

    camihuvn New Member

    I retored, so i use bigdump file.
    Thank all for support