| | |
MySQL for this forum ...
Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
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.
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.
![]() |
Similar Threads
- How do I load MYSQL onto my website for my use? (MySQL)
- I want to create my own custom PHP,MySQL forum (PHP)
- New to MySql.....Help (MS SQL)
- Help With Messages in Mysql Stop Overwriting (PHP)
- Show subforums on the forum index (DaniWeb Community Feedback)
- serch mysql for many fields (PHP)
- new to php, need help adding a forum (PHP)
Other Threads in the MySQL Forum
- Previous Thread: MySQL vs. PostgreSQL
- Next Thread: MySQL to be included with NetWare 6, Essbase
| Thread Tools | Search this Thread |
agplv3 alfresco api artisticlicense aws bizspark breathalyzer camparingtocolumns changingprices cmg communityjournalism contentmanagement contractors copyright count court crm database design developer development distinct drupal dui ec2 email enterprise eudora facebook form foss gnu government gpl greenit groklaw groupware hiring hyperic images innerjoins insert ip joebrockmeier join journalism keyword keywords kickfire laptop law legal license licensing linux maintenance managing mariadb matchingcolumns metron micromanage microsoft microsoftexchange mindtouch montywidenius mozilla multiple music mysql mysqlcolumnupdating mysqldatetimeordermax() mysqlindex mysqlinternalqueries mysqlquery mysqlsearch news open-xchange opendatabasealliance opengovernment opensource oracle penelope php query referencedesign reorderingcolumns resultset saas select sharepoint simpledb sourcecode spotify sql sugarcrm syntax techsupport thunderbird transparency virtualization







