Uutiset:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu
Advertisement:

Move one smf_members to another database via export/import

Aloittaja extrovertz, heinäkuu 13, 2011, 02:24:38 IP

« edellinen - seuraava »

extrovertz

I messed up my original smf and reinstalled. I now have a back up copy so this won't happen again. I also found that many of my themes do not work well with my version 1.1.4

I went to my old database which is still a database in mySQL using myPHPadmin I tried to export the smf_members to a sql file and import that to the new database. It pauses and then just goes blank. Not sure if I am doing it right. Then I also tired a cvs but get an error when trying to import:

SQL query:

"1","extrovertz","1295533615","0","1",,"1310145627","extrovertz","0","0",,,,"adf9aba1f46c266ad303a941db8a41226b2a47ab","[email protected]",,"0","0001-01-01",,,,,,,,"0","1",,,"0",,"0","0","0",,"1","1","0","2","63.99.220.65","63.99.220.65",,,"6","1",,"3",,,"0","3692","e34e" "2","TheSalvageRepairMan","1295621334","2","0",,"1309884279","TheSalvageRepairMan","0","0",,,,"495c26cd90c56bc9c03c6c04e012124422f0d451","",,"0","0001-01-01",,,,,,,,"1","1",,,"0",,"1","0","0",,"1","1","0","2","63.99.220.65","63.99.220.65",,,"6","1","a858296177","3",,,"4","271","2dfa" "3","sthalialoweryz","1297193747","0","0",,"0","sthalialoweryz","0","0",,,,"4e028c4d30bf6ca05d3817c8144a818f0e0d2b40","th",,"0","0001-01-01",,,,,,,,"0","1",,,"0",,"1","0","0",,"1","1","0","2","184.107.21.137","184.107.21.137",,,"6","1",,"0",,,"4","0","a4fa" "4","JoaeNNa","1297246224","0","0",,"0","JoaeNNa","0","0",,,,"535264c0468fada0811ca1120e1dc010258b6d3f","li.[...]

MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"1","extrovertz","1295533615","0","1",,"1310145627","extrovertz","0","0",,,,"adf' at line 1

Any way to get my members from my old database to my new one so I can have them in the smf I now have?

After looking back I could have just gone into admin but the screen was blank after applying a theme. I am new, but learning fast. Thank you.

Advertisement: