PDA

View Full Version : Need to use backup database...


mallcompany
9-19-05, 02:27 PM
OK, I saved by gzipped db onto my desktop. If I log into my sql and go to the sql tab then choose import, will it overwrite everything and put it back the way it was, or do I need to delete all of the tables and then import the gzipped file. I don't want to mess it up any more that I already have. You test for everything possible but there is always something you miss... Unfortunately, I am running a live site, so I am goobering now. Thanks for the help.

pureconcepts
9-19-05, 09:10 PM
Depends on the SQL file. Was it a backup from Powweb or an export from another program. Provided it is an SQL file, check to see if it runs DROP, DELETE, or TRUNCATE commands. Those are the main commands involved in a rebuilding of a DB.

mitchind
9-19-05, 09:29 PM
How big is the gz file?
Is the site on Powweb?