Advertisement:

Author Topic: Anyone willing to test some things for me?  (Read 133677 times)

Offline Natz

  • Semi-Newbie
  • *
  • Posts: 29
Re: Anyone willing to test some things for me?
« Reply #140 on: July 24, 2007, 08:38:14 PM »
Hi, ive recently moved to another host.  I installed a new smf installation have tried to use phpmyadmin to upload the backup, it failed because i have such a huge forum and it timed out.

So i downloaded the restoration tool, put all the info in clicked continue and nothing happens, i just get backup restoration tool with a blank page and down the bottom says Done.  Can anyone help as i have a huge forum and dont want to lose anything.

Thanks
nat

babjusi

  • Guest
Re: Anyone willing to test some things for me?
« Reply #141 on: July 24, 2007, 08:40:37 PM »
Try BigDump

P.s. How mb is your backup file?

babjusi

  • Guest
Re: Anyone willing to test some things for me?
« Reply #142 on: July 24, 2007, 08:44:49 PM »
One more question. When you installed the smf at the new host, did you use the same db info like the other forum at your old host?

Offline Natz

  • Semi-Newbie
  • *
  • Posts: 29
Re: Anyone willing to test some things for me?
« Reply #143 on: July 24, 2007, 08:50:43 PM »
Hi babjusi, thanks for the quick reply.

My backup file is 14.9mb gzipped. 

Not sure what you mean with the same db info??  Sorry, ive had a little experience with databases but not heaps :D

Offline Natz

  • Semi-Newbie
  • *
  • Posts: 29
Re: Anyone willing to test some things for me?
« Reply #144 on: July 24, 2007, 08:53:37 PM »
Just another thing, i was able to restore the database using the restore tool in cpanel.  But....its created its own database, i just need to be able to move it to the new installation.  But im not sure how to drop the tables from the new installation, for it to go through.  And i keep getting an error that the table already exists.

babjusi

  • Guest
Re: Anyone willing to test some things for me?
« Reply #145 on: July 24, 2007, 08:58:05 PM »
Quote
Hi babjusi, thanks for the quick reply.

My backup file is 14.9mb gzipped.

Not sure what you mean with the same db info??  Sorry, ive had a little experience with databases but not heaps

Restore_backup.php tool should handle 14.9 mb. Anyway, unzip the backup file and give it another shot.

What I mean by db info, is the mysql info, like the name,  username and password. When creating the database at the new host, make sure that they are the same as the ones of the old host.


Offline Natz

  • Semi-Newbie
  • *
  • Posts: 29
Re: Anyone willing to test some things for me?
« Reply #146 on: July 24, 2007, 09:07:12 PM »
Just fixed it, all i did was copy the database over to the new one.

Thanks again!!

babjusi

  • Guest
Re: Anyone willing to test some things for me?
« Reply #147 on: July 24, 2007, 09:09:01 PM »
Just fixed it, all i did was copy the database over to the new one.

Thanks again!!

Glad to hear that you fixed it. Which tool did you use to import your database, the Bigdump or the restore_backup.php?

Offline Natz

  • Semi-Newbie
  • *
  • Posts: 29
Re: Anyone willing to test some things for me?
« Reply #148 on: July 24, 2007, 09:18:44 PM »
I used neither, i just used the backup tool in cpanel and it uploaded fine there but it created its own database.  So while searching around phpmyadmin i found copy database.  All i did was dropped the tables and copied it over to my new installation.

Its a little screwy but nothing that cant be fixed, i still have files to upload through FTP.  I only have 1 problem though, its replaced symbols with question marks.  Does anyone know how to fix that?

Offline Minare

  • Sophist Member
  • *****
  • Posts: 1,233
  • Gender: Male
  • Yapayalnız Kalmak İskelelerde !
    • Meryemce
Re: Anyone willing to test some things for me?
« Reply #149 on: September 23, 2007, 11:28:01 AM »
Actually, the ones attached above probably won't work properly.  Here are newer ones...

-[Unknown]

How does this work ?

I want to download my db from phpmyadmin but dunno how with this ?

Thanks.
O güzel Râsulu Yesrip yolunda
Hicret coşkusuyla aramalısın
Ayrılık Anne'den Baba'dan Yâr'dan
Ezelden geçerek kavuşmalısın

http://www.meryemce.biz

Offline L.G.S

  • SMF Hero
  • ******
  • Posts: 2,658
  • Gender: Male
  • RuthlessIntent.com !
    • GamesandGoals.com
Re: Anyone willing to test some things for me?
« Reply #150 on: September 23, 2007, 11:35:01 AM »
If you have CPANEL you can do it that way.
FREE and LIVE World Cup + Premier League football streams:

www.gamesandgoals.com


Offline anshar

  • Semi-Newbie
  • *
  • Posts: 67
Re: Anyone willing to test some things for me?
« Reply #151 on: November 18, 2007, 05:12:26 AM »
@Unknown

Can you tell why your script is killing database charset encoding ? I've made a backup but all special characters are wrong displayed.

I'm kinda hopeless, without ssh access i cant make a prober backup. cPanel is killing encoding as well. phpmyadimn is useless as my database is simply too big and is causing timeout durring export.

Offline Rumbaar

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 15,806
  • Gender: Male
  • Inherent Omniscience
    • Rumbaar.net
Re: Anyone willing to test some things for me?
« Reply #152 on: November 18, 2007, 05:50:01 AM »
I haven't read all of this thread, but as it was created back in 2004 I would hazard to guess it's no longer valid.  Try the converters in the converters section is probably the best bet.
"An important reward for a job well done is a personal sense of worthwhile achievement."

[ Themes ]

Offline Dragooon

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 6,738
  • Gender: Male
  • I'm batman
    • ShitizGarg on Facebook
    • Dragooon on GitHub
    • dragooon on LinkedIn
    • SMF-Media
Re: Anyone willing to test some things for me?
« Reply #153 on: November 18, 2007, 05:59:34 AM »
This is valid.
It always works. Well atleast for me it does.
This is Not SMF or phpBB dependent. It depends on MySQL so it works.

babjusi

  • Guest
Re: Anyone willing to test some things for me?
« Reply #154 on: November 18, 2007, 07:59:14 AM »
This is valid.
It always works. Well atleast for me it does.
This is Not SMF or phpBB dependent. It depends on MySQL so it works.

That is totally right. Those tools still work like a charm. They even work with the new version, SMF 2.0 Beta 1. The best tools on the subject. I am amazed as to why they aren''t included yet at the download section under ''Tools''

Offline metallica48423

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,842
  • Gender: Male
  • Professional Multislacker!
    • Zentendo
Re: Anyone willing to test some things for me?
« Reply #155 on: November 19, 2007, 05:32:31 PM »
it is not completely valid.

it does *not* support utf8, which IIRC was introduced after unknown left.
Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

Quote
Microsoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"

Useful Links:
Online Manual!
How to Help us Help you   
Search
Settings Repair Tool
     

Offline anshar

  • Semi-Newbie
  • *
  • Posts: 67
Re: Anyone willing to test some things for me?
« Reply #156 on: November 28, 2007, 05:07:39 AM »
You guys check out this script:

http://www.mysqldumper.de/en/

found it out a couple days ago, works like charm so far.

Offline JoeP

  • Jr. Member
  • **
  • Posts: 113
problem with backup_restore.php
« Reply #157 on: January 12, 2008, 10:14:44 AM »
I've been getting this error message when trying to use backup_restore to restore from an SMF complete backup:

Notice: Undefined index: line in /Applications/xampp/xamppfiles/htdocs/smf/restore_backup.php on line 160

The restoration is not successful.  Any ideas what the problem/solution might be?
Is there a way to run the sql statement in the backup file outside of backup_restore, or phpmyadmin?  I believe that phpmyadmin has an sql file size limit to small for the backup.

Thanks in advance,
joe

Offline 青山 素子

  • Server Team
  • SMF Super Hero
  • *
  • Posts: 17,073
  • 戦場ヶ原、蕩れ!
    • srvrguy on GitHub
    • @motokochan on Twitter
    • Nekomusume Moe
Re: Anyone willing to test some things for me?
« Reply #158 on: January 13, 2008, 12:11:29 AM »
You can try the BigDump application to do a database restore.
Motoko-chan
Director, Simple Machines

Note: Unless otherwise stated, my posts are not representative of any official position or opinion of Simple Machines.


Offline Marsh

  • Jr. Member
  • **
  • Posts: 324
Re: Anyone willing to test some things for me?
« Reply #159 on: May 11, 2008, 02:36:33 AM »
it couldnt back it up right but it restored it fine, thank you so much.
625,195 Posts in 50,808 Topics by 34,295 Members.

Powered by SMF 2.0

www.touchofdeathproductions.com