MySQL Forums
Forum List  »  Backup

Re: Create and Restore
Posted by: Doug Stroud
Date: October 21, 2005 05:31AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
4278
October 19, 2005 01:03AM
2925
October 20, 2005 07:59AM
Re: Create and Restore
2645
October 21, 2005 05:31AM
2928
October 21, 2005 05:39AM
2577
October 21, 2005 05:43AM
2806
October 21, 2005 07:33AM
2669
October 21, 2005 07:39AM
2602
October 21, 2005 07:45AM
2552
October 21, 2005 07:49AM
2688
October 21, 2005 08:33AM
2832
October 21, 2005 09:30AM
2516
November 24, 2005 10:55PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.