backup of mysql
-
hi, I have a WAMP installed on my machine.i have created a website in asp.net and mysql.Now I have this utility called phpmyadmin.I can create a backup of database through this utility.But i cant create it through query.I tried mysqldump utility query.However it didnt work.I want to create backup from the frontend for the user through query. Any help would be greatly appreciated :doh:
-
hi, I have a WAMP installed on my machine.i have created a website in asp.net and mysql.Now I have this utility called phpmyadmin.I can create a backup of database through this utility.But i cant create it through query.I tried mysqldump utility query.However it didnt work.I want to create backup from the frontend for the user through query. Any help would be greatly appreciated :doh:
I strongly suggest to use mysqldump. You can automate it with including just the mysqldump.exe program is quite tiny and you may call it from your program.
-
I strongly suggest to use mysqldump. You can automate it with including just the mysqldump.exe program is quite tiny and you may call it from your program.
Im trying to use it from the command prompt. however it says access denied. my user name is root and no password. pls help!!!!!!! :sigh:
-
Im trying to use it from the command prompt. however it says access denied. my user name is root and no password. pls help!!!!!!! :sigh:
then you'll have to type mysqldump -uroot -p mydatabase and it will prompt for a password. Just hit enter.
-
then you'll have to type mysqldump -uroot -p mydatabase and it will prompt for a password. Just hit enter.
hiiiiiii thanks very much it solved my problem Jose.I would prefer if it is without prompting of the password. Anyway A big thanks to Jose. and if possible solve this problem as well. :)
-
hiiiiiii thanks very much it solved my problem Jose.I would prefer if it is without prompting of the password. Anyway A big thanks to Jose. and if possible solve this problem as well. :)
The only way I know to make this possible is by doing the following: Re-Install MySQL, when configuring for the first time, uncheck the checkbox that says "Change default security settings" And MySQL won't prompt for the password again.