Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.02.02 Distro
Author Message
xtone
Regular
Regular


Joined: Nov 11, 2006
Posts: 73

PostPosted: Mon Dec 04, 2006 11:44 am Reply with quote

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.
 
View user's profile Send private message
evaders99
Former Moderator in Good Standing


Joined: Apr 30, 2004
Posts: 3221

PostPosted: Mon Dec 04, 2006 1:50 pm Reply with quote

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

_________________
- Only registered users can see links on this board! Get registered or login! -

Need help? Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
xtone
PostPosted: Tue Dec 05, 2006 12:48 am Reply with quote

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.
 
evaders99
PostPosted: Tue Dec 05, 2006 8:40 am Reply with quote

The users table Smile
 
xtone
PostPosted: Tue Dec 05, 2006 8:52 am Reply with quote

DUDE!!! i am talking about the tables name what is the name of the table which i have to export.
 
evaders99
PostPosted: Tue Dec 05, 2006 11:55 am Reply with quote

It is WHATVER_users
 
FireATST
RavenNuke(tm) Development Team


Joined: Jun 12, 2004
Posts: 637
Location: Ohio

PostPosted: Tue Dec 05, 2006 1:57 pm Reply with quote

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
 
View user's profile Send private message Visit poster's website MSN Messenger ICQ Number
xtone
PostPosted: Sat Dec 09, 2006 1:33 am Reply with quote

i am exporting Nuke_Users file so i get this screen.

Image

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.
 
gregexp
The Mouse Is Extension Of Arm


Joined: Feb 21, 2006
Posts: 1497
Location: In front of a screen....HELP! lol

PostPosted: Sat Dec 09, 2006 3:58 pm Reply with quote

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.

_________________
For those who stand shall NEVER fall and those who fall shall RISE once more!! 
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number
Guardian2003
Site Admin


Joined: Aug 28, 2003
Posts: 6793
Location: Ha Noi, Viet Nam

PostPosted: Sat Dec 09, 2006 4:59 pm Reply with quote

You'll need to select the option 'complete inserts' if you want to copy the data inside all your tables.
 
View user's profile Send private message Send e-mail
xtone
PostPosted: Sun Dec 10, 2006 2:49 am Reply with quote

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
 
Guardian2003
PostPosted: Sun Dec 10, 2006 4:43 am Reply with quote

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.
 
xtone
PostPosted: Mon Dec 11, 2006 2:23 am Reply with quote

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
-- Only registered users can see links on this board! Get registered or login!
--
-- 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 ]
 
Guardian2003
PostPosted: Mon Dec 11, 2006 5:45 am Reply with quote

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.
 
evaders99
PostPosted: Mon Dec 11, 2006 8:59 am Reply with quote

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.
 
xtone
PostPosted: Mon Dec 11, 2006 9:55 am Reply with quote

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.
 
Donovan
Client


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

PostPosted: Tue Dec 12, 2006 5:34 pm Reply with quote

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.
 
View user's profile Send private message Visit poster's website ICQ Number
Display posts from previous:       
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.02.02 Distro

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©