are my sql backups working right?

[bluevoodu]

I have 73 members, and nearly 20000 posts (in 1107 topics)... and I am only getting 656Kb sized backups.

I used to get about 1.2 megs earlier on.  When I did the forum maintenance... it was dropped to 500Kb for the longest time.   Then one day, It was about 5-6 megs large and was like that for a few weeks (even while I was doing the forum maintenance).  But  the last 2 weeks... the backup size has been down to 600-656 Kb.

Is there something wrong?

thanks for your help.
†B†V†

[Ben_S]

Deffinatly not working, open the file with notepad and check the bottom line.

[bluevoodu]

Here is what I see

Koodi [Valitse] Laajenna

<br />
<b>Fatal error</b>:  Allowed memory size of 8388608 bytes exhausted at (null):0 (tried to allocate 1823 bytes) in <b>/home/www/********/forums/Sources/DumpDatabase.php</b> on line <b>218</b><br />


I bleeped out my server name

Looks like we have an error......

Thanks,
†B†V†

[bluevoodu]

anyone?


†B†V†

[andrea]

Do you have shell access or can you activate crontabs on your server? If so you can dump the database with a script. If not ask your host to pass you a database dump and move your host asap after you got the complete dump.

[[Unknown]]

You might try my create_backup.php I'm creating, but it's not totally done being tested...

-[Unknown]

[bluevoodu]

Do you have shell access or can you activate crontabs on your server? If so you can dump the database with a script. If not ask your host to pass you a database dump and move your host asap after you got the complete dump.

Why move my host?  I can get to the shell, yes.

You might try my create_backup.php I'm creating, but it's not totally done being tested...

How stable is that?
*no offense... just asking *

†B†V†

[andrea]

If you have shell access then you can use the shell commands or the shell scripts which are listed in this thread:

http://www.yabbse.org/community/index.php?thread=15902

[bluevoodu]

I understand that... but I am more curious of why you said "move your host"

why is that?

†B†V†

[andrea]

I only wrote that in case you haven't shell access or crontabs. Since you wrote you cannot dump the full database with php. It is important that you can dump the full forum database somehow. If you have shell access everything should be fine.

[bluevoodu]

so... does anyone know why I cannot?

or I what I need to fix this? I want to be able to sql backup in the mainenance section.

†B†V†

[[Unknown]]

If you want that, you'll need to ask your host to increase the allowed memory_limit....

-[Unknown]

[[Unknown]]

Okay, you can *try* finding the following in Sources/DumpDatabase.php:

Koodi [Valitse] Laajenna

@set_time_limit(600);

Below it, add:

Koodi [Valitse] Laajenna

@ini_set('memory_limit', '128M');

Any help?

-[Unknown]

[bluevoodu]

I'll try this shortly.  I appreciate the help!  I am sure everything will be cool once I get  to the dedicated server though.

can I ask... what will the effect of this be?
IE will there be any slow down?  or any negative effects?



†B†V†

[[Unknown]]

If it works, it will take a very long time, but you'll get the whole backup.

-[Unknown]

[bluevoodu]

it did not work.... what other solutions are there?

Thanks for your help!  I do appreciate it.
†B†V†

[bluevoodu]

what memory limit would I need increase to? In case I need to ask..

just curious.

thanks,
†B†V†

[[Unknown]]

You'll want it increased to about the size of your database, I'm afraid.

-[Unknown]

[bluevoodu]

The DB size is 50 megs  that doesn't seem like a big amount of memory....   

I'll give that a shot.

†B†V†

[bluevoodu]

well... I have a problem, I can only have 8 megs at this time.

Once I get to my dedicated server, there won't be any problems.... but until then..... what is the best solution?

I gotta get a good backup... Its been..... FOREVER since I was able to get a good one.

†B†V†