Fresh install RN. Want to use existing table info.

Client Joined: Aug 14, 2005 Posts: 151

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.

registered · Posted: Fri Jul 11, 2008 10:22 pm

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

Posted: Sat Jul 12, 2008 12:14 am

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.

Posted: Sat Jul 12, 2008 2:34 pm

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?

Posted: Sat Jul 12, 2008 3:55 pm

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.

Posted: Sat Jul 12, 2008 7:38 pm

select the table and empty it = purge?

Posted: Sat Jul 12, 2008 8:33 pm

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?

Posted: Mon Jul 14, 2008 8:36 am

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