SitePoint Sponsor |
|
User Tag List
Results 1 to 4 of 4
Thread: how to restore database
-
Dec 27, 2006, 19:27 #1
- 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??
-
Dec 27, 2006, 21:07 #2
- 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.
-
Dec 28, 2006, 07:25 #3
- 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
-
Dec 28, 2006, 08:51 #4
- 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