insert my members in new board

[donnpipop]

                I've backup file but it's not perfect file so I can't to restore it to be new board.
I installed new board then I want to insert my members that is in backup file
to my new board.

                    Can I copy sql code from backup file and run on phpmyadmin to
create members in new board?

                    Thanks a lot.

[donnpipop]

OK now I deleted members table then I created members table again and Dumping data
from sql file into database that it's OK but I feel my board is not stable

system show me at my board
Database Error
Please try again. If you come back to this error screen, report the error to an administrator.

I think defect from some fields contain value that not match others tables
such posts , instantMessages etc.

Can I reset these fields in members table seem new menbers?
Maybe solve problem or do you have better solution?

Thank a lot.

[Looking]

Why isn't your original backup not a 'perfect' file?

[donnpipop]

Why isn't your original backup not a 'perfect' file?

sorry I use incorrect word I should to tell you 'incomplete backups file'.
I don't know what happen while I backup someone tell me 'you are another victim of phpMyAdmin'

[Looking]

I have not had problems with phpmyadmin in the past and I handled hundreds of databases with sometimes GBs of content. What I have found is servers that have low resources time out and you do not finish processes. I take it you cannot get the original DB?

[JimM]

Normally if you used phpMyAdmin to export the database, you shouldn't have an issue importing with it unless you run up against the resource constraints that were mentioned by Looking.

You should be able to import the individual tables by breaking up the export file.  Use a text editor like notepad++

[donnpipop]

I understand my backup file was incomplete because servers that have low resources and time out.

              After Server has problem I ask admin for backup file that he should to do but he has not !!!
so I've to find my backup that last file it's incomplete but I think I try to import some table into my new database
such members table because my member not convenient to apply again.

              Would you mind help me?

              Thanks a lot.

[Looking]

You need to get the proper backup file. good hosts usually make auto backups, see if they may have one from some time back.

[donnpipop]

Of course, now I choose new hosts for my board and hope that is good hosts ^^'

[JimM]

Is this issue solved or do you still require assistance?  Were you able to recover a complete backup and move to a new host?

[donnpipop]

When I insert my members that use sql file for create members to my new board

system show me at my board

Database Error
Please try again. If you come back to this error screen, report the error to an administrator.

How to solve this problem. 

Thank you 

[JimM]

From your question I can only assume that you are taking the portion of your SQL file that pertains to the members table and importing that data.  Is that correct?  You will also need to make sure the auto increment number is set correctly as well.  If you backup included the table structure as well as the data you should be fine with running that portion as a querry to import the data and structure.

Give us a few more details of what you did and how.

[donnpipop]

Yes I'm taking the portion of your SQL file that pertains to the members table and importing that data.
Can I send sql file to you for check error?

Thank you.

[xenovanis]

As long as you're poking around in the database, please post back latest entries in your smf_log_errors table and include the message and the file.

What version of SMF are you using now? Is that the same version as the one you took the backup from?

[donnpipop]

SMF that I'm using is 2.0 RC3
of course it's same version with backup file.

[xenovanis]

As long as you're poking around in the database, please post back latest entries in your smf_log_errors table and include the message and the file.

[JimM]

Yes I'm taking the portion of your SQL file that pertains to the members table and importing that data.
Can I send sql file to you for check error?

Thank you.

If you are still working with this and want me to take a look at the SQL dump, then email it to me.

[donnpipop]

Yes I'm taking the portion of your SQL file that pertains to the members table and importing that data.
Can I send sql file to you for check error?

Thank you.

If you are still working with this and want me to take a look at the SQL dump, then email it to me.

Yes, I want you to take a look at my SQL file, just now I attach it to you.

[xenovanis]

Hey donnipop, don't attach the dump file to your post, but send an email to JimM instead. You'll find his mailaddress in his sig. Your database contains private information on your members, as well as content you'd probably don't want to share.

[JimM]

OK.  Took a look at your SQL file and it is not 2.0RC3.  Instead is is 1.1.x.  The database will need to be upgraded before you can upgrade the forum.  You might be able to import the members table into a test 1.1.12 database and then upgrade it that way.

[donnpipop]

Hey donnipop, don't attach the dump file to your post, but send an email to JimM instead. You'll find his mailaddress in his sig. Your database contains private information on your members, as well as content you'd probably don't want to share.

of cause I sent file to JimM's email to dump file to my post.

[donnpipop]

OK.  Took a look at your SQL file and it is not 2.0RC3.  Instead is is 1.1.x.  The database will need to be upgraded before you can upgrade the forum.  You might be able to import the members table into a test 1.1.12 database and then upgrade it that way.

OK I'll try to install smf 1.1.12 then import members table into database
if it OK then upgrade it to be 2.0RC3

Thank you.

[JimM]

Great.  We'll leave this topic open so you can let us know how it goes.  Just post back if you need additional help.

[donnpipop]

After I install smf 1.1.12 and import members table into database it OK
I found all of members in database ( query on phpmyadmin ) but when I logged smf that I'm admin
I go to members section to check members data. Why data show me in members section is not equal in database?

members in database : 284 Items
data show in members section of smf ("View all members") : 30 Items

I try to use "Search for members" to search some user that I found in database it's OK smf show me after I search
but I surprised why many members not show on "View all members".

Thank you.

[JimM]

After you import the members table, try running the maintenance options from the admin control panel.  Also take a look at the structure of the members table to insure that your next auto increment number is set to 285.  You should be able to see that with phpMyAdmin.   From the structure page, scroll to the bottom and click on Details.

[donnpipop]

Hi JimM, now I can see all of members in "View all members" I think it's OK and I test by register new member
in my smf that id number to be 285.

Another question, field "posts" show me total post of each members. May I should change it to be zero ?
because I install new smf  so nobody post in this smf now. I worry it'll defect my smf.

Now can I upgrade it to be 2.0 ?

Thank you.

[JimM]

If you only imported the members table then I would think you would want to reset all those to the same value that a new member would have just after registering.

Yes, you should be able to run the upgrade now.