Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff
Author Message
manoe
Client


Joined: Aug 14, 2005
Posts: 151

PostPosted: Fri Jul 11, 2008 8:43 pm Reply with quote

Hey all. I am setting up another RN site. I want to use the tables from an existing site I have. I need to practice this and I have a few questions.

1) Do the new tables have to be named exactly what the current tables are on the site I am taking the table info from?

2) Do I use phpMyAdmin to export the table and then inport the data into the new table of the new site?

this should get my started.
 
View user's profile Send private message
evaders99
Former Moderator in Good Standing


Joined: Apr 30, 2004
Posts: 3221

PostPosted: Fri Jul 11, 2008 10:22 pm Reply with quote

1) No the tables can have a different table prefix (as long as you change it in config.php)

2) Yes you can do it that way. If phpMyAdmin has access to both databases, it can copy data directly between them

_________________
- 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
manoe
PostPosted: Sat Jul 12, 2008 12:14 am Reply with quote

ok, I have everything set up. When I created the admin for nuke sentinel I wrote that username and password now.

Now it is asking me to log in with my Nuke Sentinel user and pass which I "thought" I had... It will not accept it.

So, one thing I know is that when I clicked scan for new admins in the setup I did not manually check to see that the password for that admin account in Sentinel had the correct User and Password in it from the setup.

Well it is not accepting it.

I guess my question is what do I do now if I cannot log in as the sites admin because I cannot get by the sentinel login? Is there a manual way to enter the admin user and password in the admin auth list in the sentinal acp.
 
manoe
PostPosted: Sat Jul 12, 2008 2:34 pm Reply with quote

I have been trying different things to familiarize myself with phpmyadmin. I have exported parts of databases and an entire database. When I try to import these to the new sites database I get errors like this one below.

Code:
Error


SQL query:

--
-- Dumping data for table `financial`
--
INSERT INTO `financial` ( `id` , `date` , `num` , `name` , `descr` , `amount` )
VALUES ( 2, '2003-08-28 00:00:00', '', 'hostmenow', 'Web hosting for 1 year', '-59.4' ) , ( 3, '2003-08-29 00:00:00', '', 'GameServHost', 'Game server colo', '-200' ) , ( 5, '2003-09-01 00:00:00', '', 'PayPal IPN', 'Auto reconcile', '267.94' ) ;

MySQL said: Documentation
#1062 - Duplicate entry '2' for key 1


If I just wanted the forums moved over do I simply copy the BB tables? If I do the entire database I will get users and all right? I have the entire database exported and saved out to my desktop. The question is how do I import it into the databases I have AND avoid the above error?
 
evaders99
PostPosted: Sat Jul 12, 2008 3:55 pm Reply with quote

You have some duplicate data in those tables. If you wanted to import the current data, you'd have to purge the old data.

The forums are the BB tables, however they require the users table as well.
 
manoe
PostPosted: Sat Jul 12, 2008 7:38 pm Reply with quote

select the table and empty it = purge?
 
manoe
PostPosted: Sat Jul 12, 2008 8:33 pm Reply with quote

Ok I have the forums loaded. The users from the current site are called nuke_common_users and the new site is called nuke_users.

The exported nuke_common_users inports fine but they are not showing up in the forums.

Do I need to rename something? Can I just not import the users from nuke_common_users into nuke_users?
 
manoe
PostPosted: Mon Jul 14, 2008 8:36 am Reply with quote

Finally I have conquered this. I found that it worked best when I did table at a time. When I would try to do the entire database things would mess up. I also never dumped the tables I was importing the old tables into.

1) I dumped / emptied the new table
2) Exported the old users and all the bb tables.
3) Imported them to the new database and edited the config.php file to reflect the new users table name...


BINGO!!!
Thanks for the help... Its really all about trial and error. When I have a new site to actually do the trial and error on I feel much safer Smile
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff

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 ©