943,398 Members | Top Members by Rank

Ad:
  • MySQL Discussion Thread
  • Unsolved
  • Views: 3972
  • MySQL RSS
Jul 29th, 2002
0

MySQL for this forum ...

Expand Post »
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.
Similar Threads
Administrator
Staff Writer
Reputation Points: 1422
Solved Threads: 162
The Queen of DaniWeb
cscgal is offline Offline
13,645 posts
since Feb 2002
Jul 31st, 2002
0

Re:MySQL for this forum ...

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.
Team Colleague
Reputation Points: 262
Solved Threads: 18
a.k.a inscissor
samaru is offline Offline
1,227 posts
since Feb 2002

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MySQL Forum Timeline: MySQL vs. PostgreSQL
Next Thread in MySQL Forum Timeline: MySQL to be included with NetWare 6, Essbase





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC