vb.org Archive - Administrative and Maintenance Tools - vB Database Backup Pro (Lite) for vb 3.6

Page 14 of 16

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)

- - Administrative and Maintenance Tools - vB Database Backup Pro (Lite) for vb 3.6 (https://vborg.vbsupport.ru/showthread.php?t=126925)

LorinPotter

01-29-2008 07:36 PM

Something I didn't find anywhere in this thread is how do you use this backup to do a restore?
TIA

djbaxter

01-30-2008 12:22 AM

Quote:

Originally Posted by LorinPotter (Post 1431975)

Something I didn't find anywhere in this thread is how do you use this backup to do a restore?
TIA

You don't. You import the SQL files via phpMyAdmin.

Paul M

01-30-2008 07:00 AM

or better still, using SSH (if you have access).

peterpigman

01-30-2008 09:00 AM

Will this work on a large db 400+mb?

Paul M

01-30-2008 04:14 PM

Yes.

Caerydd

01-30-2008 05:01 PM

Installed, running beautifully on 3.6.8 RL2. I actually made my own scheduled task, as I didn't realise the hack had already made one, but it's all working great. Thanks very much!

GateKeper

02-04-2008 12:32 PM

Installed and ran this manually, got this error

Quote:

Database Backup
An error occured during the MySQL backup. Details (Could not open Destination SQL file for writing.)

in the mysqlbackupconfig file I used the /backups/ directory, I know this one exists on the server at the root level and I have insured it's 777, seems I am close,,,but still not working...

any further ideas are appreciated...

When you get the time..

Thanks

GK

franzjuve

02-06-2008 12:12 AM

Quote:

Originally Posted by Caerydd (Post 1432595)

Installed, running beautifully on 3.6.8 RL2. I actually made my own scheduled task, as I didn't realise the hack had already made one, but it's all working great. Thanks very much!

Thanks for feedback ;)

i installing too in my 3.6.8 ;)

Animparadise

02-06-2008 12:42 AM

thanks paul , realy great backup system.
is there any problem to do not shutdown forum in backup progress?

if so , just edit : $backup['SHUTDOWN'] = 1; to $backup['SHUTDOWN'] = 0;
??

Paul M

02-06-2008 07:06 AM

I dont use the shutdown and have never had an issue.

scoobasteve

02-06-2008 07:14 AM

I have a dumb question, maybe already been posted before. But what's the difference between this hack and the original backup that ships with vB by default?

Paul M

02-06-2008 10:46 AM

No idea.

Although you can't schedule the default vb one.

GateKeper

02-06-2008 07:21 PM

Quote:

Originally Posted by GateKeper (Post 1436054)

Installed and ran this manually, got this error

in the mysqlbackupconfig file I used the /backups/ directory, I know this one exists on the server at the root level and I have insured it's 777, seems I am close,,,but still not working...

any further ideas are appreciated...

When you get the time..

Thanks

GK

sorry to bump, but is my above line not correct ? I even created a new folder, still no go.

Paul M

02-06-2008 07:42 PM

I cannot help with individual security issues on servers. Your web server does not have permission to write to that folder. Speak to your host.

nuno_oliveira

02-09-2008 05:02 PM

Hi

I have a vbulletin forum that was converted from a phpBB forum. After the conversion the attachment database database table was much larger than the original and now my database has 1,8GB. I need to make a backup, I have tried with this mod, but I got this error

Code:

Database Backup

Processing access : Total Rows = 0

Processing adminhelp : Total Rows = 1394

Processing administrator : Total Rows = 2

Processing adminlog : Total Rows = 6155

Processing adminmessage : Total Rows = 0

Processing adminutil : Total Rows = 1

Processing adv_modules : Total Rows = 22

Processing adv_pages : Total Rows = 1

Processing adv_setting : Total Rows = 122

Processing adv_settinggroup : Total Rows = 3

Processing announcement : Total Rows = 2

Processing announcementread : Total Rows = 386

Processing attachment : Total Rows = 3443



Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 33554431 bytes) in /home/rexfilen/public_html/forum/includes/class_core.php on line 665

sundarmobiles

02-10-2008 07:13 AM

thanks paul thanks for the mod its realy working well in VB 3.6.8 pach level 2 but i have one doubt is it possible to make backup more than 150,200 mb is it possible?.................................

Paul M

02-10-2008 03:12 PM

There are no size limits, but what exactly is 150,200 mb ?

peterpigman

02-10-2008 06:06 PM

How can you check this has done a complete backup? I know my Db is 400+mb as we moved recently, but the backup is only listed as 295mb.

sundarmobiles

02-11-2008 03:41 AM

Quote:

Originally Posted by Paul M (Post 1440144)

There are no size limits, but what exactly is 150,200 mb ?

am not asking exactly like 150,200 mb etc,etc,............... like this

Paul M

02-11-2008 11:26 AM

My database is well over 500mb.

peterpigman

02-11-2008 12:59 PM

Quote:

Originally Posted by peterpigman (Post 1440262)

How can you check this has done a complete backup? I know my Db is 400+mb as we moved recently, but the backup is only listed as 295mb.

?????????:confused:

sundarmobiles

02-11-2008 01:09 PM

Quote:

Originally Posted by Paul M (Post 1440719)

My database is well over 500mb.

ur database is including attachments or without attachments....................................... ...

