Database LOST? Somebody Deleted It. How To Restore
Jun 10, 2007
my site is down for 2 days. this started 2 weeks ago when the vps started to work very bad and my site has been down more time than up. they closed the topic: "horrible experience with liquidweb" [url] but I still have not a solution and now somebody accidentally I suppose, deleted the database.
I cant do nothing and my last backup i have here is from +1month ago..
in cpanel I see: "sql disk usage": 120 mb but in databases zone it doesnt appear and phpmyadmin access is denied.
forum cant be accessed:
Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /home/.../public_html/forum/db/mysql4.php on line 48
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/.../public_html/forum/db/mysql4.php on line 330
Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/.../public_html/forum/db/mysql4.php on line 331
phpBB : Critical Error
Could not connect to the database
what can I do? can they restore it?
My sport community is in the worst nightmare I could imagine :-(
View 8 Replies
ADVERTISEMENT
Nov 18, 2008
I've come into a bind here.
I need to restore a deleted VPS. Problem is that another VPS was created right after the VPS was deleted. This is on a Xen hypervm slave.
I tried running vgcfgrestore -f /etc/lvm/archive/VolGroup00_01381.vg VolGroup00
but its not bringing back the files.
Any ideas at all at on how to recover? Is this even possible? I just need to salvage some files from /home from the old setup.
Perhaps delete the new VPS and then do a restore?
View 5 Replies
View Related
Jun 23, 2009
We have been with Apollo hosting for 5 or so years. 10 days ago, our entire site went down. After waiting around 4 days and hours of dealing with tech support, they got a shell of our website back up. Their excuse for deleting it was that they ran a script on their servers that was corrupt, which in error, deleted our site.
They were unable to restore our database, SQL, php, search functions, etc. as they said they deleted them and did not have a back up as databases took up too much room on servers!! And they cannot restore what is no longer there. We have to rebuild our database all over again, hundreds of hours of work with property descriptions and photos, forms, etc.
After this experience with Apollo hosting our fear level is high and our trust level is low.
We need help with finding a new web host. Currently paying Apollo $ 30. mo for shared hosting.
We need Front Page extension, pph,SQL. Want web host that backs up entire website daily on tape that stores off-site. I have researched some on web hosting review sites and better business bureau online, and find many complaints for various webhosts.
View 14 Replies
View Related
Aug 9, 2008
I moved from a host to another and wanted to restore/use the email adresses that are already saved on my old host account.
I did a full backup by using Cpanel's wizard and saved it on my computer. Extracted everything and then by using FTP I have put all the files on my new server which is using Cpanel as well.
Although all email adresses are now visible in my Cpanel the old passwords will not work anymore......
View 4 Replies
View Related
Jul 16, 2009
I deleted one of our databases from PLESK in mistake, now how can I recover that database ? my backup is very old and I cannot use backup file.
this is urgent , I'm in bad situation please help me.
my server is Linux.
I found this article :
[url]
I don't know this article can help me or not
View 2 Replies
View Related
Oct 21, 2008
I am trying to change to a different server within the same webhosting company and they have asked me for the username and password of the SQL database I have in my site. Call me stupid, but I have lost this and now I am wondering what I can do.
Since I can log into the cpanel etc I can very well make a copy of the database etc., if that helps. Is there somewhere I should look in the files and folders where the username password info may be store in? I seem to recall reading somewhere that is the case. Any info appreciated.
The reason the host needs this info is because the new server doesnt use cpanel, it uses something called plesk. So if all fails, I am thinking, I just move to a different host who uses cpanel, that way I dont need the UN/PW? Seems a rather silly thing to do, but I have t consider all alternatives now.
View 11 Replies
View Related
Apr 7, 2007
I have on my server vBulletin 1.7GB database in SQL format I try somany time to restore it but its hang! I transfer that file to another server and its working fine!
I see the MySQL Processes:
Code:
+----+--------------+-----------+--------------+---------+------+----------------------+--------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+--------------+-----------+--------------+---------+------+----------------------+--------------------------------------------+
| 11 | leechprotect | localhost | leechprotect | Sleep | 2073 | | |
| 22 | eximstats | localhost | eximstats | Sleep | 1902 | | |
| 25 | xxxtyyx_vb | localhost | xxxtyyx_vb | Query | 1494 | Repair with keycache | /*!40000 ALTER TABLE `post` ENABLE KEYS */ |
| 41 | root | localhost | | Query | 0 | | show processlist |
+----+--------------+-----------+--------------+---------+------+----------------------+--------------------------------------------+
Its stay like that for long time!
View 7 Replies
View Related
Apr 24, 2008
i found out that for the past 6 months ive been backup up all my MySQL databases into one big file. However, now that i actually need to restore a database, i can't find out how to actually restore 1 database out of this enormous file.
I can find the Mysql shell command to restore 1 database ... but it doesnt tell me if you need to have a 1 database dump file for this as well. It does not mention what happens if you execute that command on the big file containing all databases. Restoring all server databases would be a very bad thing.
View 7 Replies
View Related
Apr 30, 2008
if you have used BQ internet remote backup
If you loose a DB how do you use BQinternet to restore the DB?
one particular DB
where is it stored?
View 5 Replies
View Related
Jun 16, 2007
I have a site which uses vBulletin. After a long story we ended up with the need to restore it's database from a backup.
The backup proccess was in fact copying the database files - .MYD, MYI; so no mysql dumps.
I've recreated the dabase from phpmyadmin and created a standard user wtih read/write permissions and a dba user.
After that I've copied the database files from the backup and when I've tried to launch the site, it gives me the error:
"Warning: mysql_query(): Unable to save result set in /includes/class_core.php on line 354"
That's all the output I get.
I've modified the files permission to 755 and changed the owner and group; I've modified the vBulletin file to use the dba user account to access the database... all this without any luck.
I've done some searching and I've found that restoring database .MYI/.MYD files is simple - stop mysql, copy files, set permissions and fire up mysql. I've replicated the steps but still doesn't work.
View 3 Replies
View Related
Dec 14, 2013
Trying to restore a database in plesk 11 I got the following error.
Error: dbbackup failed: Unable to restore database 'database_name'Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
There is no wrong with the db, when I restore from it on local machine everything works.
View 2 Replies
View Related
Jun 24, 2015
I have a problem with restore ms sql server 2008 database after restoring the message...Error: Unable to creste database user: Database user name is invalid. Only latin letters are allowed in the database user nameerror
View 1 Replies
View Related
Mar 8, 2015
I installed plesk win 12 with mssql2012 , but nobody as abale to restore DB via plesk we recive this error Error: dbbackup failed: Unable to restore database 'degardis'Format of the initialization string does not conform to specification starting at index 29.the backup file is restored straight via sql management studio.
View 1 Replies
View Related
Jul 22, 2015
Unable to restore database '17'
Not valid backup:
Cannot open backup device 'C:Program Files (x86)ParallelsPleskBackupclub-panel.irdatabases171.bak'. Operating system error 5(Access is denied.).
VERIFY DATABASE is terminating abnormally.
(Error code 22)
---------------------- Debug Info -------------------------------
View 1 Replies
View Related
May 2, 2013
I have daily backups for all accounts setup on our Plesk 11 server and was wondering how I would go about restoring a single database from the backup manager? I could restore the entire zip file, but that would make a mess of any other databases which of course isn't optimal. I see if I download a client's zip file that within the zip_file/databases/db_name there is another zip file which contains a tmp file which for a MySQL database it looks fairly standard, for MSSQL it looks to be in their format but is this what's really necessary? Can I even use those tmp files to restore manually through the Backup Manager -> Database Backup Repository? Why isn't there a simple way for a client to restore a database with the existing backups?
View 2 Replies
View Related
Mar 20, 2014
I have Plesk Windows version, when I want import my backup mysql, i see below error:
Error: dbbackup failed: Unable to restore database 'admin_IranDnn'
ERROR 2006 (HY000) at line 1: MySQL server has gone awayClick to expand...
View 7 Replies
View Related
Mar 23, 2015
Would like to know what are the dangers of backing up and restoring full entire system backups (with plesk installed) to another server with a different ip address? Will the restored plesk setup operate properly and offer an ip address change in the system, or will there be any pre-requisites required such as manual ip changing within the system core files?
View 1 Replies
View Related
Mar 30, 2007
I have been using cpanel for last years. just today got DA on a new dedicated server and now have problem with dns.
[url]
I know the basics of dns and nameserver but i am kinda lost in DA
View 1 Replies
View Related
Jul 4, 2009
We are running cpanel on one of our servers. Several cron jobs were deleted from the cron panel of one acct. I have no idea of the paths to re-enter these jobs. Is their a log file on the server that will show cron job history from previous runs so I can recover the proper paths?
View 4 Replies
View Related
Jul 8, 2008
Changing php version to 5.2.6
I just lost the handler....no php handler at all( old: DSO), rebuilding again (second time)...
anyone knows why this happened?
and what should I do, since the last easyapache rebuild didn't work?
View 2 Replies
View Related
Jun 2, 2008
We delete LOGS.
We delete QUEUE mail.
After we add up all the space of the counts.
space of count1 + space of count2 + space of count3 + ... ALL COUNTS
And TOTAL < to 2GB included MySQL space
But space used (say Vistuozzo), is 8.47 Gb!
How we can understand this?
Ok, maybe 2 GB of CENTOS + cpanel + WHM+ MySQL + Files config = 2 GB
Home + MySQL = 2GB
4 GB is very different to 8.5 GB!
Ok think in 3 GB of SO+WHM+CONFIG add 2 GB of files this = 5 GB
View 14 Replies
View Related
