Re: Create and Restore

[Doug Stroud]

Umesh,
I attempted the instructions from your post and was unsuccessful.
So let me update my original post to provide greater detail.

Currently, I have installed MySQL, 4.1, and Administrator 1.1.3 on my home computer and downloaded a copy of a backup file of my database; filename is db_store-20051004022039.sql. MySQL seems to be installed correctly and connected.

I have created a database named Online_Store and would like to copy the structure and the data from the backup file into this new Database. The database is freshly created with nothing, tables, etc...
What would be the procedure, command line syntax be to perform this task?

Pertinent Info:
MySQL Version:
4.1
OS:
Windows 2000
New database on local machine:
Online_Store
Backup File created on webhost server and downloaded to local machine:
db_store-20051004022039.sql
MySQL Directory:
c:\Program Files\MySQL Server 4.1\bin
Backup File Location:
c:\Program Files\MySQL Server 4.1\bin and c:\ (I have made a copy and placed it in both directories for ease of use and locating).

Attempted Commands:

1) mysql -u root -p xxxxx Online_Store < C:\db_store-20051004022039;

Error received: None, but upon finishing the command and clicking "Enter", I receive a blank prompt and a blinking cursor, as if waiting for more instructions.

2) 1) mysql -uroot -pxxxxx Online_Store < C:\db_store-20051004022039;

Same results as previous, I have also removed the semi-colon, prior to clicking "Enter" and those results are the same too.

What to do????

Doug S.