| Re: How do you back up data? |
| by phppp on 2004/7/5 15:21:12 Quote:
I used this. It worked well. However, importing is till a problem when transfering to another server. Any feasible solution by phpmyadmin without 3rd part software? |
| Re: How do you back up data? |
| by Dave_L on 2004/7/5 14:52:23 If you have a recent version of phpMyAdmin, you can configure it (in its config.ini.php file) to export and import using local files, rather than uploading and downloading. I had some difficulty figuring out how to specify the right paths for that, but here's a working example that I recently used: le="color: #000000"><?php /** * Webserver upload/save/import directories */ $cfg['UploadDir'] = './upload'; $cfg['SaveDir'] = './download'; This helps with larger databases, but isn't always adequate if you're on a slow server. Sometimes you have to backup and restore the database in pieces: individual tables, or even pieces of individual tables, which is a big pain to do. Being able to use the mysqldump and MySQL commands from the shell, via SSH, is the best way, if that's available to you. |
| Re: How do you back up data? |
| by tom on 2004/7/5 11:47:00 I have simlar problem, like I said my DB is nearly 200mb now, so SSH is my only option. |
| Re: How do you back up data? |
| by karuna on 2004/7/5 11:41:58 thanks my db is about 40m . the phpmyadmin is only able to backup about 2m. now i use another tools.3 files about only 10kb. but powerful. i tried to turn it into a XOOPS module, but the convetion it can only backup about 4m .when backup a larger db it got a seesion timeout error 
|
| Re: How do you back up data? |
| by tom on 2004/7/5 11:35:49 Never tried it, however when downloading sometimes I believe there are retrictions set on your max DL size, I could be wrong, but isnt this a setting in the PHP it's self? I'm not techie so don't quote me. I say this as the back up tools don't normally work for me, niether does PHPMyAdmin any more, I have to SSH to back mine up now (Nearly 200MB for one) |
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 |
|
|