| Re: Backing up my stuffs |
| by Anonymous on 2008/2/12 16:31:46 Quote: paulizaz wrote: Easier than making the backup in the first place  Assuming that you followed the guide in the link that I posted (including checking the "Add DROP TABLE", "Complete inserts" and "Extended inserts" boxes) then all you need to do is: 1. Navigate to your database 2. Click on the "SQL" tab 3. Browse to the backed up database on your PC (I always gzip mine, so the filename is "databasename.sql.gz") 4. Click on the "Go" button. This will drop existing tables where they have the same name as those being written then recreate/populate them. Where no tables of the same name exist then they will be created and populated. IMHO, forget the XOOPS modules and other tools. Just use phpmyadmin (or your host's CPanel if it has it included). HTH |
| Re: Backing up my stuffs |
| by paulizaz on 2008/2/12 16:10:17 Thanks for that, How about restoring the data using phpmyadmin? I have downloaded and tested the Backup module 'XOOPS DB Backup & Restore 3.0' to XOOPS 2.0.16. 1) Downloading to server did not seem to do anything 2) Clicking restore shows an empty drop down box - I dont think it works? Anyone had any experience with this and/or can shed light? |
| Re: Backing up my stuffs |
| by Anonymous on 2008/2/6 17:05:30 Quote: paulizaz wrote: Yep!! See this guide: http://www.tamba2.org.uk/wordpress/backup/ Quote: paulizaz wrote: Pretty good I should think. Restoring from large .sql backup files is another issue as many hosts have a maximum filesize limit. Use one of the compression options and phpmyadmin can read directly from these. |
| Re: Backing up my stuffs |
| by paulizaz on 2008/2/6 16:13:32 How do you backup using phpMyAdmin, using export? How efficient is this for very large voumes of data? |
| Re: Backing up my stuffs |
| by Anonymous on 2008/2/6 13:42:43 The most important thing to backup is your database. With regard to files backup, most files don't change with time. More likely is the scenario where users upload additional files like photos, etc. It is these additional files that you will need to backup periodically. As websmaster, you will know what your site's users are allowed to upload and where, so backing up shouldn't be that onerous a task. I keep a copy of my website on my PC and backup my database daily via my host's CPanel (which includes phpmyadmin). Once a week or so I download any newly uploaded files via my FTP client by synching the PC's folders with those on the server. The database backup takes a few seconds (I save it as a gzip file) and the remote file-synch doesn't take long either. |
Search
Recent Posts
Who's Online
Donat-O-Meter
| Stats | |
| Goal: | $15.00 |
| Due Date: | Jul 31 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $15.00 |
|
|