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

  • Anonymous

  • Posts: 0

  • Since:

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).



Who's Online

182 user(s) are online (80 user(s) are browsing Support Forums)

Members: 0

Guests: 182



Goal: $100.00
Due Date: Jun 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits