Anyone know how to do this other than by using the admin control panel (which doesnt work!). It's a MySQL database, and I need to back it up! Thx.
Anyone know how to do this other than by using the admin control panel (which doesnt work!). It's a MySQL database, and I need to back it up! Thx.
The admin panel does work, we use it. Other than that it depends on the OS. If it's Linux you can set a cron job to back it up nightly or in Windows set a task to run every night. If it's just a one off then find the data directory in MySQL, find your database and then back it up
Do you have shell access ? (as in you can log into the command line of the server)...
You can use the mysqldump binary to back it up to a SQL file.
VBulletin provide a "moving servers" guide that explains how to backup using mysqldump.
http://www.vbulletin.com/docs/html/m...servers_backup
"In a world without walls and fences, who needs Windows and Gates?"
or, if you've got phpmyadmin installed you can do an SQL dump via that
(\__/)
(='.'=)
(")_(")
For some reason, using the admin CP method I get errors saying "could not connect to database" after, say, 30 seconds. Cheers for the help, don't have shell access so I'll install phpmyadmin and give it a go
PHP is traditionally setup with a maximum execution time of 30 seconds. Then the script will terminate. Thats why it stops backing up and you get that error.
PHPMyAdmin may well do the same thing. The only true way of backing up a large database (which it sounds like you have) is to use the shell.
How big is your attachment table?
"In a world without walls and fences, who needs Windows and Gates?"
We're running it on a 1&1 business account which doesn't allow cron jobs so I don't expect shell access will be allowed either. Attachments are something like 10MB.
hmm.. if you are on 1&1.. you should already have phpmyadmin installed with your account.
Contact their support for details & explain what you want to do, they will help you
"In a world without walls and fences, who needs Windows and Gates?"
or modify the page on phpmyadmin with the commandwhich means it won't obey the php.ini setting of 30 secondsPHP Code:
set_time_limit(0);
Am uploading phpmyadmin now, doesn't seem to be installed.
The error I get is :
mysql error: MySQL client run out of memory
mysql error number: 2008
hmm, contacting your host's CS Dept sounds like a plan
(\__/)
(='.'=)
(")_(")
Yeah, probably sounds a fair bet.... been trying for ages, wonder if my Business Package is a bit under-specced?
I've got a couple of friends on 1and1.. they have experienced a few glitches. Talk to their support.Originally Posted by PopUpPirate
"In a world without walls and fences, who needs Windows and Gates?"
Spoke to them and sorted out phpmyadmin - turns out that 2/3 of the database is attachments so I guess I can just delete them and it won't cock up anything?
There are currently 1 users browsing this thread. (0 members and 1 guests)