[VoIP] CentOS MySQL

[Lee Spenadel]

I do have MySQL installed.  I tried to import the files via the Webmin
interface and that's where I failed.  I also fired up Samba so I mount the
Linux box in Windows.  I unzipped the zip code files on my Windows PC and
transferred them on to the Linux PC, but that's where my efforts ended after
my inability to get it in to MySQL.  Currently the zip code files reside in
/home/Lee.  



-----Original Message-----
From: voip-bounces at ckts.info [mailto:voip-bounces at ckts.info] On Behalf Of
Shane Young
Sent: Tuesday, January 23, 2007 8:30 AM
To: voip at ckts.info
Subject: Re: [VoIP] CentOS MySQL

Well, let's start from the top.  Do you have mysql installed on your system?

If not, you'll need to get that installed.

You can type "which mysql" to see if mysql is installed.

shane at bridge01:~$ which mysql
/usr/bin/mysql

Assuming it is, you need to get the files onto your system and unzipped.


shane at bridge01:~$ wget http://nerdvittles.com/trixbox123/zipcodes.zip
--07:27:01--  http://nerdvittles.com/trixbox123/zipcodes.zip
            => `zipcodes.zip'
Resolving nerdvittles.com... 70.103.189.89 Connecting to
nerdvittles.com[70.103.189.89]:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 877,924 [application/zip]

100%[=======================================================================
============================================================================
======>] 877,924       
669.83K/s

07:27:03 (667.76 KB/s) - `zipcodes.zip' saved [877924/877924]

shane at bridge01:~$ unzip zipcodes.zip
Archive:  zipcodes.zip
   inflating: zipcodes1.sql
   inflating: zipcodes2.sql
shane at bridge01:~$ mysql -u root -p < zipcodes1.sql Enter password:
shane at bridge01:~$ mysql -u root -p < zipcodes2.sql Enter password:
shane at bridge01:~$

Try that and let me know how far you get.



Quoting Lee Spenadel <lee at spenadel.com>:

> Thanks for the reply Shane.  I'm trying to get a weather by zip code 
> application up on Asterisk as a dial extension.  I found the 
> instructions at http://nerdvittles.com/index.php?p=160
>
> However, the instructions reference certain programming interfaces 
> that would be installed on a TriBox PBX.  So the problem that I'm 
> having is getting the zip code data in to a MySQL database.  I still 
> have no clue how I'll get the AGI script working, if it will even work 
> in my PBX, but right now the script can't even read the zip code data 
> because I couldn't import it properly.  The TriBox PBX has this nice 
> import feature in to MySQL that our version of Asterisk doesn't.  Not 
> being a programming guru, especially in C, Pearl, etc, I was lost.
>
> I've attached the zip code archive.  There are two files that I need 
> to get in to MySQL, unfortunately I do not know the format of the 
> file; csv, how many fields, etc.
>
> Let me know what, if anything, you can do.
>
> Thanks
> Lee
>
> -----Original Message-----
> From: voip-bounces at ckts.info [mailto:voip-bounces at ckts.info] On Behalf 
> Of Shane Young
> Sent: Tuesday, January 23, 2007 6:33 AM
> To: voip at ckts.info
> Subject: Re: [VoIP] CentOS MySQL
>
> I can help.  Tell me more...
>
>
> Quoting Lee Spenadel <lee at spenadel.com>:
>
>> Does anyone have experience with MySQL?  I'm trying to launch a 
>> weather application on my Asterisk box and am having trouble 
>> importing the zip code files in to a MySQL database.  Offers of help are
welcome.
>>
>
>
>
> _______________________________________________
> VoIP mailing list
> VoIP at ckts.info
> http://lists.ckts.info/mailman/listinfo/voip
> Project Web Page: http://www.ckts.info/
>
>
>
> _______________________________________________
> VoIP mailing list
> VoIP at ckts.info
> http://lists.ckts.info/mailman/listinfo/voip
> Project Web Page: http://www.ckts.info/
>
>





_______________________________________________
VoIP mailing list
VoIP at ckts.info
http://lists.ckts.info/mailman/listinfo/voip
Project Web Page: http://www.ckts.info/