Click here to Skip to main content
12,820,174 members (21,957 online)
   

Database

 
GeneralRe: SQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. Pin
Mycroft Holmes28-Apr-13 13:49
professionalMycroft Holmes28-Apr-13 13:49 
AnswerAttached not seen over network still - will try ID values but .... Pin
PrissySC7-May-13 8:07
memberPrissySC7-May-13 8:07 
QuestionHow do I get the SSRS Report Mgr to work with a custom security extension? Pin
Member 767590023-Apr-13 7:31
memberMember 767590023-Apr-13 7:31 
QuestionTrouble restoring a mysql database Pin
savedlema22-Apr-13 8:21
membersavedlema22-Apr-13 8:21 
Dear friends,

For days now, I have been trying to restore a backup of the database (with command prompt) I had made with mysqldump. This is my line of code.

"C:\Program Files\MySQL\MySQL Server 5.5\mysql --user=root --password=mypassword --host= localhost --port= 3306 --database=dbname < C:/Backup/dbname.sql"

I get "The filename, directory name, or volume lable syntax is incorrect" error messsage. I have googled for this error to no avail as to do with mysql.

- My mysql server is up and running with no problem. (Even the mysqldump command works)
-Problem is the same even if I open the command prompt from C:\Program Files\MySQL\MySQL Server 5.5\mysql
-I have tried to remove "", did not help.
- I tried to change / with \ but no success.

For this one, I will really appreciate any help.
AnswerRe: Trouble restoring a mysql database Pin
Bernhard Hiller22-Apr-13 22:33
professionalBernhard Hiller22-Apr-13 22:33 
GeneralRe: Trouble restoring a mysql database Pin
savedlema2-May-13 0:44
membersavedlema2-May-13 0:44 
QuestionBack up database Error Pin
sara-setare20-Apr-13 22:37
membersara-setare20-Apr-13 22:37 
AnswerRe: Back up database Error Pin
Mycroft Holmes21-Apr-13 1:48
professionalMycroft Holmes21-Apr-13 1:48 
GeneralRe: Back up database Error Pin
sara-setare21-Apr-13 3:41
membersara-setare21-Apr-13 3:41 
AnswerRe: Back up database Error Pin
Eddy Vluggen21-Apr-13 9:45
mvpEddy Vluggen21-Apr-13 9:45 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.170308.1 | Last Updated 24 Mar 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid