Transfere users from 1 db to another

Regular Joined: Nov 11, 2006 Posts: 73

i want to transfere all users from one db to another can any one help me please y one the same host not on another host.

registered · Posted: Mon Dec 04, 2006 1:50 pm

Use phpMyAdmin and export all your tables. On the new host, use phpMyAdmin to import those tables (in the SQL box). If importing a large file, consider using Big Dump instead

Posted: Tue Dec 05, 2006 12:48 am

i only want to export the users if post can be export then it would be better can you tell me which is the table for users where all the users are stored first i would like to export olny users.

Posted: Tue Dec 05, 2006 8:40 am

The users table Smile

Posted: Tue Dec 05, 2006 8:52 am

DUDE!!! i am talking about the tables name what is the name of the table which i have to export.

Posted: Tue Dec 05, 2006 11:55 am

It is WHATVER_users

Posted: Tue Dec 05, 2006 1:57 pm

lol Evaders99..... killing me

That is a classic. (I feel like I am watching the movie "Fast times at Ridgemont High)..... Smile

xtone....as evaders99 stated the table name is users so it will show as nuke_users..... Smile

Posted: Sat Dec 09, 2006 1:33 am

i am exporting Nuke_Users file so i get this screen.

which options do i have to select to export all Users and whn i import the Nuke_Users file to my new db will i get any error on that point.

Posted: Sat Dec 09, 2006 3:58 pm

It looks like your settings are correct, Just click go, and youll see a page that has a text box, copy all thats within that text box, and boom, youve got all the users.

On a more direct and offsubject note, people are only trying to help, your frustration is understandable but its not evaders or anyone elses fault.
The reason evaders was so vague was due to the fact that $user_prefix is used to tell the name of the table. So your tablenam could be anything_users.
And there is only one $user_prefix._users table, thus the users table.
Just thought you should know. Hopfully youll get all this sorted out.

Posted: Sat Dec 09, 2006 4:59 pm

You'll need to select the option 'complete inserts' if you want to copy the data inside all your tables.

Posted: Sun Dec 10, 2006 2:49 am

i've emportedall the user like u said i clicked go and went to a text box and copy all the text which were all the users info now how can i import all the users to my user table please tell briefly.

Thankx :d

Posted: Sun Dec 10, 2006 4:43 am

Create your new database name if it doesnt already exist. In phpmyadmin select this new database in the left hand drop down.
Once the page refreshes, look along the top of the page and click the SQL tab.
Once the page refreshed just paste you old data into the window and hit GO.

Posted: Mon Dec 11, 2006 2:23 am

i already have a data base installed,i get this error when i paste this in SQL query:

Server: localhost Database: xtone_rn76v202
Error
SQL query:

-- phpMyAdmin SQL Dump
-- version 2.9.0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 11, 2006 at 02:31 AM
-- Server version: 4.1.21
-- PHP Version: 4.4.2
--
-- Database: `xtone_rn76v202`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_users`
--
CREATE TABLE `nuke_users` (

`user_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`name` varchar( 60 ) NOT NULL default '',
`username` varchar( 25 ) NOT NULL default '',
`user_email` varchar( 255 ) NOT NULL default '',
`femail` varchar( 255 ) NOT NULL default '',
`user_website` varchar( 255 ) NOT NULL default '',
`user_avatar` varchar( 255 ) NOT NULL default '',
`user_regdate` varchar( 20 ) NOT NULL default '',
`user_icq` varchar( 15 ) default NULL ,
`user_occ` varchar( 100 ) default NULL ,
`user_from` varchar( 100 ) default NULL ,
`user_interests` varchar( 150 ) NOT NULL default '',
`user_sig` varchar( 255 ) default NULL ,
`user_viewemail` tinyint( 2 ) default NULL ,
`user_theme` int( 3 ) default NULL ,
`user_aim` varchar( 18 ) default NULL ,
`user_yim` varchar( 25 ) default NULL ,
`user_msnm` varchar( 25 ) default NULL ,
`user_password` varchar( 40 ) NOT NULL default '',
`storynum` tinyint( 4 ) NOT NULL default '10',
`umode` varchar( 10 ) NOT NULL default '',
`uorder` tinyint( 1 ) NOT NULL default '0',
`thold` tinyint( 1 ) NOT NULL default '0',
`noscore` tinyint( 1 ) NOT NULL default '0',
`bio` tinytext NOT NULL ,
`ublockon` tinyint( 1 ) NOT NULL default '0',
`ublock` tinytext NOT NULL ,
`theme` varchar( 255 ) NOT NULL default '',
`commentmax` int( 11 ) NOT NULL default '4096',
`counter` int( 11 ) NOT NULL default '0',
`newsletter` int( 1 ) NOT NULL default '0',
`user_posts` int( 10 ) NOT NULL default '0',
`user_attachsig` int( 2 ) NOT NULL default '0',
`user_rank` int( 10 ) NOT NULL default '0',
`user_level` int( 10 ) NOT NULL default '1',
`broadcast` tinyint( 1 ) NOT NULL default '1',
`popmeson` tinyint( 1 ) NOT NULL default '0',
`user_active` tinyint( 1 ) default '1',
`user_session_time` int( 11 ) NOT NULL default '0',
`user_session_page` smallint( 5 ) NOT NULL default '0',
`user_lastvisit` int( 11 ) NOT NULL default '0',
`user_timezone` tinyint( 4 ) NOT NULL default '10',
`user_style` tinyint( 4 ) default NULL ,
`user_lang` varchar( 255 ) NOT NULL default 'english',
`user_dateformat` varchar( 14 ) NOT NULL default 'D M d, Y g:i a',
`user_new_privmsg` smallint( 5 ) unsigned NOT NULL default '0',
`user_unread_privmsg` smallint( 5 ) unsigned NOT NULL default '0',
`user_last_privmsg` int( 11 ) NOT NULL default '0',
`user_emailtime` int( 11 ) default NULL ,
`user_allowhtml` tinyint( 1 ) default '1',
`user_allowbbcode` tinyint( 1 ) default '1',
`user_allowsmile` tinyint( 1 ) default '1',
`user_allowavatar` tinyint( 1 ) NOT NULL default '1',
`user_allow_pm` tinyint( 1 ) NOT NULL default '1',
`user_allow_viewonline` tinyint( 1 ) NOT NULL default '1',
`user_notify` tinyint( 1 ) NOT NULL default '0',
`user_notify_pm` tinyint( 1 ) NOT NULL default '0',
`user_popup_pm` tinyint( 1 ) NOT NULL default '0',
`user_avatar_type` tinyint( 4 ) NOT NULL default '3',
`user_sig_bbcode_uid` varchar( 10 ) default NULL ,
`user_actkey` varchar( 32 ) default NULL ,
`user_newpasswd` varchar( 32 ) default NULL ,
`points` int( 10 ) default '0',
`last_ip` varchar( 15 ) NOT NULL default '0',
PRIMARY KEY ( `user_id` ) ,
KEY `uid` ( `user_id` ) ,
KEY `uname` ( `username` ) ,
KEY `user_session_time` ( `user_session_time` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =131;

MySQL said:

#1050 - Table 'nuke_users' already exists

[ Back ]

Posted: Mon Dec 11, 2006 5:45 am

What is the name of your new empty database that you are transfering the data into?
If it is not xtone_rn76v202 then you will need to change that in the sql statement you are pasting.

Posted: Mon Dec 11, 2006 8:59 am

You do not need to export the structure of your users table. Just the data.

However the structure of your users table must match. If you are going from different phpNuke versions, you will need to run the upgrade scripts to upgrade your tables or manually do the changes.

Posted: Mon Dec 11, 2006 9:55 am

i am usign the RavenNuke76 v2.02.02 Distro and my old db table was on php-nuke 7.9 but i ran the downgrade script and converted it into 7.6 unpatched now my old table from which i copied the user table text was xtone_nuke1 i changed it to that xtone_rn76v202 when i paste it into the sql query and get the above error.

Do i need to delete the nuke_users table from my new db and replace it with my this one.

Client Joined: Oct 07, 2003 Posts: 735 Location: Ohio

Dump the structure only from both the old and new databses and do a compare. They must be excactly the same. If they are identical then dump the data only from your old table and import into the new database table.

Sometimes I had to do this table by table to move my entire forums and users over to a new install.