Back it up using command line.
Code: Select all
sudo mysqldump -u username -p database > filename.sql
Is that an SQL command that I can execute in phpmyadmin?
Sounds like you're screwed then. If you don't have a backup (or your host) to restore the missing information there is nothing you can do.
Your conclusion is invalid. A database can double is size over time due to overhead. Optimising regularly with large databases is necessary.
Apparently they didnt even know what the problem was all this time. Sheesh. I set them this angry reply:Hello,
Thank you for your patience while we worked to investigate your server issues . We certainly regret your recent experience as well as our delay in reaching back out to you.
At this point in time we are showing that your server and control panel is functioning properly and all services are u p and running.
We would like to note that we are showing that there was a heavy increase of traffic of IP's belonging to http://huaweicloud.com which appears to be a hosting provider in Beijing. It appears that this increase in traffic ended around 4:50AM UTC on the 19th which translates to 9:50PM on the 18th.
Additionally we have been able to repair all phpbb_search_wordlist and phpbb_posts tables on all 3 of your PHPBB databases without error. If you are still experiencing any problems however please provide additional information so that we can continue our investigation.
In the meantime, do not hesitate to reach back out to us if you have any additional questions or concerns. Also, please feel free to take the survey by clicking the button at the bottom of the email. We would greatly appreciate your feedback.
Didnt you read the ticket? Yes the tables are marked as repaired but the forum posts are all gone! Click on one and see for yourself! I told the guys in live chat ten times to explain it to you! Why didnt they? Wtf? All posts since 2007 are gone! The forum is empty! Somehow the tables ejected all the data connected to them. Specifically table "phpbb_posts". Thats the problem. I thought you were trying to fix that the last 36 hours man? Wtf? What have u been doing?
The post data must still be there because the database is still 2 GB in size. So you gotta reconnect the data to the tables. Like a jigsaw puzzle. Unfortunately there is no recent backup because the shitty VPS u gave me has no room to store backups, unlike shared hosting which is cheaper. And i cant even upgrade! I should sue you guys for this! How can an entire forum just vanish? Data doesnt just disappear. Also deleted files are recoverable. There is even software that can recover deleted files by rescrambling the empty space. So it must be possible. Every problem in computers is repairable.
Do you have some hidden backup of my server?
Please remedy this asap. Im shocked to find out you didnt even know what the problem was. I told support staff many times to explain it to you clearly on the ticket. Why didnt they? Or why didnt you listen?
Click on this topic thread and see what i mean:
http://www.happierabroad.com/forum/view ... 24&t=35122
Its empty. All posts are empty now! I been waiting 36 hours for you to fix it. Do you have any backups or recovery software? If not can you have a pro or expert reconnect the data to the tables? The data must be there because the forum database shows as 2 GB still.
Are you saying some hackers in china crashed my forum? Or was this legit traffic? Why would i receive so many hits from china?
I cant believe i waited 36 hours for nothing. Just to hear that you didnt know what the problem was! Sheesh! You ruined my vacation. And 12 years of work too! I ought to sue you! How can a huge forum just vanish? Come on, get with it please asap!!!!!!!!!
I do optimize regularly but that doesnt change the vast database size it seems.warmweer wrote: ↑Fri Sep 20, 2019 7:14 pmYour conclusion is invalid. A database can double is size over time due to overhead. Optimising regularly with large databases is necessary.
For backups of large databases splitting it into parts may become necessary. The posts_table is one which could be backed up seperately, even split. The search tables needn't be backup at all, if they are lost, they can be rebuilt. The topics_track table is another large one which could be backup up seperately.
And not taking a backup in 6 months? How come? Because the backup function timed out? That's 6 months during which you could have investigated the problem, and a Google search would have given a couple of solutions within 5 minutes. One of them being an offline copy on personal webserver.
It's easy to blame the host (and yes if you hosting account included regular backups, then the host is at fault) but ultimately it is you who should have limited the risks.
If your tables are MyISAM, then recovery may still be possible, if they are INNOdb and the standard repair has failed, I fear the worst and only an expert should touch those tables.
It's a serious failure on the part of an administrator not to have trusted people who can do the job for you, even by paying for them, since then you may eventually have to pay for professional assistance to make up for this lack.
You can ask in the "Wanted!" forum here in this Board.
Please note this is the board which supports phpBB, anything related to server setup and maintenance is not within the scope of it.
Code: Select all
General Error SQL ERROR [ mysqli ] Table './happier2_HappierAbroad/phpbb_search_wordlist' is marked as crashed and last (automatic?) repair failed  SQL SELECT word_id, word_text FROM phpbb_search_wordlist WHERE word_text IN ('btw', 'just', 'checked', 'last', 'backup', 'was', 'over', 'year', 'ago', 'dang', 'but', 'don', 'even', 'know', 'the', 'done', 'correctly', 'because', 'did', 'from', 'cpanel', 'file', 'compression', 'format', 'and', 'about', '200', 'that', 'right', 'for', 'forum', 'database', 'also', 'another', 'reason', 'didn', 'any', 'backups', 'lately', 'every', 'time', 'crashes', 'repair', 'function', 'usually', 'fixes', 'tables', 'posts', 'come', 'back', 'are', 'never', 'lost', 'only', 'this', 'once', 'years', 'crash', 'result', 'table', 'phpbb', 'ejecting', 'all', 'does', 'anyone', 'have', 'idea', 'why', 'might', 'happened', 'eject', 'content', 'like', 'when', 'you', 'fix', 'data', 'still', 'there', 'how', 'could', 'been', 'ejected', 'case', 'many', 'programs', 'can', 'recover', 'deleted', 'files', 'both', 'your', 'phone', 'they', 'rescramble', 'empty', 'space', 'bring', 'with', 'computers', 'anything', 'possible', 'matter', 'technical', 'means', 'recovered', 'urgent', 'has', 'resulted', 'post', 'gone') BACKTRACE FILE: (not given by php) LINE: (not given by php) CALL: msg_handler() FILE: [ROOT]/phpbb/db/driver/driver.php LINE: 993 CALL: trigger_error() FILE: [ROOT]/phpbb/db/driver/mysqli.php LINE: 193 CALL: phpbb\db\driver\driver->sql_error() FILE: [ROOT]/phpbb/db/driver/factory.php LINE: 329 CALL: phpbb\db\driver\mysqli->sql_query() FILE: [ROOT]/phpbb/search/fulltext_native.php LINE: 1451 CALL: phpbb\db\driver\factory->sql_query() FILE: [ROOT]/includes/functions_posting.php LINE: 2209 CALL: phpbb\search\fulltext_native->index() FILE: [ROOT]/posting.php LINE: 1445 CALL: submit_post()