WampServer

I am a complete begiiner with WAMP and I would welcome help in resolving the following issue. Thus

I have just successfully installed WAMP5 and

1) created a database named backupontology

2) granted all privileges for using that database to

user : (USERNAME REMOVED FOR YOUR PROTECTION MORSE)
pw : (PASSWORD REMOVED FOR YOUR PROTECTION MORSE)

3) I have tried to populate the data base from a zipped dump file
named xxxRelease.zip located in the directory D:/specials/ using the following
MySQL statement:

mysql -u USERNAME-PASSWORD backupontology < D:/specials/xxxRelease.zip

It fails with an error code of 1064 (42000) and the statement that the syntax is wrong. Clearly it is but try as I might I cannot see the error. So I would be very grateful if someone would be kind and point it out to a 'bear of little brain'

many thanks

I edited your post and removed all instances of your password in your post. do not post your passwords here in the forum (or any forum for that matter). these forums are constantly being indexed by both search engines and bots. for example, if google indexed your post before I was able to hide your password, your use id and password are now available for millions to see.

here is how you should have posted your message:

database: backupontology
user : My_User_Name
pw : My_Password

mysql -u My_User_Name -My_Password backupontology < D:/specials/xxxRelease.zip

the easist way to import your database is to use phpmyadmins import feature. first, you need to extract the sql file from your zip file archive. now start phpmyadmin.

1. Once in PhpMyAdmin you will see on the left side a drop down of your databases, select the database you would like to import to (for you select the backupontology database).

4. This will create some tabs at the top of the screen, click on the SQL tab.

5. After clicking on SQL you will see a Text Box area and a file upload option.

6. Click browse on the file upload option and find your .sql file

7. After you have selected the file click GO and it will import your database. It may take a while to complete importing especially if your database is large.