PDA

View Full Version : vB Wont shut down... :( eh?


etones
Tue 7th Nov '00, 6:58pm
Hi all, when I enter the control panel and select bbonline as 'No' it doest do anything. This a bug ?

Also, just a side note. Little MqSQL question:

I have a table in database1, how can I copy this to table directly into database2 ?

cheers all

WebStyles
Tue 7th Nov '00, 7:06pm
If you are an admin, you won't see the board closed because admins can always access the forum, but the board is actually closed. This scared me at first too, but then I checked in another browser that had no admin cookies set for me, and I got the closed message. :)

etones
Wed 8th Nov '00, 3:07am
cheers :)

I wish it said this somewhere <G>

Thanks again,

shashi
Wed 8th Nov '00, 5:04pm
as for the mysql question, there are two ways of doing this.
1. if both your dbs are down or not used so to say, (u can be sure of this if u shut down mysql altogether), you can simply COPY the unix files related to the table from db1 to db2.

% cp /path/to/mysql/data/db1/table1.* /path/to/mysql/data/db2/

2. the other is within the database.
log in as a user that has permission on both databases, say as root.
the do this:

delete from db1.table1; (( if you want to replace the data ))

insert into db1.table1 select * from db2.table1;

Note that this will copy the table from db2 to db1
if you want to keep the old data of db1.table1 (which I don't think you do, since you a remost probably copying templates table!! ), then skip teh delete statement above.

etones
Wed 8th Nov '00, 5:07pm
cheers m8, thanks a lot.