| Question: |
Hello. Today I created a backup of the site Database Onlyschool.ru base (bulbet_onlysc) was not working, and after operations with the site I can`t recover the database, i.e. the site is not working. please help to restore from Your backup. |
| Answer: |
Hello. how did you create the backup, why did you decide that it is broken? |
| Question: |
I created a backup in phpmyadmin. ago is not restored even after a full cleanup of the base. size suspicious 2MB for Drupal 7 (as is now know) should be about 10MB and more |
| Answer: |
what oshibku you received when you restore? you file opened? is there text? |
| Answer: |
database restored. |
| Question: |
the text is there. 10 minutes ago it was restored about 6 tables and was a mistake . now I have recovered almost everything but in the end gave the SQL query:---- Database: `bulbet_onlysc`---- ------------------------------------------------------------ Table structure for table `dr_actions`--CREATE TABLE IF NOT EXISTS `dr_actions` ( `aid` varchar(255) NOT NULL DEFAULT `0` COMMENT `Primary Key: Unique actions ID.`, `type` varchar(32) NOT NULL DEFAULT \" COMMENT `The object that that action acts on (node, user, comment, system or custom types.)`, `callback` varchar(255) NOT NULL DEFAULT \" COMMENT `The callback function that executes when the action runs.`, `parameters` longblob NOT NULL COMMENT `Parameters to be passed to the callback function.`, `label` varchar(255) NOT NULL DEFAULT `0` COMMENT `Label of the action.`, PRIMARY KEY (`aid`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=`Stores action information.`;MySQL said: Documentation#1146 - Table `bulbet_onlysc.dr_actions` doesn`t exist[ Back ] |
| Question: |
it turns out that, in order to show You the error message, I vostanovlenie on top of Your base flooded smitten. please repeat the recovery. |
| Question: |
now looking, the base is empty |
| Answer: |
please Wait. |
| Answer: |
the database rebuilt, check the operation of the site. |
| Question: |
not working. and phpmyadmin shows a blank базуPDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table `bulbet_onlysc.dr_semaphore` doesn`t exist: SELECT expire, value FROM {semaphore} WHERE name = :name; Array ( [:name] => variable_init ) in lock_may_be_available() (line 167 of /home/bulbet/public_html/includes/lock.inc). |
| Answer: |
please Wait. |
| Answer: |
upload the created dump hosting |
| Question: |
1 minute |
| Answer: |
ok
|
| Question: |
uploaded to the root directory |
| Answer: |
in the root directory, no dump file. give the path to the file |
| Question: |
/public_html/bulbet_onlysc.sql |
| Answer: |
the dump file is not complete |
| Question: |
I already knew |
| Question: |
so worked phpmyadmin :( |
| Answer: |
trying to restore from backups |
| Question: |
chances are there approx.? |
| Answer: |
we tried two. both are broken. looking for more. probably the base was damaged by the hacker, who you were sending spam. |
| Question: |
and it is possible while to recover from yesterday or earlier, the contents of the folder /public_html/cache while the website will work without the base? |
| Answer: |
restored |
| Question: |
somehow not very helpful.The database will not work to raise? |
| Answer: |
with the DB yet nothing comes out. did you do a full backup before? |
| Question: |
is full for April 19. but there is 100% lower than the current version of drupal. and it is possible to restore only this website? |
| Answer: |
Yes, perhaps. Upload the backup to the root account. |
| Question: |
2min approx. |
| Answer: |
ok
|
| Question: |
uploaded |
| Answer: |
the database imported. Associate the user with the database and mount it in the config user password. |
| Question: |
PDOException: SQLSTATE[42000] [1044] Access denied for user `bulbet_zapadlo`@`localhost` to database `bulbet_onlysc` in lock_may_be_available() (line 167 of /home/bulbet/public_html/includes/lock.inc). |
| Question: |
it seems to me that the files will have to change |
| Question: |
damn. nedochital your message. now do |
| Answer: |
ok
|
| Question: |
kind of like work. at least reverted to the old version. I`ll try to update drupal and set the module caching and I think that will work. this database intact? you can continue to work on it or need to take any action? |
| Answer: |
Base intact. Before updating make the database dump and copy of the website files. |
| Question: |
approx. thanks for the help. |
| Answer: |
ok
|
