Author Topic: Updating Wordpress - Where'd the database go?  (Read 4111 times)

0 Members and 1 Guest are viewing this topic.

jekkal

  • Newbie
  • *
  • Posts: 38
  • Last Resort Volunteer
    • View Profile
    • Last Res0rt - The Cyberpunk Furry Webcomic
Updating Wordpress - Where'd the database go?
« on: September 11, 2009, 06:20:43 pm »
Heyo! Just tried to update wordpress, and of course like a good little vampire I wanted to back up my database first...

... I can't find where to access the PHPMyAdmin interface Like I did before. I looked under "User Services", but I don't see it.

I know Xepher mentioned that he backs up stuff nightly, so should I just go ahead and update (and if it screws up, let him fix it) or what?

Xepher

  • Techsmith
  • Administrator
  • *****
  • Posts: 4,326
  • Illegitimis non carborundum!
    • View Profile
    • Xepher.net
Re: Updating Wordpress - Where'd the database go?
« Reply #1 on: September 11, 2009, 09:12:26 pm »
Well, yes, there are nightly backups. Though doing it yourself is wise, especially if you don't want to wait for me to be around to fix it. The database link is on the user-services page. https://xepher.net/user-services/ It's the big link right in the center that says "Database." :-)

If you run into trouble though, let me know. I'm happy to help.

Databits

  • Global Moderator
  • *****
  • Posts: 1,607
  • Programming's not just a science, it's an art.
    • View Profile
Re: Updating Wordpress - Where'd the database go?
« Reply #2 on: September 11, 2009, 09:19:02 pm »
Actually, I'd use a direct dump. If you have the know-how, log into an ssh, then do:

mysqldump -u username -p databasename > ~/backup-YYYY-MM-DD.sql

Then it'll ask for your password, after you enter that and hit enter it should do a full dump of your database.
(\_/)    ~Relakuyae D'Selemae
(o.O)    
(")_(")  [Libre Office] [Chrome]

Miluette

  • Sr. Member
  • ****
  • Posts: 332
  • C:
    • View Profile
    • Miluette dot com
Re: Updating Wordpress - Where'd the database go?
« Reply #3 on: September 11, 2009, 10:53:32 pm »
There's a WP database backup plugin. You should find it if you search those words. I use that.
And wasn't it you who told me,
"The sun would always chase the day"?