Wingzfan wrote: as of right now it only backs up the sql and not the files or folders. Im hoping someone will make that happen.
um it does go into the contrib folder and its in there lol silly person
[BETA] Automatic Database backup
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations
IMPORTANT: MOD Development Forum rules
On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.
READ: phpBB.com Board-Wide Rules and Regulations
IMPORTANT: MOD Development Forum rules
On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.
-
killyouall
- Registered User
- Posts: 523
- Joined: Tue Oct 18, 2005 3:04 am
- Contact:
-
denskie war
- Registered User
- Posts: 14
- Joined: Wed Dec 13, 2006 12:52 pm
- Contact:
Sorry people for no replies. I was busy lately and I didnt get a topic reply notification in my email soo... I'll take a look at each of your issues when I get some time. I'll deal with the easiest first. denskie war, you are getting this error because you made your table called phpbb1_backup but the script is look for a table names phpbb1backup due to your phpBB database extension. So just rename to table so it looks for the right one.
For the people that are looking for backing up their files, it is in the contrib directory. I do not encourage you to use the script on a account that has many files because the script might not support it.
For the people with high server loads, this script is very diverse. First off, it must execute a query to get the table names in your phpBB database, then it will execute another query for EACH one of the tables to get its structure which is the CREATE TABLE query. then a SELECT query is performed for each one of the tables too to make the INSERT INTO queries, which may take a lot of time if you have a large forum and for sure puts a lot of strain on the MySQL server. As you see it is pretty complicated.
If anybody has and ideas on how to make it put less strain on the server, im listening.
For now, I recomend you exclude uneeded tables such as the search tables which is usually more than half of your database. They can be regenerated using MODS that are out there. I would also exclude tables like logging tables, if you have a mod that does so because they also take up a lot of memory. I will be looking myself on how to reduse the server load.
If you the script isnt obeying the file limit you supplied, this is because the script is not running throught completely due to a PHP error. This may be because is exceeded the PHP error limit to keep the server load down. To prevent this from happening, I recomend you doing the same as above. I will look into that a bit more too.
Thanks, and sorry for the late reply
For the people that are looking for backing up their files, it is in the contrib directory. I do not encourage you to use the script on a account that has many files because the script might not support it.
For the people with high server loads, this script is very diverse. First off, it must execute a query to get the table names in your phpBB database, then it will execute another query for EACH one of the tables to get its structure which is the CREATE TABLE query. then a SELECT query is performed for each one of the tables too to make the INSERT INTO queries, which may take a lot of time if you have a large forum and for sure puts a lot of strain on the MySQL server. As you see it is pretty complicated.
If anybody has and ideas on how to make it put less strain on the server, im listening.
For now, I recomend you exclude uneeded tables such as the search tables which is usually more than half of your database. They can be regenerated using MODS that are out there. I would also exclude tables like logging tables, if you have a mod that does so because they also take up a lot of memory. I will be looking myself on how to reduse the server load.
If you the script isnt obeying the file limit you supplied, this is because the script is not running throught completely due to a PHP error. This may be because is exceeded the PHP error limit to keep the server load down. To prevent this from happening, I recomend you doing the same as above. I will look into that a bit more too.
Thanks, and sorry for the late reply
-
denskie war
- Registered User
- Posts: 14
- Joined: Wed Dec 13, 2006 12:52 pm
- Contact:
hi kkroo, thanks for your help.
But if you look al little bit lower on my tabels list, you see a tabel named phpbb1backup.
So i have the tabel, but it isnt working
* EDIT *
I have deleted all the tables and did the sql again.
I simple changed the phpbb_backup to phpbb1backup and now it workd fine (ill hope)
Im now going to test if it makes backups, thanks for your help!
But if you look al little bit lower on my tabels list, you see a tabel named phpbb1backup.
So i have the tabel, but it isnt working
* EDIT *
I have deleted all the tables and did the sql again.
I simple changed the phpbb_backup to phpbb1backup and now it workd fine (ill hope)
Im now going to test if it makes backups, thanks for your help!
-
Ultima-X97
- Registered User
- Posts: 157
- Joined: Sat Sep 16, 2006 2:49 pm
-
killyouall
- Registered User
- Posts: 523
- Joined: Tue Oct 18, 2005 3:04 am
- Contact:
-
Ultima-X97
- Registered User
- Posts: 157
- Joined: Sat Sep 16, 2006 2:49 pm
The thing about this mod is that it is suppost to support users who arent offered cron in their hosting. It also isnt cron.php that is causing the system overload, it is auto_backup.php. I looked at a few thing about backing up, there is a query that can be ran so that a table can be exported to a file. But the thing about it is that I dont think it is on the older versions of mysql and it only supports mysql. Im still looking around, hopefully something will show up.
-
denskie war
- Registered User
- Posts: 14
- Joined: Wed Dec 13, 2006 12:52 pm
- Contact:
-
denskie war
- Registered User
- Posts: 14
- Joined: Wed Dec 13, 2006 12:52 pm
- Contact: