Advertisement:

Author Topic: how i create bakup from phpmyadmin  (Read 3642 times)

Offline andsim

  • Semi-Newbie
  • *
  • Posts: 99
  • Gender: Male
how i create bakup from phpmyadmin
« on: January 20, 2009, 10:36:45 PM »
hi there, how i create a backup to my hard drive using phpmyadmin ty

Offline eagled2

  • Semi-Newbie
  • *
  • Posts: 47
Re: how i create bakup from phpmyadmin
« Reply #1 on: January 21, 2009, 03:46:06 PM »
Well smf has a backup option that backs up the database in maintenance but if you really need to do it directly from the database you would need to look for the export option. Then export whichever databases and tables you need.

Offline andsim

  • Semi-Newbie
  • *
  • Posts: 99
  • Gender: Male
Re: how i create bakup from phpmyadmin
« Reply #2 on: January 21, 2009, 07:40:39 PM »
Well smf has a backup option that backs up the database in maintenance but if you really need to do it directly from the database you would need to look for the export option. Then export whichever databases and tables you need.
how about restoring?

Offline 10dc

  • Semi-Newbie
  • *
  • Posts: 59
  • Gender: Male
  • IDezigner
    • persahabatan indonesia forum
Re: how i create bakup from phpmyadmin
« Reply #3 on: January 21, 2009, 08:00:22 PM »
maybe on webhosting you have control panel for back up automatic.
evry weeks or every day.
Great it :)
Forum Camfrog Persahabatan Indonesia : www.forum-pi.com  |  www.udin.web.id

Offline eagled2

  • Semi-Newbie
  • *
  • Posts: 47
Re: how i create bakup from phpmyadmin
« Reply #4 on: January 21, 2009, 08:37:08 PM »
maybe on webhosting you have control panel for back up automatic.
evry weeks or every day.
Great it :)
If you hosting has cron jobs you could setup an auto backup as voldermort suggested. As far as restoring is concered that has to be done directly from the database as there is no restore feature in smf. Look for import to restore the database in phpmyadmin.

Offline Sean G.

  • Semi-Newbie
  • *
  • Posts: 19
Re: how i create bakup from phpmyadmin
« Reply #5 on: January 22, 2009, 05:28:04 PM »
maybe on webhosting you have control panel for back up automatic.
every weeks or every day.
Great it :)
If you hosting has cron jobs you could setup an auto backup as voldermort suggested. As far as restoring is concerned that has to be done directly from the database as there is no restore feature in smf. Look for import to restore the database in phpmyadmin.

When you are restoring the DB, whether it be from the control panel of your hosting provider or through SMF admin, what else to you need to back up?  ie...zipping up the entire formum directory...

Also, when you back up the DB using the SMF web interface option and save it to your hard drive, how do you restore it if you have your DB hosted on another server and not your own computer?

So in a nutshell, say I'm at a point I am happy with the look and layout...what complete steps are needed to make sure that if a mistake is made, either from mod or other error, that I could take to ensure the site was perfectly in order after a restore?

Hope that made sense.  Thanks again.

Sean.

Offline eagled2

  • Semi-Newbie
  • *
  • Posts: 47
Re: how i create bakup from phpmyadmin
« Reply #6 on: January 22, 2009, 07:28:53 PM »
You should make a complete backup of your database and at least the sources and your theme directory. It wouldn't be a bad idea to copy your entire folder but most mods only change files in the sources and theme folders. As far as saving the database backup to your hard drive is concerned you would use a tool such as phpmyadmin to import the backup you saved on your hard drive when you needed to restore it.

Offline andsim

  • Semi-Newbie
  • *
  • Posts: 99
  • Gender: Male
Re: how i create bakup from phpmyadmin
« Reply #7 on: January 24, 2009, 10:43:21 AM »
i am new with cron system, i dont how it work sorry, if some could give some example i willl use it

Offline greyknight17

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 14,890
  • Gender: Male
    • Kevin's Resource Center
Re: how i create bakup from phpmyadmin
« Reply #8 on: January 31, 2009, 01:21:39 PM »
I would stick with phpMyAdmin since it's probably one of the more simpler methods. You can also use it to restore the backup. If your database is too large for phpMyAdmin to restore, you can also use other methods. Try using restore_backup.php to restore your database. If that doesn't work, use BigDump to do this.

If you still want to learn how to use cron jobs, see here. It should be similar if you are using cPanel.