I need help!!!!!
I would like to know how i can restore my mysql db from one form. I got the backup to work using mysqldymp but when I try to restore the .sql file created, nothing I try works.
barneygurl
0
Newbie Poster
Recommended Answers
Jump to PostWhat you have tried ?
How you restore that from command prompt or directly in mysql ?
All 3 Replies
debasisdas
580
Posting Genius
Featured Poster
What you have tried ?
How you restore that from command prompt or directly in mysql ?
barneygurl
0
Newbie Poster
What you have tried ?
How you restore that from command prompt or directly in mysql ?
I have tried to run a shell command
shell("c:\mysql 5.0\mysql -u [username] -p [password] [dbname] < file.sql") and many variations of that for instance with and without spaces between -u and the username and -p and the password but nothing seems to work. I don't get an error though.
indika75
0
Newbie Poster
I could restore the mysql db using the shell. It didn't work when mysql.exe was in its default location. I copied it to my working directory and then it worked!
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.