Geeklog Forums

How does one restore the backup of the database? I get an error on LINE 2 of the backup file because of all the ---'s I'm in a real jam and can't get SQL to take this backup back!! HELP!!!!

Use your MySQL client: 1) clear out old DB %>mysqladmin -u<user> -p<pass> drop <db_name> %>mysqladmin -u<user> -p<pass> create <db_name> 2) Pump in data %>mysql -u<user> -p<pass> <db_name> < somesqlfile.sql---The reason people blame things on previous generations is that there's only one other choice.

---

The reason people blame things on previous generations is that there's only one other choice.

Or, if you have phpMyAdmin, you can have it do this all for you. I wouldn't be able to have a GL site without phpMyAdmin - I'm not savvy enough. ---"For 300 lifetimes of man have I roamed this earth, and NOW I don't have any time!" -Gandalf the White

---

"For 300 lifetimes of man have I roamed this earth, and NOW I don't have any time!" -Gandalf the White

I did this just the other day Aaron when I was making a back-up site. I just used an editor and deleted all the unnecessary commenting. I populated the new DB using myphpadmin and it worked like a charm.