•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 426,509 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,099 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser: Programming Forums
Views: 2998 | Replies: 1
![]() |
| |
•
•
Join Date: Feb 2002
Location: Lawn Guylen, NY
Posts: 10,905
Reputation:
Rep Power: 32
Solved Threads: 118
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
Do you run a computer-related website? Feature it in our niche link directory!
Do you run a computer-related website? Feature it in our niche link directory!
•
•
Join Date: Feb 2002
Location: Long Island, NY
Posts: 1,134
Reputation:
Rep Power: 12
Solved Threads: 4
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.
_.:: my websites ::._
blog @ www.samaru.net * engi No Jutsu @ www.narutorp.net * portfolio @ shinylight.com
deviantART: inscissor
blog @ www.samaru.net * engi No Jutsu @ www.narutorp.net * portfolio @ shinylight.com
deviantART: inscissor
![]() |
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Similar Threads
- need a good PHP forum script (Existing Scripts)
- FREE forum Hosting-400MB-10GIGS BW,phpBB,SMF,myBB,phpBB RPG,php,25 MySql db's,Z-panel (Web Hosting Deals)
- MySQL Databse Backup For Sale (Websites for Sale)
- URGENT: UBBThreads MySQL database merge (MySQL)
- Cannot install phpBB on Win2K & MySql (Growing an Online Community)
- Backing up a MySQL database (MySQL)
- New to PHP (PHP)
- Does SQL , ORACLE + MySQL support two-byte integers? (Oracle)
- MySQL Reports (MySQL)
Other Threads in the MySQL Forum
- Previous Thread: MySQL vs. PostgreSQL
- Next Thread: MySQL to be included with NetWare 6, Essbase



Hybrid Mode