Retore database !

Discussion in 'PHP and MySQL' started by camihuvn, Mar 7, 2006.

  1. 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 Administrator

    Do you have a backup of it? If so what kind of backup a sql file?
    Which database type is it? Mysql?
  3. 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 New 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 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 New Member

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