Paul M

02-11-2008 03:25 PM

Without. We store them in the file system.

Paul M

02-11-2008 03:26 PM

Quote:

Originally Posted by peterpigman (Post 1440749)

?????????:confused:

View the files.

Harley D

02-12-2008 11:05 PM

O.K. I installed this and it works!, Thank you!!!

Now for the bad news....

My site has been hacked and the posts have been deleted.
What do I need to do to restore them, using the backup this mod made?

Thanks.

peterpigman

02-13-2008 08:10 AM

Quote:

Originally Posted by Harley D (Post 1441826)

At a guess I would imagine you need to go to phpMyAdmin and import the post table

Paul M

02-13-2008 11:10 AM

Basically as above, to restore you must import the data back into mysql, using whatever methods are available to you (ssh is best).

Harley D

02-17-2008 01:41 PM

Thanks, for the help and the mod.

Robbey

02-17-2008 10:48 PM

Database Backup

Parse error: syntax error, unexpected T_STRING in /home/tecki/public_html/includes/mysqlbackupconfig.php on line 15

What do I do now?

Paul M

02-18-2008 01:19 AM

Fix the error in your config file is what you do. :)

Whatever you edited (on line 14 I would guess) has a mistake in it that you need to correct.

Robbey

02-18-2008 02:51 AM

Quote:

Originally Posted by Paul M (Post 1445603)

Fix the error in your config file is what you do. :)

Whatever you edited (on line 14 I would guess) has a mistake in it that you need to correct.

I didnt edit anything in that file though.

Paul M

02-18-2008 11:49 AM

Then your file is corrupted. There is no such error in the proper copy.

Robbey

02-18-2008 01:35 PM

Quote:

Originally Posted by Paul M (Post 1445847)

Then your file is corrupted. There is no such error in the proper copy.

I was using notepad, I used wordpad and it made it better, kept on having whacky characters for spaces.

Thanks. Great hack. Worked with no errors.

sparky5693

02-19-2008 02:37 AM

Quote:

Originally Posted by Reven (Post 1152290)

I've added a bit of code into mysqlbackup.php to compress the resultant SQL file with gzip. My database is about 35MB, and it's making it 5MB.

If you want to do the same, here is what to do. Please note, though, that this will only work if you have chosen to combine all data into one SQL file and not split each table into its own file.

File: ./includes/mysqlbackup.php

FIND (lines 525 to 527):

PHP Code:


		
			
                // Free Memory

                $this->MYSQL->free_result($rows);

            }

ADD BELOW:

PHP Code:


		
			
            // Compress file

            if(extension_loaded('zlib') && $this->COMBINE)

            {

                echo "Creating gzip file from SQL file<br />"; vbflush();



                $file = fopen($this->FILE, 'r');

                $data = fread($file, filesize($this->FILE));

                fclose($file);



                $file = gzopen($this->FILE, 'w9');

                gzwrite($file, $data);

                gzclose($file);



                rename($this->FILE, $this->FILE . '.gz');

            }

You must also have the zlib extension compiled into PHP. Most shared hosts will have zlib installed as well as most PHP installations in general. The script will not attempt to compress the file unless zlib is installed. You can find out if you have zlib by entering the Admin CP and going to Maintenance > View PHP Info and looking in the Configuration Command section for '--with-zlib'.

If I start using this, and merge all sql data into the one file as mentioned, do I need to make any other changes to be able to use the backup this will create?

92GreenGT

02-20-2008 10:10 PM

I had this working before, but now that we switched servers I can't figure it out to save my life.

Here is what I have as my path in the backupconfig file:
'/var/www/vhosts/mysite.com/httpdocs/back-up/'

Is this not right for a path? The folder is CHMOD to 777, so techically it should work correct?
I still get the error when I go to "Run Now" on the scheduled task manager. On the main page of the admin panel it says "Server Type - Linux Safe Mode". Does this have any reason as to why I can't get it to work? Thanks!

-Edit-
Where it says mysite.com, I actually have my forum url. I didn't want someone to mention that as a problem, lol.

Paul M

02-21-2008 07:10 PM

Based on that, "../back-up/" should work.

92GreenGT

02-21-2008 10:07 PM

Still doesn't work:

Database Backup

An error occured during the MySQL backup. Details (Could not open Destination SQL file for writing.)

Whats weird, is it seems to make a folder for the backup inside the correct folder, but there is never anything in the folder? If it's creating a folder inside the correct folder, wouldn't that be the correct path?:confused: I can't understand why it would make a folder with the date but be empty? Thanks!

Paul M

02-22-2008 06:07 PM

Sorry but i cant help you with server permissions, talk to your host.

92GreenGT

02-23-2008 01:12 AM

Quote:

Originally Posted by Paul M (Post 1448846)

Sorry but i cant help you with server permissions, talk to your host.

So thats why its making the folder but not putting anything in it becuase its not allowing it to write?

Paul M

02-24-2008 11:46 AM

Quote:

Originally Posted by 92GreenGT (Post 1449086)

So thats why its making the folder but not putting anything in it becuase its not allowing it to write?

Correct, your server is not allowing the write operation.

All times are GMT. The time now is 12:12 AM.

Page 14 of 16

« First

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01952 seconds Memory Usage 1,832KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (2)bbcode_php_printable (14)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: