SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Enthusiast
    Join Date
    Oct 2004
    Location
    Thailand
    Posts
    70
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    how to restore database

    I think i will have to da a full resortation of a database.

    lets assume old database is deleted.

    So I go to my hosting control panel and create a new mysql database
    Use same username and password as used in original

    open phpmyadmin and do to the new database and select import-then import the file that I have as a backup--i have a file that I exported as a text file-a full databse export. it is about 4 mb so I hope can do it at one time

    Is that basically how I can do it??

  2. #2
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    yes. just make sure the dump file doesn't have aany CREATE DATABASE or DROP DATABASE statements.

  3. #3
    SitePoint Enthusiast
    Join Date
    Oct 2004
    Location
    Thailand
    Posts
    70
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I am ready to import but alas my file is to big to import. I need to find a way to split it.

    any suggestions?


    i have 2 files--1 os a full database export which i saved to my c drive--about 8MB

    and the other is a sql.dump file that was created using the directory software from its admin panel--that one saved the file on the server and it is only about 5 mbs

    i am not sure how they differ opther thanthe size

  4. #4
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    open them up in a text editor and look. if they're just a series of SQL statements, then you can split the file on statement boundaries.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •