Moving forum database problem

ekfaysal · April 07, 2009, 06:29:36 AM

hello guys
i wanna move from my webhost.
already installed smf forum there,,
now my sql file is about 25 mb..
tried with phpmyadmin but that cannot transfer over 200 kb.
then tried with bigdump but its giivng me stange error

anybody plase check here is the url
**REMOVED**

Edit: Removed link. Posting links to your database, or that can change your site around is a dangerous thing. - Motoko-chan

Aleksi "Lex" Kilpinen · April 07, 2009, 08:55:53 AM

PLEASE PLEASE PLEASE, don't share that link in public! Remove it at once for your own safety!

And then, tell me what the error is you are getting, and what are you trying to do exactly?

ekfaysal · April 07, 2009, 01:55:34 PM

Oh sorry for that.. i couldnt realize..
i tried bigdump
everything worked fine.. i mean bigDump comleted successfully
but my forum's DB is still not loaded.. i cant see my members and topics etc..
please

Aleksi "Lex" Kilpinen · April 07, 2009, 02:06:09 PM

If it completed succesfully, make sure your forum is set to use the newly imported database

Check with phpmyadmin for example, I'm guessing you now have 2 different smf databases, and your forum is using the wrong one.

ekfaysal · April 07, 2009, 02:25:14 PM

no i m using the righth database.. i have already checked

Aleksi "Lex" Kilpinen · April 07, 2009, 02:31:43 PM

Then do check that the backup actually has messages and members in it.
Download it to your computer, and open it with an editor like notepad++
Then compare the contents of the backup, with the contents of your database,
and see if they really match.

ekfaysal · April 07, 2009, 03:24:33 PM

already checked.. i cant understand ... there r so much things out there..
i mean i have no experience regarding these ....

ekfaysal · April 07, 2009, 04:14:08 PM

cannot sort out problem.. anybody ... please help... even i tried 10 times but not working...

ekfaysal · April 07, 2009, 05:20:34 PM

post edited..

Adish - (F.L.A.M.E.R) · April 07, 2009, 07:53:02 PM

Go to server settings in your old forum and see what is the prefix of your database, is it smf_ or backup_smf_ ? I think so that your SMF at the new host is taking smf_ while it should be backup_smf_

Use repair_settings.php to check other database details. What is repair_settings.php?

Also, i suggest you to remove the URL from the picture:- http://www.simplemachines.org/community/index.php?topic=303433

it discloses much of it..

EDIT:-
I just sneekinly downloaded your database and it seems it is not fully backed up. Take the backup from your control panel of the hosting site OR ZIP/GZIP the database you are saving.

Aleksi "Lex" Kilpinen · April 08, 2009, 01:37:23 AM

Quote from: F.L.A.M.E.R on April 07, 2009, 07:53:02 PM
EDIT:-
I just sneekinly downloaded your database and it seems it is not fully backed up. Take the backup from your control panel of the hosting site OR ZIP/GZIP the database you are saving.

And this comes to show exactly why I warned not to give the url to public - and furthermore, after you are done with the importing be sure to remove it from your public folders!

Adish - (F.L.A.M.E.R) · April 08, 2009, 03:37:41 AM

Just remove the screenie someone... It can be harmful.. We spotted the problem though, so lets carry on safely..

ekfaysal · April 08, 2009, 03:55:13 AM

prefix of both new and old forums is smf_

I installed new forum again with prefix backup_smf_
tried through restore_backup.php
worked fine.. completed..
but it showed only the categeries... its not showing posts topics members etc..
i beleive my PHPMYADMIn isnt creating good backup..
everytime i tried creating backup, the database size is different like sometimes it is 20mb then 24 mb
then 15 mb ....
I cannot backup through forum maintanance as well...

Aleksi "Lex" Kilpinen · April 08, 2009, 05:43:42 AM

You could try doing the backup through phpmyadmin in parts, it's possible that phpmyadmin is limited by memory, php-settings, etc...

Or you could try a script like Adminiature to create the backup.

ekfaysal · April 08, 2009, 05:49:05 AM

i dont know how to do it in parts..
trying this Adminiature

Aleksi "Lex" Kilpinen · April 08, 2009, 05:50:26 AM

I myself have used the stable version succesfully in the past.

ekfaysal · April 08, 2009, 05:56:46 AM

im trying but after login it shows me blank page only......

Pentaxian · April 08, 2009, 06:10:39 AM

I used MySQLDumper (http://www.mysqldumper.de/en/) with success. Use the program to download from your original server as well as to upload to your new server. Site is in English and in German (without the "/en").

ekfaysal · April 08, 2009, 07:39:24 AM

em trying that MySQLDumper now
wish me luck..

Adish - (F.L.A.M.E.R) · April 08, 2009, 11:04:01 AM

Is this issue solved? Or someone marked it solved bymistake? Seems the OP hasnt finished the work..?

News:

Moving forum database problem