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
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.