I have a site, the programmer went in screw up my site and wont fix it. So I restore the files, it wont work either. So I deleted everything and asked my host to restore my latest backup which is oct 25, 2009. Host said can't restore that file that I uploaded. For some reason and they only have oct 20. 2009. Can someone help? go into my cpanel and open that .tar ball file for me? and extract the mysql format and its data to my cpanel? My host wont do it because they say they can't....any with linux? I am not able to open .tar with windows.
I might have time to help real quick. This should handle the tar file I think as well. http://www.7-zip.org/ Nigel
Thanks for that Nigel, I will download it now and try it. So its a fullbackup using whm only. Hopefully I can find the SQL file once I unwrap it? And then upload the SQL file via cpanel or does it require WHM to upload the sql file? It works...Now there's 2 sql. I have site.sql and horde.sql.... what does horde.sql do? I found the site.sql and using 7zip thing it said 1.5MB which is right...but after I exit, went to windows it said its a 750KB file...strange thing...also have the homedir.rar in it.... So I should upload the homedir.rar and then the site.sql without the horde.sql?
Yep, Horde should likely be your webmail backup I think. Never had to mess with that but it should be fairly straight forward. I am just not exactly sure where it needs to go. but, yes, homedir should be your ftp folders so whatever is inside of public_html should likely do the trick. Just make sure to upload things with the same file structure. That is why I suggest upping the contents of your root folder. I would really need to see whats up to advise you perfectly. Uploading all of that stuff could cause some issues lol.... It depends on what you had going on with the server in the first place really. site.sql will be a website db backup or a backup for the whole machine. This will get imported via sql query but you may need to create a database or something for that to work. This again depends on what was happening in the first place. Don't sweat file size differences. 7zip is a compression utility. Things will be different when unpacked. Nigel
There's something called BigDump, Google it and you'll find it. That should be able to restore your db. Else you can also try MYSQL Dumper. Hope that helps
My host fix that "BigDump" thing but I don't know what it is really. They said they recreated the database with some user names. Now I have the same problem with database. This is the error "SQL query: /*!40000 ALTER TABLE `cities` DISABLE KEYS */; MySQL said: #2006 - MySQL server has gone away " This error is giving while I try to import my database. What is this? How can I solve this. Basically the SQL creates 3 tables and stop working because of the error. Another programmer said the config file might have been corrupted. So what does that mean? (BTW, I am not a programmer so if you use programming jargons, I wont know)
#2006 - MySQL server has gone away Is basically a host side problem. They need to check the connectivity of mySQL with bigger databases. - I can get the database back onto your mySQL database and also untar it if it is not done properly yet
Are you still having this problem issue? PM me or IM at walviax[at]yahoo[dot]com I can restore your website (files + sql)
Hi Yes I am still having problems with the website, the sql is not importing right. I will ask the host the host again, by the way I sent like 3 requests.... I am told its the host sql server problems (settings) if their server configuration is not set right? how will this work? I will update everyone if this is fix, if not I will PM you for help....the thing with web site, why can't the sQL files be under public html right? so that installation and everything should be in one easy place to configure.
While you restore via phpmyadmin, you may possibly be pussing too many queries at a time. This might be causing the problem. I can definately fix this for you if you wish to take help from me. Talking about the configurations, if it is not configured properly, it will through out errors as it is doing right now. It does not necessary mean that it won't work. Take a example - A toy car with all nuts fixed will work perfect. A toy car with 1 nut missing will break out in a while. This is the case here. It has to break out one day or other. If it wasn't you, it would had been someone else.
Update!!! Flamer has fixed the problem for me...Thank you everyone... It turns out that the hosting server does not allow a large database to be imported at once...some settings they have and their cpanels were not working correctly.