table.sql

Client Joined: Jan 29, 2004 Posts: 624

Hello, I'd like to install the Who is Where mod but I'm a little confused...

INSTALLATION

-Import content of table.sql in your database.

How do I import the contents of table.sql?

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Using phpMyAdmin, copy and paste it into your SQL tab for your database. Then select Go.

Posted: Fri Feb 13, 2004 4:54 pm

Thanks, Raven, this clarifies it.

Posted: Fri Feb 13, 2004 11:07 pm

Worked like a charm. Now I know how to import the things. Smile

Posted: Fri Feb 13, 2004 11:13 pm

Great! Another way is to click the Browse button in the sql window, select the file from the open window dialog and then click Go. That way you don't have to do a copy and paste. And yet a third way, which is best for large files, is to create an upload directory and set the setting
$cfg['UploadDir'] = './uploads/';
or whatever you want to name it. Then, copy the sql file to that directory and select it from the sql window. That way, the file isn't transfered from your pc to the sql server. It is loaded right from the same server where the database is.

Posted: Fri Feb 13, 2004 11:26 pm

I'm getting a good education here. Smile

Thanks!

Posted: Thu Mar 04, 2004 10:36 pm

Back to foolin' with SQL... how do I 'insert' a table into an existing database? I'm trying to put a radio on my site and it says insert table...

Code:




DROP TABLE IF EXISTS `nuke_radio`;


CREATE TABLE `nuke_radio` (


  `radio_id` int(10) unsigned NOT NULL auto_increment,


  `radio_name` varchar(150) NOT NULL default '',


  `radio_stream` varchar(150) NOT NULL default '',


  `radio_url` varchar(150) NOT NULL default '',


  `radio_picture` varchar(50) NOT NULL default '',


  `radio_language` varchar(30) NOT NULL default '',


  PRIMARY KEY  (`radio_id`)


) TYPE=MyISAM;

OK, I did that. Now:

Code:




INSERT INTO `nuke_radio` (`radio_id`, `radio_name`, `radio_stream`, `radio_url`, `radio_picture`, `radio_language`) VALUES (2, 'Radio Italia Network', 'mms://wmedia.rin.it/rin', 'http://www.progettovincita.com', '', ''),


etc. for another 120 or so stations

There is one more create table/insert table after these but first things first!

Posted: Thu Mar 04, 2004 10:38 pm

Copy and paste all insert statements into phpMySQL SQL window.

Posted: Thu Mar 04, 2004 10:42 pm

Can't be that simple, can it?! OK, off I trot...

Posted: Fri Mar 05, 2004 12:40 am

Worked fine, I've got a bodacious bunch of foreign language radio stations now... my girlfriend told me to turn down the racket. Embarassed

One little problem is a big advertisement for... webhosting... that throws off the alignment of the page, so I deactivated the radio til I can remove that. Thanks for the SQL education, Raven!

Posted: Fri Mar 05, 2004 4:59 am

Just visited your site (it's been a while). Lookin' very nice. Congratulations! Have you, perchance, applied any of the speed-up techniques that we have talked about in this thread http://www.ravenphpscripts.com/postt1033.html ?

Posted: Fri Mar 05, 2004 9:55 am

Not yet, but it's a very interesting idea and I'll give it a try. Smile

Anything I find I'll post in the other thread.

Posted: Fri Mar 05, 2004 4:13 pm

Raven wrote:

Just visited your site (it's been a while). Lookin' very nice. Congratulations!

I appreciate your kind words but much of the credit for my small success with my site is owed to my hostmaster, and to certain others in the nuke community. Smile