MySQL for this forum ...

Reply

Join Date: Feb 2002
Posts: 12,035
Reputation: cscgal is a glorious beacon of light cscgal is a glorious beacon of light cscgal is a glorious beacon of light cscgal is a glorious beacon of light cscgal is a glorious beacon of light cscgal is a glorious beacon of light 
Solved Threads: 128
Administrator
Staff Writer
cscgal's Avatar
cscgal cscgal is offline Offline
The Queen of DaniWeb

MySQL for this forum ...

 
0
  #1
Jul 29th, 2002
Okay, so this forum uses PHP with MySQL... I have access to PHPMyAdmin on a remote server. I have been making periodic back-ups (dumps of the tables) but I'm always afraid that when I need them most, they'll fail on me. There isn't by any chance an easier way to back-up an sql database in linux, right? I have ssh access.
Dani the Computer Science Gal
Follow my Twitter feed! twitter.com/daniweb
Reply With Quote Quick reply to this message  
Join Date: Feb 2002
Posts: 1,135
Reputation: samaru is just really nice samaru is just really nice samaru is just really nice samaru is just really nice 
Solved Threads: 6
Team Colleague
samaru's Avatar
samaru samaru is offline Offline
a.k.a inscissor

Re:MySQL for this forum ...

 
0
  #2
Jul 31st, 2002
You can go two ways: using the command "mysqldump" which generates a text file of sql commands that would generate your current database. This is what I think you're doing now. The other way is to just copy the database directly. You might want to do this, but I don't know if you'd have access to the database files. Are you afraid that the backup file will not work correctly when restoring? You should try (if you haven't done so) set up some sort of schedule so it backs up the db once in a while.
Check out my blog at http://www.shinylight.com for more stuff about web dev.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC