Web Hosting Talk







View Full Version : trashed a database, need help


myusername
09-16-2004, 04:11 PM
Hello,

If one had a user that had a large mysql database, say 500 megs, and they lived on a cpanel server, with a 80 gig hardrive, and 50 of that was partitioned in the home directory, and the home directory had 40 gigs of space used on it......

Given the above scenerio a user trashed a very active database and simply using the restore an account feature would severely damage the website, how can one extract and restore such a large database for the user.tar.gz file in /backup?

If we extract the whole file we will be out of diskspace. If we download it to a local machine, I am not entirely sure of a method that supports import of such a large database.

Any ideas?

Matt -Seeksadmin
09-16-2004, 05:16 PM
Hey,

tar xvf - "specific_file"

if you know the name of the database. If you don't know the exact name use * to generate wildcards.

myusername
09-16-2004, 06:07 PM
Thanks! I will give it a go.