Anyone willing to test some things for me?

Started by [Unknown], October 17, 2004, 01:22:35 AM

Previous topic - Next topic

Natz

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


babjusi

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?

Natz

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

Natz

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

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


Natz

Just fixed it, all i did was copy the database over to the new one.

Thanks again!!

babjusi

Quote from: Natz 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!!

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

Natz

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?

Minare

Quote from: [Unknown] on December 06, 2004, 04:25:53 PM
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.

L.G.S

FREE and LIVE World Cup + Premier League football streams:

www.gamesandgoals.com


anshar

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

Rumbaar

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 ]

Dragooon

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

Quote from: Dragooon 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.

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''

metallica48423

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

QuoteMicrosoft 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

anshar

You guys check out this script:

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

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

JoeP

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

青山 素子

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.


Marsh

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

Advertisement: