Spinland Posted February 22, 2010 Share Posted February 22, 2010 I've been using the cpanel "backups" feature under "Files" to back up my Wordpress database. Today I happened to unpack one of the files and looked inside, only to see the sql was only there to do some basic set-up. Nothing in there showed my actual blog content gets backed up, no categories, no posts, et cetera. So what is the facility we should be using to back up the actual blog content itself? I tried a forum search but didn't see anything relevant. Thanks! Quote Link to comment Share on other sites More sharing options...
Spinland Posted February 22, 2010 Author Share Posted February 22, 2010 On a related note, assuming there's nothing under cpanel for doing this, I happen to use DBVisualizer for numerous database operations and it has a wonderful database backup utility. All I would need is the direct connect information to hit my blog database and log in remotely. Is that information readily available? Many thanks! Quote Link to comment Share on other sites More sharing options...
TCH-Bruce Posted February 23, 2010 Share Posted February 23, 2010 Follow the directions in this Backup thread. It's what I use to backup six blogs nightly. Quote Link to comment Share on other sites More sharing options...
Spinland Posted February 23, 2010 Author Share Posted February 23, 2010 As always, you guys are great. All done, and thanks! I'm still curious: is it possible to hit the database directly remotely, like via domain_name:port? Thanks again! Quote Link to comment Share on other sites More sharing options...
TCH-Bruce Posted February 23, 2010 Share Posted February 23, 2010 Using what to access the database remotely? You would need to give access to the remote IP address using the Remote Database Access function in cPanel. Quote Link to comment Share on other sites More sharing options...
Spinland Posted February 24, 2010 Author Share Posted February 24, 2010 Okay, and if I don't have a dedicated IP address for my system I'd have to set that up case by case, I imagine? Do you know whether it uses the default MySQL port (I think it's 3306) or a custom one? I write a lot of database access code in Java and Groovy and am thinking of setting up some databases on a site other than localhost to test things out more conveniently. Quote Link to comment Share on other sites More sharing options...
TCH-Bruce Posted February 24, 2010 Share Posted February 24, 2010 3306 is the correct port. Quote Link to comment Share on other sites More sharing options...
Spinland Posted February 24, 2010 Author Share Posted February 24, 2010 Many thanks, as ever. :-) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.