How do I properly back up and name mySQL database created from a wordpress blog? There must be at least 100 other people who have this question because I know there are many others who are running a wordpress blog with a MySQL backend. As the postings start to increase in number I realize it is probably a good idea to start backing up the database (just in case). Surely there are others who need to start doing this too to protect their precious articles? This screenshot is of the EXPORT tab in php myadmin: http://www.flickr.com/photos/46088927@N00/8691404/ I am really not sure what to check and what not to check. Also I am not sure of the proper way to name the file name template? Also under the 'Data' Section and then 'Export type', do I select INSERT UPDATE or REPLACE ? Should I just leave the default settings and then just name the file and export it? Thanks in advance for any tips.
Click on Select All, to select all tables under SQL Options, only have Structure selected, unselect the other 2 and keep the Data as it is, and then click on Go. Save the file on your computer, and name it with the db name and a date so that you remember. You are all ste. If ever you need it back, you can create a new db, and then just import this SQL file, and you will be ALL SET. Good Luck.