warLog: Date:05-04-2009|04:07

---

If you are facing problem in making queries, database connectivity or anything related to MySQL or any DBMS package feel free to post your problem here.

varun: Date:02-06-2009|23:52

---

Is there any way or code to create Backup of SQL file without logging to the phpmyaDMIN ?

warLog: Date:04-06-2009|14:36

---

Yup you can make use of mysqldump command to to take backup...just make a php sctript to execute this command. I hope u got my point. If you want i will give you the code also.

warLog: Date:09-06-2009|09:12

---

Always check user inputs and never trust on them. If u r not sure about the type of user input then use mysql_real_escape_string() function to prevent SQL Injection.

varun: Date:05-07-2009|04:45

---

any example of mysqldump code ? :P

warLog: Date:19-07-2009|00:45

---

The syntax of mysqldump is:
mysqldump -h [hostname] -u [user] -p [password] > [file]

if hostname is localhost then u can omit this argument. The greater than sign is the output redirection operator which redirect the output to the file. Remember the folder must be writable in which you are redirecting.
now you can make use of this command to take backup. Just make a php script and execute this command.

i hope you have heard about cron. It is a task schedular in unix based OSes. Yuo can schedule tasks directly from your cPanel. You just need to give the command there and the time to execute the command. U ll get a lot of options there whether u want to executer this command daily, weekly, etc. Just do yr experiment.