wolstech

To add to my earlier post, the backups in your home directories represent all the databases we can back up from your account. Databases and tables using InnoDB were not backed up and will be missing/empty because they cannot be backed up with the server crashed (mysql must be running, which it cannot do while /var and /usr are read only). We recommend using your latest pre-crash backup to recover these databases.

Dear Root Admin ! Can you help me backups database vietstar_nuke3 of www.vietstar.tk at Johnny server and let me download via ftp ? Thanks so much ! Check for a .sql file in your home folder. If the backup does not exist, it is because the data was stored in InnoDB format and cannot be backed up. Please use your most recent backup from before the crash instead. It resets at midnight UTC. Your IP suggests you're in Poland, so it resets every day around 1AM for you. It only allows a few hundred accounts per day to prevent overwhelming the server, and because everyone is trying to move right now, it fills quickly. You can see the green bar under "Registration" (the first bar) here to see how long it typically lasts per day: http://heliohost.grd.net.pl/monitor/

The databases are already backed up and are sitting in your home directory for you to download over FTP.

The server suffered file system damage that is beyond repair. You need to back up your files via FTP and sign up on Stevie. Databases have been saved in your home directory as .sql files that you can use to recreate the database on Stevie. Please note that data stored using the InnoDB engine is unavailable for the time being. Please see http://www.helionet.org/index/topic/25786-johnny-backups/ for more information. If you need domains removed from your account, please let us know and we can remove them for you.

@banger: Post moved here: http://www.helionet.org/index/topic/25834-domain-removal/

Johnny is damaged. You need to back up your data via FTP then move to Stevie. See http://www.helionet.org/index/topic/25786-johnny-backups/

@jehurodrig: Topic split to http://www.helionet.org/index/topic/25806-suspended-jehurodr/

You can't. Do you need the domains removed from your account?

Split topic.

Johnny is damaged and no longer works properly. Please sign up again on Stevie.

This support request is being escalated to our root admin.

No problem. Glad to see it's working for you

See http://www.helionet.org/index/topic/25786-johnny-backups/ cPanel and most other services are no longer functional and cannot be repaired due to extensive damage to the /usr and /var file systems. The only thing you can do at this point is use FTP to download your files. If you need your databases, please post the database names and a root admin will attempt to back them up and email them to you. Once you have your data, please sign up on Stevie.

You probably won't be able to delete it with Johnny damaged since it checks the server to verify the password. Just sign up on Stevie. If you have trouble or need a domain removed from your Johnny account, please let us know.

Delete the database user (not the database) in cPanel, then recreate it and reassign it to the database. Be sure to either use the same password as before, or edit your software's config file to use whatever new password you use.

Escalating.

Johnny's file system is damaged, likely beyond repair, so it will never properly work again, at least not as you know him. You need to move to Stevie. Please back up your files over FTP as Krydos mentioned, then list your database names so we can get them backed up and sent to you.

InnoDB went corrupt again. You will need to drop the database, then create a new one and restore your latest backup.

No. FTP is currently the only functioning service on Johnny due to file system damage. Please see http://www.helionet.org/index/topic/25786-johnny-backups/ for information. You can retrieve your files over FTP. If you need databases, please list their names and I'll escalate to have them backed up. Please note that databases and tables using InnoDB cannot be backed up.

You were suspended for sending spam. Krydos or Byron may have more information since I'm unable to find an abuse report your incident.

Johnny hasn't worked in several days now. cPanel is also broken on Johnny.

You can, but MySQL is currently broken on Stevie... If you want to do so anyway, if you have your data backed up, you can just delete your account and sign up again. If you don't have a recent backup, then you can't move since there's no way to make a backup with cPanel broken.

Yeah, you'd need to be willing to sacrifice some of the niceties of InnoDB to use MyISAM. The only reason we recommend it though, is that this will be the 4th InnoDB failure (3 on Stevie, 1 on Johnny) in 3 years, while we've never had a single MyISAM failure in all the years we've been operating. MyISAM by nature of how it works doesn't have nearly as many risks associated with file corruption, and data recovery from the raw .MYI is also much easier if you ever needed to do it. I used to use InnoDB for the same reasons you do, foreign key constraints. It makes it very easy to handle data and easier to develop software for since you can safely assume the foreign key will actually point to a meaningful value or be null (if allowed). You can also do things like CASCADE. If you do convert, you'll need to add code to your program to replicate these benefits on the software side since the database won't do it for you anymore. When he becomes available, you could consider moving to Tommy, since that server will be brand new.

You can't. Krydos has to fix InnoDB...it probably got damaged again from the DB server crashing. We recommend using MyISAM as the storage engine since it's significantly more reliable that InnoDB is. Escalating.

That account is not suspended. However, Johnny is broken at the moment. See http://www.helionet.org/index/topic/25752-johnny-var/ and http://www.helionet.org/index/topic/25748-johnny-usr/