11
Anonymous
Re: Backing up my stuffs
  • 2008/2/12 16:31

  • Anonymous

  • Posts: 0

  • Since:


Quote:
paulizaz wrote:

Thanks for that, How about restoring the data using phpmyadmin?


Easier than making the backup in the first place

Assuming that you followed the guide in the link that I posted (including checking the "Add DROP TABLE", "Complete inserts" and "Extended inserts" boxes) then all you need to do is:

1. Navigate to your database
2. Click on the "SQL" tab
3. Browse to the backed up database on your PC (I always gzip mine, so the filename is "databasename.sql.gz")
4. Click on the "Go" button.

This will drop existing tables where they have the same name as those being written then recreate/populate them. Where no tables of the same name exist then they will be created and populated.

IMHO, forget the XOOPS modules and other tools. Just use phpmyadmin (or your host's CPanel if it has it included).

HTH

Login

Who's Online

197 user(s) are online (115 user(s) are browsing Support Forums)


Members: 0


Guests: 197


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits