wolstech
-
Posts
18,336 -
Joined
-
Last visited
-
Days Won
702
Everything posted by wolstech
-
Yeah, I missed the edit. Surprising to see indexes eat so much space, but if you can drop some of the indexes to make it fit, that works
-
Overhead possibly, but that seems excessive. I'm not too sure what's up with this at this point. I didn't realize the 213MB was an uncompressed dump (I thought it was compressed, which would make 840 reasonable)...the dump as you said is nearly always larger than the DB produces. As for another place to host this, I'm not sure...I've always had mine run here or on a local PC.
-
Yes, I would drop that database and host it elsewhere. It's far too large to host here. I thought the DB was 213MB uncompressed. That size would be fine, but 843MB is not. Very surprised to see it actually import and not get counted as used space though... Out of curiosity, what is that database used for? I don't know of many websites other than gigantic forums that need databases that large.
-
Database Connection Error
wolstech replied to Indexofsociety's topic in Website Management and Coding
Did you make sure the database user has the correct password? The database user's password should match the one in the configuration.php. Also, be sure to assign the user to your database in cpanel (many forget this step). -
I'm honestly not sure what file system we have on the server... An 840MB database should be WAY too large to host here. Cpanel sometimes takes a few hours to update its meter. If its meter hasn't jumped by now, cPanel is probably not counting pg usage.
-
Didn't realize you were on johnny...Johnny (or more specifically, Charlie, which hosts Johnny) suffered hardware failure several days back, so yes. No idea if or when it'll be fixed...it's acting like the hard disk died in the server. You can sign up on Stevie if you want (you won't be able to delete the Johnny account, so don't bother trying).
-
Database Connection Error
wolstech replied to Indexofsociety's topic in Website Management and Coding
Is the database hosted on Johnny by chance (I know silly question, but we do have users who use Johnny's MySQL with a Stevie account). -
Upload, import, then immediately delete the dump file. If I remember right, it should let you go over for a short period, exactly for this reason. Just be sure to get back under 500 ASAP, staying over for too long may get you suspended. I know backups in cpanel will let you go over when you create/restore them there. Not sure if phppgadmin will or not (worst case is it fails with a disk full message). Just try and see If you get suspended for space, just let me know and I'll unsuspend you since I know why you went over.
-
This support request is being escalated to our root admin.
-
It cannot be recovered. Starting over is the only option at this point. You should create new databases and reinstall your software as you did originally. Your forum content is lost, so you'll need to start fresh there. The sourcebans site I cannot imagine being terribly difficult to set up again. You should be able to just reinstall that. In the future, make a backup regularly in cPanel using the full backup option so you get backups of databases and files along with other things such as email forwarder settings. Download the resulting file and save it so you can restore your stuff if the server acts up later. I had to use my backups when this broke...this was my second time I had to use my backups in 4 years. We always say to make them because there will likely come a day when you will need them.
-
Well, that answers that...you'll need to start over In the future, please be sure to make regular backups of your account. If your data changes constantly, I would back up once a week. If not, I would suggest monthly.
-
Escalating. @krydos: do we have any database backups for any databases on this account?
-
Just sign up again. You can't delete your Johnny account because Johnny crashed.
-
Yes
-
If it is hardware failure as suspected, it won't be fixed until Ashoat goes to California next. It may come up if krydos can get it running, but it currently doesn't want to stay up once we get it to boot. Runs for a few hours and dies.
-
Just wanted to make sure. The way he's phrasing it makes it sound like he thinks making a backup now can fix it.
-
Change your cpanel password, then log out and in again.
-
Looks like Johnny crashed again: http://heliohost.grd.net.pl/monitor/
-
This is the same issue everyone else had. Change your cpanel password (be sure to select synchronize MySQL password), then log out and in again. After that, delete the database users and recreate them, then reassign them. You also should check in phpmyadmin to make sure the data is still there. If your databases used innodb, your data is likely gone. Looks like Johnny crashed again. http://heliohost.grd.net.pl/monitor/
-
Your can't upgrade it and there are no plans to upgrade on Stevie. I would normally recommend Johnny since he has 5.4, but seeing his hardware is failing, I do not suggest moving over there at this time. Look for an older version of your software.
-
Make a new topic for it since I have to escalate that. Also, Heliohost.org is back up now, but Johnny is not (yet). You can register on Stevie if you want, but wait on deleting your Johnny account until he comes up (see here: http://heliohost.grd.net.pl/monitor/) If you want, just let me know here once you have the Stevie account and I'll take care of the Johnny account for you.
-
Had it been paid for? If so, please post the transaction ID from the paypal payment so it can be added to your account.
-
Change your cPanel password (select "Synchronize MySQL Password"), then log out and in again.
-
@Marko30: The backup he just created cannot be used to fix his databases. The backup he just made will actually be missing his data...he just backed up the empty databases. The one he made now is only good for his restoring files and any databases that aren't damaged. It's better than nothing, but it's not a fix for his lost data. He needs a backup from before the data got lost (basically, he needs a backup made in the first week of June or before that). If he doesn't have that, the data is permanently lost.
-
You will need to ask for it to be assigned to your Stevie account.
