PDA

View Full Version : Need help reverting to a backed up MySQL database




realityisterror
May 22, 2005, 10:48 AM
I have PHPMyAdmin installed on my server (http://arminvosough.com) and I need to find the SQL commands to revert to a raw *.sql file.

All I know is that I need to log in PHPMyAdmin, go to the SQL tab, and put in some command. I have the sql file at the root of the server, let's call it backup.arminvosough.com.sql.

So can anyone help me out with the proper commands?
I know how MySQL works, but I've never had to deal with any behind the scenes stuff, so the more info, the better.

Thanks,
reality



realityisterror
May 22, 2005, 06:22 PM
Ok, I figured it out... Thanks for all the help guys... :rolleyes:

Turns out it was really easy using PHPMyAdmin, I just couldn't figure it out because there was a line in the SQL telling it to create a new database rather than add into the existing one...

Now you guys can help me with some cron stuff (http://forums.macrumors.com/showthread.php?t=128127)!

reality