Advertisement:

Author Topic: restore_backup.php problems..  (Read 34682 times)

Offline ~Romil

  • Newbie
  • *
  • Posts: 8
  • Gender: Male
    • ~Romil
Re: restore_backup.php problems..
« Reply #20 on: December 20, 2006, 07:16:40 AM »
Ya I do have all the installation intact in form of your bridged version.

BTW, I was trying this installation on SMF 1.1 and in the meantime, SMF 1.1.1 got in picture. Please suggest...
~Romil

Orstio

  • Guest
Re: restore_backup.php problems..
« Reply #21 on: December 20, 2006, 07:22:36 AM »
Reupload your SMF 1.1 RC1 files to match your SMF 1.1 RC1 database.

Make sure everything functions as it should.

Then upgrade to SMF 1.1.1.

Offline ~Romil

  • Newbie
  • *
  • Posts: 8
  • Gender: Male
    • ~Romil
Re: restore_backup.php problems..
« Reply #22 on: December 26, 2006, 06:25:44 AM »
Before you adviced, I rather tried to upgrade the SMF 1.1 RC1 to 1.1.1 on original installation, it worked fine!

Now, I took a backup of the db there and saved it with removing the 'TIMESTAMP' issue.

Installed a fresh SMF 1.1.1 on another server and when uploaded the db I had in my hand, but strangely the posts still don't appear?

Any ideas, before I take a U turn to what Orstio suggested?
~Romil

Offline sifirforum.com

  • Jr. Member
  • **
  • Posts: 379
    • SIFIR Forum, Özgür bilincin ifade zemini
Re: restore_backup.php problems..
« Reply #23 on: December 27, 2006, 05:03:41 PM »
when you optimeze tables before backup then restore proses runs perfect.

and mysql version is important. mysql 5 is not good for smf.
SIFIR proudly hosted by servega

Offline BigGunn

  • Semi-Newbie
  • *
  • Posts: 51
  • Gender: Male
Re: restore_backup.php problems..
« Reply #24 on: January 17, 2007, 04:31:45 AM »
i lost all of my threads and posts because of a "duplicate entry" error.

argh.

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,933
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: restore_backup.php problems..
« Reply #25 on: January 17, 2007, 06:38:29 PM »
You should have an empty database or have your mysql file empty it before you add everything back.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline Han

  • Full Member
  • ***
  • Posts: 510
  • Gender: Female
    • PC-Navigator Forum
Re: restore_backup.php problems..
« Reply #26 on: January 21, 2007, 10:14:50 PM »
When there is an update of the forumsoftware, can I than still use my old "create_backup.php" and "restore_backup.php" or will there be new versions of this two files as well?

I never used the "create_backup.php" and "restore_backup.php" files before. I always used phpmyadmin. I'm just curious how this works.
For restore in PHPMyAdmin I always had to cut my sql-file in pieces. If I don't do that, the server of my host times out on me. Cutting my sql-file in pieces is quite a job, so I wonder if backup and restore with "create_backup.php" and "restore_backup.php"  is easier for me.
« Last Edit: January 21, 2007, 10:18:45 PM by Han »

Offline Han

  • Full Member
  • ***
  • Posts: 510
  • Gender: Female
    • PC-Navigator Forum
Re: restore_backup.php problems..
« Reply #27 on: February 21, 2007, 07:42:40 PM »
Not one, who knows an answer?

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,933
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: restore_backup.php problems..
« Reply #28 on: February 22, 2007, 09:23:03 PM »
I never used restore_backup and phpmyadmin has never gave me much trouble when I do use it which is seldom.

Did you try any and get it working?
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline Han

  • Full Member
  • ***
  • Posts: 510
  • Gender: Female
    • PC-Navigator Forum
Re: restore_backup.php problems..
« Reply #29 on: April 18, 2007, 04:44:18 AM »
I'm sorry for not answering. I lost track of this topic.

No, I did not try it, because i do not want to temper my database if not nessesary. My host has now a backup and restore system. I can make backups online and I keep a backup on my own harddisk. I don't need it "restore_backup.php" anymore.

babjusi

  • Guest
Re: restore_backup.php problems..
« Reply #30 on: May 29, 2007, 12:22:14 PM »
How exactly those 2 files work? Sorry for this newbe question, but I can''t quite understand it.

Create_backup.php- This file should be uploaded to the webroot so it can make a back-up of database?  And the other file, restore_backup.php should be again uploaded to the webroot so it can restore the database? Did I get it right so far?

My other question is, after I upload, say, Create_backup.php to the webroot, what else should I do? Do I have to type s.th. to the broweser like. www.mysite.com/Create_backup.php and run it. Or should I do s.th else? All help is very much appreciate it. Thank you in advance for all your answers


Offline greyknight17

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 14,890
  • Gender: Male
    • Kevin's Resource Center
Re: restore_backup.php problems..
« Reply #31 on: May 29, 2007, 10:52:55 PM »
How exactly those 2 files work? Sorry for this newbe question, but I can''t quite understand it.

Create_backup.php- This file should be uploaded to the webroot so it can make a back-up of database?  And the other file, restore_backup.php should be again uploaded to the webroot so it can restore the database? Did I get it right so far?

My other question is, after I upload, say, Create_backup.php to the webroot, what else should I do? Do I have to type s.th. to the broweser like. www.mysite.com/Create_backup.php and run it. Or should I do s.th else? All help is very much appreciate it. Thank you in advance for all your answers


You can upload it wherever you want. It will just be going after the database either way. It will prompt you to enter the login info and the database info. After that, depending on which file you are using, it will restore or backup your database.

I never use these two files either. I remember trying one of these out myself before and didn't work out quite as planned. Had to contact my webhost and everything was peachy after that ;)