|
Joined: Jun 2006
Posts: 136
member
|
member
Joined: Jun 2006
Posts: 136 |
I just tried to backup my data files, and got this error about half-way through the procedure:
Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 3383773 bytes) in /home/www/jakchat/forums/admin/dodbbackup.php on line 157
any thoughts?
Last edited by Rick; 12/03/2006 2:05 PM.
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
Easy, your alotted memory from your server was completely used... You had used 8388608 bytes (8 megabytes) and the script tried to use 3383773 additional bytes (3.2270174 megabytes).
Your webhost would have to increase the php memory limit which would be doubtful in most cases (16mb is a nice round upgrade number to request).
Your best bet however wouild be to run backups from command line, they're much faster and don't rely on the php variables.
|
|
|
|
Joined: Jun 2006
Posts: 136
member
|
member
Joined: Jun 2006
Posts: 136 |
thanks for that. how do run backups from the command line? (you mean the mysql command line i presume).
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
Nope, I mean through an SSH or Telnet session using the mysqldump command: mysqldump -uusername -ppassword database_name > database_name.sql Whichever directory you issue the command from will be where your database_name.sql file will be created; additionally you can specify a path before database_name.sql. How, if you have PHPMyAdmin you could create an archive (tar, tar.gz, .zip, etc) of yoru forums which will download much faster, but depending on the size of your forums I'm not sure if it'd time out or not going this route.
|
|
|
|
Joined: Jun 2006
Posts: 136
member
|
member
Joined: Jun 2006
Posts: 136 |
i could not get database_name to work (i don't know the names of the databases, but i noticed an option for "all-databases" and i used that instead.
mysqldump -hhostname -uusername -ppassword --all-databases > mybackup.sql
this means, of course, that all the databases are in one file. does that matter??
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
database name woudl be whatever your database name is; as I don't know your setup I just put "database name" in there... You can get the name of the database that UBB is using out of your configuration file...
As you can see fromt he ines i posted, you'd have to replace "username" "password" and "databasename" with the appropraite information; hostname shouldn't have to be used though since it'll by default try localhost.
|
|
|
|
Joined: Jun 2006
Posts: 136
member
|
member
Joined: Jun 2006
Posts: 136 |
i tried without using hostname, but it didn't work for me on my system ... obviously my localhost is not the same as my mysql hostname.
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
i tried without using hostname, but it didn't work for me on my system ... obviously my localhost is not the same as my mysql hostname. ahh, in that case your mysql username probably isn't set to accept connections from localhost (probably just the loopback address) I hope that you got your backup built from the command line though
|
|
|
|
Joined: Jun 2006
Posts: 136
member
|
member
Joined: Jun 2006
Posts: 136 |
I hope that you got your backup built from the command line though yes, the command-line method worked just fine, and very fast!
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
I hope that you got your backup built from the command line though yes, the command-line method worked just fine, and very fast! lol indeed fast... generally though I woudln't recommend using the all-databases flag though, since i'tll backup every db you have access to (and on a missconfigured server you may snag crap you won't want or that aren't your db's), instead you shoudl specify the databases that you want specifically.
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
If you have command line access to the server you can also connect to MySQL then run
show databases;
Though your control panel should also tell you the name and path of your database.
Run a CRON job if on Linux or Scheduled Job on Windows and backup the database and Website every day would be my recommendation. I back mine up each day and then RAR them so the size is acceptable to me.
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
I have a monthly cron set to backup specific paths and ftp files to my local server... For my SQL files I backup the raw SQL storage directories, for the time being anyhow
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
Well my next step will be to FTP the backups to another site on another server at least once a week just in case the hard drives fail or something on the main site, the most I could ever really loose is a week of posts. That is a worse case scenario.
If I had physical access I could hook a tape drive or external drive to the system - but since the site is about 8,000 miles away I don't think that will happen.
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
My setup is as follows: 1. Server creates backup according to specific directories i wish backed up; this is done to a temp directory. 2. ncftp is set to ftp all files to a remote host. 3. Remote host (my home development machine) sits and recieves files, very litle that i have to do, but I can backup files in house through the dvdrw drivves n the server (which works out fairly well)
I went through ncftp and customized my settings, and have everything issued through a cronjob, I could ajust the crontask to run however often as needed (should I be that anal retentive);
I could also take and setup a seperate task to do just the db or any other set of db's to account for forum data that i'd want backed up.
Everything ofcoarse is tarred before transferred over, i have it done by sites (from my VPS); I rather enjoy the level of customization that there is, always up to learn hehe
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
Well I just took over as Admin of the site a couple weeks ago after a loss of accounts and no backups.
Got the board back up and running, now have upgraded it, and back it up daily. So it's in much better shape then it was in the past. Had there been a bigger error or full data loss there was no backup period.
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
I have a similar issue with a friends site, the host made no backups, and neither did he; well the host migrated all of his sites to a new server and left my friends on the old one and the bill poped and the server data is magicaly gone; so now theres no hosting, no backups, etc and no one knows what happened...
Pretty scary :/... If we can get data backup I'm going to ensure weekly backups of the database, with monthly backups of the site.
|
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
1 members (Ruben),
814
guests, and
236
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|