how to restore database

[mdbusa]

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??

[longneck]

yes. just make sure the dump file doesn't have aany CREATE DATABASE or DROP DATABASE statements.

[mdbusa]

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

[longneck]

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.