PhotoPost Community

PhotoPost Community (http://www.photopost.com/forum/)
-   Photopost Pro Bug Reports (http://www.photopost.com/forum/photopost-pro-bug-reports/)
-   -   Error when trying to back up data (http://www.photopost.com/forum/photopost-pro-bug-reports/114549-error-when-trying-back-up-data.html)

sa007 June 23rd, 2005 01:49 PM

Error when trying to back up data
 
How can I preform a back up using phpmyadmin and create a single sql file. However, I am guessing that photopost needs a backup of each table in seperate files. I tried running the back up option on the Admin, but it would say:

Warning: pp_admingroups.sql is 0 bytes or did not get created.Warning: pp_admlog.sql is 0 bytes or did not get created.Warning: pp_categories.sql is 0 bytes or did not get created.Warning: pp_comments.sql is 0 bytes or did not get created.Warning: pp_ecards.sql is 0 bytes or did not get created.Warning: pp_exif.sql is 0 bytes or did not get created.Warning: pp_extrafields.sql is 0 bytes or did not get created.Warning: pp_favorites.sql is 0 bytes or did not get created.Warning: pp_ipcache.sql is 0 bytes or did not get created.Warning: pp_iponline.sql is 0 bytes or did not get created.Warning: pp_laston.sql is 0 bytes or did not get created.Warning: pp_notify.sql is 0 bytes or did not get created.Warning: pp_photoextras.sql is 0 bytes or did not get created.Warning: pp_photos.sql is 0 bytes or did not get created.Warning: pp_photoviews.sql is 0 bytes or did not get created.Warning: pp_settings.sql is 0 bytes or did not get created.Warning: pp_sort.sql is 0 bytes or did not get created.Warning: pp_sortmemb.sql is 0 bytes or did not get created.Warning: pp_usergroups.sql is 0 bytes or did not get created.Warning: pp_users.sql is 0 bytes or did not get created.

I am assuming that i put everything in correctly. This as the path: D:/MySQL/MySQL Server 4.1/bin/mysqldump.exe

And made sure that the account has lock table access. I gave it full global access and also set on the database spefic table access.
What do I have to do to fix this?
Thanks in advance.

Chuck S June 23rd, 2005 02:18 PM

How about the directory to backup to was this set and given READ WRITE EXECUTE PERMISSIONS

sa007 June 23rd, 2005 03:20 PM

I tried changing the permission to the backup folder, but it still doesn't work. I even tried using different folder, but still no luck. I tried changing the persmission on mysql folder and that didn't have an effect.
The files are created, but with nothing in them.
I am using IIS 6 on windows 2003.

Chuck S June 23rd, 2005 03:59 PM

Windows can be a pain with permissions at times. Using phpmyadmin and using the export feature to backup the entire database would work if you can not get permissions sorted.


All times are GMT -5. The time now is 12:00 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97